Welcome to MSDN Blogs Sign in | Join | Help

December 2008 - Posts

Some notes on database snapshots

Overview I recently conducted some tests to double check the exact behavior of database snapshots when: Snapshots are created on volumes which are much smaller than the actual database size Metadata-only operations such as DROP TABLE are executed DDL Read More...
Posted Wednesday, December 31, 2008 7:29 AM by arvindsh | 1 Comments
Filed under:

Howto: Have a Clustered instance of SQL Server listen on multiple virtual IP addresses

Recently a colleague asked me if there were any changes specific to Windows Server 2008 which allow SQL Server (clustered instance) to listen on multiple subnets. There was only one change in Windows 2008 to my knowledge (which I have detailed in this Read More...
Posted Tuesday, December 30, 2008 11:03 AM by arvindsh | 0 Comments

Concurrency of Full, Differential and Log backups on the same database

Overview Many a time, we are asked by customers about the effect of overlapping backup schedules: for example, whether they can backup the transaction log at the same time that a long-running complete backup of the database is taking place. Books Online Read More...
Posted Tuesday, December 30, 2008 9:44 AM by arvindsh | 1 Comments

SQL Server setup log locations and more

In order to efficiently troubleshoot problems involving failed setup, we need to use the setup logs. Once you know where the log files are located, you can start troubleshooting. What to look for in the log files is a separate topic in itself, but at Read More...
Posted Monday, December 22, 2008 11:40 AM by arvindsh | 1 Comments
Filed under:

Windows, SQL Server and Multi-Core / Hyper-Threading

Very often we get asked a question about 'how many processors does my SQL Server 200x Edition really support'. This post hopes to summarize the considerations and actual limits. SQL Licensing is per socket First, let's take a look at the Books Online Read More...
Posted Friday, December 19, 2008 7:27 AM by arvindsh | 3 Comments
Filed under:

T-SQL Anti-pattern of the day: 'all-in-one' queries

Scenario A common requirement for enquiry queries on an OLTP database is to have search criteria which are very specific ('get me details for for OrderID = NNNN') and also the occasional reports which ask for all the orders ('get me all the orders, no Read More...
Posted Friday, December 19, 2008 5:29 AM by arvindsh | 7 Comments
Filed under:

T-SQL Anti-pattern of the day: comparing DATETIME field with date-only literal

Scenario It is a pretty common situation to have transaction date-time stored in a DATETIME field. The problems start with the fact most applications used GETDATE() or some such equivalent at the client side to record the order date-time stamp. So a typical Read More...
Posted Tuesday, December 02, 2008 8:19 AM by arvindsh | 1 Comments
Filed under:
 
Page view tracker