Introduction to Wait Statistics in SQL Server
In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can...
2015-04-13
914 reads
Klaus Aschenbrenner
Learn about SQL Server 2014 Performance Improvements
On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in...
2015-04-09
980 reads
SQL Server Quickie #23 – Plan Cache Pollution
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in...
2015-04-07
903 reads
Latches, Spinlocks & Lock-Free Data Structures Recording
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data...
2015-03-30
1,296 reads
Statistics on UNIQUEIDENTIFIER columns
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on...
2015-03-16
1,054 reads
Why I don’t (yet) recommend In-Memory OLTP to my customers
Ok, some of you will hate me after this blog posting, but it has to be said. Over the last...
2015-03-11
799 reads
Transaction Logging in In-Memory OLTP (Hekaton)
In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into...
2015-03-09
1,115 reads
In-Memory OLTP & Deadlocking – my SQLBits sessions
After speaking at the SQLRally conference in Copenhagen earlier this week, my next stop was at the SQLBits conference in...
2015-03-07
587 reads
Latches, Spinlocks & Lock-Free Data Structures – my SQLRally Nordic session
Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I...
2015-03-04
589 reads
SQL Server Quickie #22 – The Buffer Pool
Today I have uploaded the 22th SQL Server Quickie to YouTube. This time I’m talking about the Buffer Pool in...
2015-03-02
683 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers