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.
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”