Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,704 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,467 reads
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM....
2011-10-11
676 reads
Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...
2011-10-04
783 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,373 reads
How to monitor number of VLF’s in your database
A few weeks back we did a blog post about a file grow bug that has been fixed with SQL...
2011-09-20
1,618 reads
T-SQL Function: EOMONTH
We have all been in a situation where we had to get the last day of the month with T-SQL....
2011-09-13
5,763 reads
Blog Series: T-SQL Enhancements
Three months back in this blog post – T-SQL Enhancements in SQL Server Denali (2011) – we promised to do a series...
2011-09-06
989 reads
New LOGICAL functions in SQL Server Denali
IFF Function
If you are an old Access or Excel “developer” you know this one. This is not a function I...
2011-09-06
2,953 reads
T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I...
2011-08-30
4,625 reads
Blogs
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Deploy at Low Priority
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Linking/Bridge Table/ Or Surrogate Keys?
The system I'm working on is MS Access, but the principles of dimensional modeling...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers