Capturing session_id scheduler assignment using SQLCMD Mode
Yesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions. I was tracking wait statistics
Yesterday I was working on a SSMS SQLCMD-mode script and I noticed that periodically my session_id changed across test executions. I was tracking wait statistics
The DBMIRROR_DBM_MUTEX wait type is undocumented. Or rather, it is documented in books online as being “Identified for informational purposes only. Not supported. Future compatibility
You may have already heard that SQL Server 2012 adds automatic generation of statistics for AlwaysOn availability group readable secondaries, storing the statistics in tempdb.
I gave a presentation on columnstore indexing last week and one question I received was regarding the performance of a (hypothetical) narrow, supporting nonclustered index
When moving from SQL Server 2008+ to SQL Server 2012, be aware that the sampling algorithm has changed. For example, I created a partitioned clustered
I was interested in exploring various questions about columnstore indexing this morning – and I realized I should probably blog about what I observed. This
This post idea was prompted by a discussion I had this week with Jonathan Kehayias about an environment that had multiple transactional replication publications defined
Last month I wrote a post called Hash Partitioning with SQL Server 2012’s SEQUENCE object and CYCLE argument and I was asked a good question
Consider the following scenario: · You have Transactional Replication deployed · Data is flowing, but just not as fast as you would like · This
Let’s say you’ve “disabled” parallelism on your SQL Server instance via the ‘max degree of parallelism’ setting as follows: EXEC sp_configure‘max degree of parallelism’, 1
I use Windows 7 as my laptop host OS and this limits me from using Hyper-V natively to handle VM guests. Yes, I could
When I first heard about SQL Server 2012’s SEQUENCE object – I thought it was an interesting feature to be added and one that I
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.