Table Variables
I was never a big fan of temp tables, mostly because there were serious contention issues in SQL Server v6.5....
2010-06-02
1,012 reads
Winner of the May SQL Aloha Contest
This month’s question had 21 responses, although a few were duplicates. The question was:
What is your favorite DBA joke?
If you...
2010-06-02
414 reads
Alternating Group Colors
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
509 reads
TechUpdate Prishtina 2010, announcement
I have non-official info about the Microsoft event, and the only event, TechUpdate Prishtina, in Kosova. The event will be...
2010-06-02
509 reads
Nice Shout-Out From Brad McGehee
I was browsing Twitter today, and I noticed some retweets linking to a blog post that Brad McGehee (blog | twitter)...
2010-06-01
579 reads
T-SQL Tuesday #007: Summertime in the SQL
Invitation for T-SQL Tuesday #007
New hotness
Welcome back to the blog party known as T-SQL Tuesday. I’m honored to be hosting...
2010-06-01
598 reads
PASS Summit 2010 Call for Speakers Closes Saturday, June 5
If you are planning to submit any sessions to the 2010 PASS Summit, the deadline is Saturday, June 5, 2010....
2010-06-01
401 reads
Troubleshooting Login Failed Errors on SQL Server 2008
While looking over my SQL Server Error logs, I noticed a small flurry of error messages like you see below,...
2010-06-01
1,269 reads
Why Would a Delete Make My Database Grow?
A while back I had a developer come to me complaining that every time they ran a large delete statement on a certain database the delete would fail with...
2010-06-01
7 reads
Why Would a Delete Make My Database Grow?
A while back I had a developer come to me complaining that every time they ran a large delete statement on a certain database the delete would fail with...
2010-06-01
23 reads
Blogs
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...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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