SQL Server Pro article–“Getting Started with Transactional Replication”
I wrote a beginner’s article for Transactional Replication which was published in the July 2012 edition of SQL Server Pro: “Getting Started with Transactional Replication”
I wrote a beginner’s article for Transactional Replication which was published in the July 2012 edition of SQL Server Pro: “Getting Started with Transactional Replication”
The SQL CAT team identified three common patterns for customers who were actively testing and deploying SQL Server 2012 high availability and disaster recovery solutions.
The MSQL_DQ wait type accumulates while waiting for a distributed query to complete and it is not necessarily indicative of an issue. If MSQL_DQ is
The new “AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups” white paper was just published by Microsoft
SQL Server 2012 introduces a “NonParallelPlanReason” attribute in the QueryPlan element in a query execution plan. This attribute is not officially documented as of this
I wrote an article for Simple-Talk that was published last Monday: A first look at SQL Server 2012 Availability Group Wait Statistics AlwaysOn Availability Groups
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:
The word “dashboard” immediately puts me into a state of suspicion. This is probably because I’ve been a part of the corporate world for 18
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.