Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display
Today we will look something which is very quick and but quite frequently useful string operation over numeric datatype. This article is written based on a question asked by one of the users (name not disclosed as per request). Let us see how to show a fixed width number display.Â
SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup
The most interesting thing about writing blog at SQLAuthority.com is follow up question. Just a day before I wrote article about SQL SERVER – Restore Master Database – An Easy Solution, right following it, I received email from user requesting reason for importance of backing up master database. Master database…
Read MoreSQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005
I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XML, so if you are interested in XML please visit his blog here. If you are interested in performance optimization for XML Data type in SQL Server following article is must…
Read MoreSQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster
Microsoft has published SQL Server 2008 System Views Poster. This poster should be must have poster for any SQL Server Developer. I have this poster on my wall. If you have extra copy of this postered in print. Do send it to me and I will forward it to developer…
Read MoreSQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2
Just another day I was playing with my query which I posted earlier SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL and I found that I got error devide by zero. I have fixed this error in following query as well I have updated query…
Read More