Interesting fix was released today, your WRITE performance might be poor due to incorrect priority in DPC in Windows 2008 R2. If you have write
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
Microsoft Support policy for SQL Server in Windows 8 and Windows 2012
Now that Windows 8 (which btw ROCKS!) and Windows 2012 is out, Microsoft has released a KB highlighting the support for SQL Server in respect
Calculating Datetime Based on NT Time
A colleague of mine gave me an interesting challenge today. I am by no means a T-SQL expert, however it was interesting dissecting the problem.
Using sys.dm_io_virtual_file_stats DMF to get IPOS and BPS
SQL Server keeps track of all the reads and writes it submits to the operating system (OS). It records this information in sys.dm_io_virtual_file_stats DMF. We
Setting up iSCSI Target and Initiator
I am sure everyone has realized, when it comes to configure Servers I am the last person that should get near them. I am good
Online Index Operation – Doc Bug –
In SQL Server 2012, Index Online operation is supported for VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX), and XML. However the ALTER INDEX states it is not supported. In
SQL Canada (SQLCAN) 