SQL Server 2012 Licensing Changes
One of the big changes in the SQL Server 2012 licensing plans is the price is now per core, and not per processor. So previously if you had a SQL Server with 2 procesors (8 cores each), you paid for …
One of the big changes in the SQL Server 2012 licensing plans is the price is now per core, and not per processor. So previously if you had a SQL Server with 2 procesors (8 cores each), you paid for …
This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database restore, including log backups, it is very important to get the log chain in the …
Over the last couple of weeks I have taken a couple of the common queries that I use to analyze the health of a SQL Server and built them out into a SQL Server 2008 SSRS report. I have decided …
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008, and 2008R2. This really depends on a number of factors, but generally the answer is …
This week I am in Las Vegas attending the DevConnections conference on the SQL Server track.
One of the common task that I have come across is the need to convert a list of results into a comma separated list. There are many ways to use this, one if which is in reports. Download the AsCSV.sql …
Converting part of a result set to a comma separated list Read more »
A restore plan of course is far more important than the backup plan. When things go wrong and you need to restore a database backup, that is not the time to be learning how to do a restore, or to …
SQL 2012 is being referred to by Microsoft as code name Denali.
I needed a way to list of of the indexes for an entire database, but I was running into a problem using sys.indexes that I could only see the indexes for the current database. Below is the solution that I …
Finding the names of all indexes on a SQL Server Read more »
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it really comes down to is speed, for tables with a large number of rows, and …