Tips for Minimizing Deadlocks
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on...
2013-05-07
911 reads
XML Support and SQL Server (Part 6)
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about...
2013-05-07
561 reads
I'm Giving a SQL Server Security Webinar on May 9, 2013
On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...
2013-05-07
1,201 reads
An Alternative to SELECT COUNT(*) for Better Performance
Sometimes rapid code development doesn't always produce the most efficient code. Take the age old line of code SELECT COUNT(*)...
2013-05-07
5,296 reads
SQL Server 2008 R2 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
752 reads
SQL Server 2012 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-07
762 reads
SQL Server – How to Best Remove Extra TempDB Data Files and Log Files
One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today,...
2013-05-06
941 reads
May 2013 – Monthly SQL Server Checklist
It’s the start of the month of May, or at least the first Monday in May. Hopefully you aren’t nursing...
2013-05-06
693 reads
SQLSaturday Atlanta #220–May 18th
I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th...
2013-05-06
555 reads
Donating for a little kid
One of my authors sent me this note:
“
I know you only know me as a writer for SQLServerCentral, but I...
2013-05-06
700 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers