Tale of the Inconsistent UDF Logical IOs
This post was motivated by an email question I got this week. Imagine you have the following scalar UDF: CREATE FUNCTION dbo.RemoveYear (@date datetime) RETURNS
This post was motivated by an email question I got this week. Imagine you have the following scalar UDF: CREATE FUNCTION dbo.RemoveYear (@date datetime) RETURNS
Let’s say you have a heap table with 1,000,000 rows in it. Let’s also say that your automatic creation of statistics are disabled, as well
This post is just a reminder to be attentive to the locking overhead of your Transact-SQL server cursors. For example, the following cursor is using
Last November I blogged about how index usage stats don’t get updated when the associated index statistics (but not index) are used. This post will
Let’s say you are querying a partitioned table and you would like to see which partitions were accessed by looking at the graphical execution plan:
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
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
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.