Microsoft has released Cumulative Update #5 for SQL Server 2014. KB Article: KB #3011055 56 fixes total (47 fixes listed publicly at time of publication). Build number is 12.0.2456 Relevant for @@VERSION 12.0.2000 through...
Yearly Archive: 2014
I walk through several potential causes for different plans and/or performance for the same database on two "identical" servers.
Tip : Finding SQL Server views with (or without) a certain property
I reflect on SQLSaturday #350, and the awesome after-party at Heather Curling Club in St. Boniface, in the not-quite-frozen tundra known as Winnipeg, Manitoba.
I discuss a handful of reasons "identical" queries might yield multiple plans, contributing to plan cache bloat.
Tip : Over 40 queries to find SQL Server tables with or without a certain property
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...
I share slide decks and demo files from three different November Shows – PASS Summit in Seattle, WA; SQLintersection in Las Vegas, NV; and SQLSaturday #350 in Winnipeg, Manitoba.
I am live-blogging the Thursday keynote from the PASS Summit in Seattle, WA. The topic is Cloud Databases 101.
I am live-blogging from the Women in Technology Luncheon, hosted by Kimberly Bryant, founder of Black Girls CODE.
Tip : Verify the databases a SQL Server login can see – and why
I am live-blogging the Wednesday keynote from the PASS Summit in Seattle, WA. "The Journey to Cloud Continues."
I show some tricks for getting row counts efficiently, and explain why an accurate row count for a large table is a pipe dream.
I repeat "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
Microsoft has released Cumulative Update #4 for SQL Server 2014. KB Article: KB #2999197 66 fixes total (54 fixes listed publicly at time of publication), including several fixes for Management Studio. Build number is...
I demonstrate an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.
Tip : Map between SQL Server SIDs and Windows SIDs
I point out that an often-used connection setting, AttachDBFileName, may be the source of many wasted hours of debugging and troubleshooting.
Tip : Drop and Re-Create All Foreign Key Constraints in SQL Server
Microsoft has released the final Service Pack (SP4) for SQL Server 2008. Build # 10.00.6000 KB Article: KB #2979596 (Download) 6 public fixes, including important security fixes from MS14-044 Relevant for builds < 10.00.6000...
I treat a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.