Six Months
“Show up for work on time for six months and then we’ll talk. Until then, I have four words for...
2010-04-30
2,173 reads
Blog Posts
Two Ways to Get System and Server Information on SQL Server from Management Studio / Enterprise Manager
To collect information for your SQL Server Infrastructure, there are two ways I can recommend.
The first, as mentioned from...
2010-04-30
10,061 reads
Windows 7 v the iPad
No, I didn’t buy an iPad, but I have to say on a trip to the Apple Store this week...
2010-04-30
2,107 reads
A DMV a Day – Day 29
The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...
2010-04-29
2,916 reads
A Identity Bug
Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
drop table aa
create table...
2010-04-29
2,225 reads
News
If you follow me on Twitter or are my friend on Facebook, you might already know the news. I am joining...
2010-04-29
2,003 reads
PASS Update #29
By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS...
2010-04-29
1,460 reads
SQLSaturday #41 - Atlanta Session Recap
Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...
2010-04-29
1,448 reads
When was SQL Server last restarted?
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,178 reads
A DMV a Day – Day 28
The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...
2010-04-28
1,265 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...