Summary of few articles from SQLHub.com

I am not blogging in this wordpress blog since long time but very active in SQLHub.com. Even I am not updating this blog now, I am still getting comment from readers in my old articles here so I thought to share one small summary of those articles which are not available in this blog but I wrote in SQLHub.com.

I had written few articles about Index in SQL Server and have received very good feedback from the user. It has covered up Basics about clustered and nonclustered Index, Included column Index, and filtered column index ,  rebuild and reorganize index and few information about statistics of Index. You can read those articles from here.

Sp_RefreshSQLModule to refresh metadata of your object.

There is new feature in SQL Server Denali which is “With Result Sets”, you can read about it from here.

Merge statement is really very helpful when you want to use Insert/Update/Delete combo based on some conditions. Read more.

CUBE and ROLLUP are very powerful tool when you want make total and grand total of your result sets based on some condition, read more.

To fix orphan user, there is one small TSQL script, this is useful especially when you move your database from one SQL Server to another. Read more.

DAC: DAC could become a real life savior for SQL Server DBA in some extreme critical situation when you are not able to connect to your SQL Server instance by any other way or you found you instance totally unresponsive, you can use DAC connection. Read more.

Sometime it happens that you are not able to upload file which is greater than 4MB to your SQL Server database from asp.net, you need to set value of httpRuntime. Read more.

Some interesting stuffs about HttpEndPoint in SQL Server.

Link server is really important when you wish to import/export data directly from your SQL Server to/from any database/format which supports OLEDB. Read more

Pivot is really very useful feature in SQL Server and I have written few different examples of the same, have a look

I have written some interesting basics about ISOLATION in SQL Server in part. Here is the list of the same.

http://www.sqlhub.com/2009/03/different-types-of-isolation-levels.html

http://www.sqlhub.com/2009/03/different-types-of-isolation-levels_15.html

http://www.sqlhub.com/2009/03/different-types-of-isolation-levels_5757.html

COMPUTE clause for subtotal. Read more.

I have written series of Encryption and Decryption articles in 7 parts. All part listed with complete practical example at here. If you want to go to each individual article, look at below given links.

Encryption – Decryption in SQL Server 2008 Part 1

Service Master Key (Encryption – Decryption in SQL Server 2008 Part 2)

Database Master Key (Encryption – Decryption in SQL Server 2008 Part 3)

Certificate (Encryption – Decryption in SQL Server 2008 Part 4)
Asymmetric Key (Encryption – Decryption in SQL Server 2008 Part 5)

Symmetric Key (Encryption – Decryption in SQL Server 2008 Part 6)

If you want to know FULL Text Search, must read following three articles.

http://www.sqlhub.com/2009/03/full-text-search-in-sql-server-2005.html

http://www.sqlhub.com/2009/03/full-text-search-in-sql-server-2005_16.html

http://www.sqlhub.com/2009/03/full-text-search-in-sql-server-2005_3854.html

Good example of BCP, Bulk copy, XP_CmdShell given here.

Grouping Sets could be brother of CUBE and ROLLUP command.  Read more

Audit is really one of the interesting, useful yet difficult to maintain topic in history of SQL Server, read list of articles on the same from here.

You can do Auditing with OUTPUT clause too. Read it

List of some articles on XML with SQL Server.

XML Path Root

Read Typed XML in SQL Server

Load relational XML data

Read XML node on same level

Return comma separated value with “For XML Path”

update UnTyped XML data column

Reference: Ritesh Shah


http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
 http://www.SQLHub.com

Ask me any SQL Server related question at my “ASK Profile

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: