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
Index_Name Function for SQL Server
We have the database_name, object_name, object_schema_name but don’t have index_name. So when accessing information in sys.dm_db_index_usage stats, it becomes troublesome to find out index name