Interviewing a DBA
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...
2012-09-26 (first published: 2012-09-24)
3,351 reads
Blog Posts
Log File Full–Availability Group Database
I run into an interesting issue with an Availability Group database recently. I was running a data load against a...
2012-09-26
5,007 reads
One More Reason for Portable Applications
I bet most of us don’t think about installing software that we need/want to try. We’re either running as local...
2012-09-26
816 reads
OVER() clause two simple ways on two different days
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,090 reads
Participate in the PASS Election Process
Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...
2012-09-26
1,065 reads
Running a document database on Sql Server
Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...
2012-09-26
14,749 reads
SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,425 reads
SQL Server: Part 4 : Approaching Database Server Performance Issue
In the last three parts, we have discussed about different queries that can be used to list the current state...
2012-09-26
1,750 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
900 reads
WIT Wednesday
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-09-26
1,135 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...