Free SQL Server Training Webinar Series
SQLServerCentral.com, PragmaticWorks, and Wrox Press are sponsoring a series of free SQL Server webinars in February. Called the SQL Server...
2010-02-12
885 reads
Foundation Class Review
This week was an exciting teaching week for me. I taught the Pragmatic Works Foundation class, one of my favorite...
2010-02-12
663 reads
A Tale Of Two Execution Plans – Solved!
Earlier this week I wrote about a perplexing problem I was having where identical servers were producing different execution plans...
2010-02-12
1,312 reads
Syndication Schedule Changes
We have a process that reads syndicated blogs from people and then publishes them here. It’s worked well, and allows...
2010-02-12
624 reads
eReading – Lending Books
I sent this to Barnes and Noble, as well as Random House recently after the much vaunted “lending” technology in...
2010-02-12
723 reads
Farewell, Robert B. Parker
I heard the news via a blog post by Ward Pond that one of my favorite authors had died at...
2010-02-12
1,731 reads
eReading – Lending Books
I sent this to Barnes and Noble, as well as Random House recently after the much vaunted “lending” technology in...
2010-02-11
319 reads
SQL Server Trace Events
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,969 reads
ISNULL() VS. COALESCE()
There are a lot of arguments about which of these to use. In my opinion, they both have their place. ...
2010-02-11
9,066 reads
POTW Webcast with Kevin Kline
Today I'll be tagging along with Kevin Kline for the Quest Pain of the Week webcast. We'll be talking about...
2010-02-11
955 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...