A DMV a Day – Day 26
Well, we are on the final week of the DMV a Day series for the month of April. I will...
2010-04-26
1,613 reads
Blog Posts
Beware, events falling from the sky
Are SQL Saturdays falling from the sky? (from Jen McCown, @midnightDBA)
I think so. This past weekend had three events, #39...
2010-04-26
756 reads
Introduction to SSRS 2008 and SQL Saturday 38
In a few short weeks, another great event is coming to Jacksonville Florida at the UNF campus. There are many...
2010-04-26
357 reads
Size of the DB limit has changed...
The cool update from SQL Server 2008 R2 is the possibility from Express Edition that changed the database limit from...
2010-04-26
729 reads
SQL Server 2005 Diagnostic Information Queries (April 2010)
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
996 reads
SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,932 reads
SQL University: Auditing SQL Server, Part I
Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...
2010-04-26
2,789 reads
SQLSaturday Sites Will be Offline For Part of April 27, 2010
We’re scheduled to begin moving web sites and data to PASS servers at 12:00 pm Eastern on April 27, 2010....
2010-04-26
491 reads
SQLSaturday Success! NYC #39, has left the building.....
Well, it’s Monday morning and back to the DBA salt mines!
Now that SQLSaturday #39 is all but a joyful...
2010-04-26
579 reads
SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
559 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...