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,731 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,481 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
683 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
801 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,407 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,626 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,776 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
994 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,969 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,630 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers