Browse by Tags
» internals (RSS)
Showing page 2 of 3 (30 total posts)
The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks:
In test 1, making the clustered index unique improved performance by around 40%. In test 2, making the same change reduced performance by around 70% (on 64-bit systems – more on that later). ...
Remote Desktop Services Component Architecture Poster
Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2
Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...
You probably already know that it’s important to be aware of data types when writing queries, and that implicit conversions between types can lead to poor query performance. Some people have gone so far as to write scripts to search the plan cache for CONVERT_IMPLICIT elements, and others routinely inspect plans for that type of thing when ...
I profiled Adam Machanic's (blog | twitter)
excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in
my monthly SQLMag column, Tool Time. Adam has been diligent about
maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
From BOL, "Key-Range Locking" article:
Key-range locks protect a range of rows implicitly included in a record set being read by a Transact-SQL statement while using the serializable transaction isolation level. The serializable isolation level requires that any query executed during a transaction must obtain the same set of rows every ...
Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA. Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin. You can see the recording and slide deck here. Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had ...
We've got two sessions that you need to sign up
for right away. The upcoming webcast for Oracle-oriented folks has huge
registration numbers. So get in while you still can before we hit the
limit of what LiveMeeting can handle.
of the Week: SQL Server for the Oracle DBA
Webcast: SQL Server for the Oracle DBADate:
Join Us for 24 Hours of SQL Server Training
(with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime
(that be me
Ozar) are presenting?!?
The FREE 24 Hours of PASS event is bringing an exceptional
lineup of SQL Server and BI experts to your computer starting at
12:00 GMT (UTC) on May ...
For want of a nail the shoe was lost.
For want of a shoe the horse was lost.
For want of a horse the rider was lost.
For want of a rider the battle was lost.
For want of a battle the kingdom was lost.
And all for the want of a horseshoe nail.
I'm now in the middle of severity A case that is best depicted by this ...
It’s interesting to me that old and inaccurate performance tuning recommendations seem to have a life of their own. In some ways, old performance tuning recommendations are like the Undead from some kind of cheesy, 1970’s zombie movie – no matter how many times you shoot them, they just keep coming back.
Here’s a good case in point, ...