Just how awesome are table parameters in SQL Server 2008?
I would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure. While we have been able to do this in the past, by using XML to pass more than one value in, then break it […]
Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)
SQL Server 2005 introduced us to Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files). While this is great when creating your database, or extending your database files there is a cost to doing so. Before each […]
SQL Clustering Article in SQL Server Magazine
For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven’t already). When you do be sure to check out the article which I have in the magazine about clustering your SQL Server. For those without a subscription you can sign up for a […]
Webcast: SQLServerPedia.com — The Definitive SQL Server Knowledge Base
Gain access to SQL Server experts and learn more about SQLServerPedia.com by attending this webcast. SQLServerPedia.com is the free reference resource created for SQL Server professionals, by SQL Server professionals. See how you can access video training, as well as sample scripts for backup and recovery, index maintenance and performance tuning. Plus, boost your SQL […]