Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Tip : Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Tip : Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
I highlight a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.
The SQL Server team has released CU #11 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2908007 Build # is 11.0.2424 This build has 15 fixes NOTE: This is THE LAST CU for the RTM branch....
Microsoft has released Cumulative Update #10 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2908087 15 fixes listed at time of publication Build number is 10.50.4297 Relevant for @@VERSION 10.50.4000 through...
After an initial look at in-memory TVPs at small scale proved promising, I take a closer look at trying to match more values against a much larger table.
I investigate a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #14 Build # 10.00.5848 KB Article: KB #2893410 6 fixes Relevant for builds 10.00.5500 -> 10.00.5847 NOT for SQL Server 2008 R2 (10.50.xxxx)...
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #7. KB Article: KB #2894115 Build # is 11.0.3393 Currently there are 47 fixes (plus three undisclosed issues resolved); the most interesting...
I investigate a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.
Microsoft has released Cumulative Update #9 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2887606 17 fixes listed at time of publication Build number is 10.50.4295 Relevant for @@VERSION 10.50.4000 through...
I had a "soft" post on the PASS Summit 2013 speaker feedback.
Tip : Script to Set the SQL Server Database Default Schema For All Users
I share slide decks and sample code from SQLintersection in Las Vegas.
The SQL Server team has released CU #10 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2891666 Build # is 11.0.2420 This build has 4 fixes For most customers, this cumulative update hardly justifies the download,...
I reflect on PASS Summit 2013 in Charlotte.
Douglas McDowell (EVP Finance) takes the stage (no kilt), and talks numbers. PASS has an impressive $1MM in reserves as a "rainy day" fund. Last fiscal year they spent $7.6MM on community; 30% of...
Early morning start here in Charlotte. I'm going to try and keep this post updated as I have new information from the keynote to share, so refresh often! 8:24 AM Bill Graziano takes the...
I take a quick look at performance of encrypted backups in SQL Server 2014, and point out a couple of other things you will want to know before implementing the feature.
I discuss a common requirement, generating random numbers to serve as surrogate keys, and show how you can avoid the incremental cost of preventing collisions.
The SQL Server team has released CU #6 for Service Pack 1. KB article: KB #2874879 Build # is 11.0.3381 This build has 23 fixes by my count. The most interesting (to me) are:...
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #13 Build # 10.00.5846 KB Article: KB #2880350 2 fixes Relevant for builds 10.00.5500 -> 10.00.5845 NOT for SQL Server 2008 R2 (10.50.xxxx)...
The SQLintersection conference is taking place at the MGM Grand in Las Vegas, the week of Hallowe'en (October 27th – 31st). While much of the hubbub this time of year surrounds the PASS Global...
Tip : Generating Random Numbers in SQL Server Without Collisions
I investigate a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.
UPDATE 2013-08-23: 2008 R2 SP2 CU #8 is now available; details below. UPDATE 2013-08-14: I had originally posted about SP1 CU #14, and was sure SP2 CU #8 was coming in shortly behind it,...
The SQL Server team has released CU #9 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2867319 Build # is 11.0.2419 This build has 7 fixes, including an interesting one involving LIKE Relevant for builds 11.0.2100...
I discuss a case where assumptions can lead to a poorly-performing query and where exploring other options can pay off.
I reflect on the presentation I gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including responses to Q & A.
Tip : Use UNPIVOT to dynamically normalize output
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #12 Build # 10.00.5844 KB Article: KB #2863205 6 fixes Relevant for builds 10.00.5500 -> 10.00.5843 NOT for SQL Server 2008 R2 (10.50.xxxx)...
The SQL Server team has released CU #5 for Service Pack 1. KB article: KB #2861107 Build # is 11.0.3373 This build has 30 fixes by my count. Relevant for builds 11.0.3000 -> 11.0.3372....
Tip : Use UNPIVOT operator to help normalize output
I give some quick advice about SQL Server 2014 CTP1: Plan to install it in its own virtual machine, because at this point it does not play well with others.
The SQL Server team has released CU #8 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2844205 Build # is 11.0.2410 This build has 6 fixes Relevant for builds 11.0.2100 -> 11.0.2409. Do not attempt to...
Well, surely at least partly in response to the CU6 mess I reported earlier today, and partly because they were due, Microsoft has released new cumulative updates that contain – among other things –...
In April and May, Microsoft released cumulative updates for SQL Server 2008 and 2008 R2 (I blogged about them here and here). They are: CU #11 for 2008 SP3 (10.00.5840) (KB #2834048) CU #12 for...
I explore a few additional places to get information useful for decisions about creating new indexes that are suggested as "missing" by various tools.
The SQL Server team has released CU #4 for Service Pack 1. KB article: KB #2833645 Build # is 11.0.3368 This build has 39 fixes by my count. For more information about this cumulative...
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #11 Build # 10.00.5840 KB Article: KB #2834048 6 fixes Relevant for builds 10.00.5500 -> 10.00.5839 NOT for SQL Server 2008 R2 (10.50.xxxx)...
Tip : Extend SQL Server DDL Triggers for more functionality: Part 2
I talk about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.
Tip : Extending SQL Server DDL Triggers for more functionality: Part 1
I go into a little more detail about what happens to metadata when you use schema transfers behind the scenes.
I discuss some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped me isolate and solve the issues.
I explore a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items.
Today Microsoft released new cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 12 KB Article: KB #2828727 7 fixes listed at time of publication Build...
The SQL Server team has released CU #7 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2823247 Build # is 11.0.2405 This build has 17 fixes Relevant for builds 11.0.2100 -> 11.0.2404. Do not attempt to...
I gave two talks at the SQLintersection conference this week in Las Vegas. One was my Bad Habits & Best Practices session, and the other is a new one discussing advantages to upgrading to...
Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…
In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.