Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,561 reads
Presenting "Secrets Of SQL Server" Idera Webcast On Feb. 16
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
723 reads
UN-SQL Friday #003–Vendor Love
The love that dare not speak it’s name… Yes, love for vendors. <shudder> Oh, I mean I love my new...
2011-02-15
597 reads
SQL Saturday #60, Cleveland Speaker Evals
I just received 35 speaker evaluations from SQL Saturday #60 in Cleveland. It was a great event (although I had...
2011-02-15
1,023 reads
Recent AMD Processor News
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be...
2011-02-15
477 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
494 reads
Redgate’s Free SQL Search Tool
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,156 reads
The DBA Ultimate Fitness Workout Plan
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
749 reads
The results are in: What Tech Companies Are Doing it Right?
Last week I asked you: What Tech Companies Are Doing it Right?
Which SQL (or SQL-adjacent) tech companies are doing right,...
2011-02-14
885 reads
SQL Server and the “Lock pages in memory” Right in Windows Server
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL...
2011-02-14
1,736 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers