Using a date or int column as the clustered index.

The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on...

DacFX Links

I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...

DacFX Links

I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...

DacFX Links

I thought it would be a good idea to gather together a list of links for DacFx, blogs code or articles - if you have anything that you think...

Make Visual Studio Setup Slightly Faster

If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...

Make Visual Studio Setup Slightly Faster

If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...

Make Visual Studio Setup Slightly Faster

If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the setup files.
The BITS service is used to download files...

SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

SQL Server – Ports used by Database Engine and other SQL Features

Most of us know the default port for SQL Server is 1433, but there are various ports being used by SQL Server...

How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75

 
When you do  SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER...