Some of the moderators over at the MSDN SQL Server Forums have got together and collated a reference of solutions to common T-SQL problems. As always, all quality resources get added to the SQL Server Resrouces area of this site.
Posts from ‘June, 2009’
The Definitive Introduction to SQL Server Indexes
It normally is not my style to write a blog post solely about a particular article someone else has published. Typically I just go ahead and add quality resources to the SQL Server Resources area of this site that I have either found myself or had recommended to me. In this case however an exception [...]
SQL Server Index Defrag Script: Update
Michelle Ufford (aka SQLFool) has released an update to her excellent index optimisation script. If you are not already using something similar to simplify your index optimisation database maintenance processes then you will find this to be extremely useful. Check it out here: Index Defrag Script, V3.0 Michelle Ufford (aka SQLFool) has released an update [...]
Superb listing of free SQL Server tools
Paul Randal pointed me in the direction of an awesome resource list of FREE SQL Server tools. There is an absolute mountain of quality stuff here and I wanted to share it with you all. Free SQL Server Tools that might make your life easier Be sure to me know which resources you use and [...]
Generate a random number in SQL Server
What is the best way to efficiently generate a random number in SQL Server? One of my favourite SQL Server authors, Michelle Ufford recently posted her method for generating a random number, in the post Random Number Generator in T-SQL. This got me thinking and I decided to do a little investigation of my own [...]
DMV Query to identify all active SQL Server Sessions
You may already be aware that I am a big advocate of the SQL Server Dynamic Management Views (DMV’s) and the benifits that they bring to the Database Administrator. They certainly came in handy with a requirement I had recently whereby I needed to identify the IP Address of a specific SQL Server Login and [...]
