Thoughts on the SQL Server 2008 R2 Press Conference
If you weren't aware, Microsoft held a BI telelconference today which announced the release to manufacturing (RTM) of SQL Server...
2010-04-21
1,195 reads
Blog Posts
Virtualisation – An Introduction
For the last two years or so, in one capacity or another I have been running SQL Server in virtual...
2010-04-21
666 reads
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,095 reads
Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
614 reads
Review: Ninite
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
629 reads
Sad Sack – Hardware Failures all over
I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:
iPod iTouch...
2010-04-20
646 reads
SQL Saturday #39, New York, New York
A town so big they named it twice.
If you’re not excited about SQL Saturday in NYC this weekend… why not?...
2010-04-20
520 reads
SQL Server Agent
Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU...
2010-04-20
381 reads
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
975 reads
Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and...
2010-04-20
748 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...