T-SQL Enhancement: Sequence
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
546 reads
Blog Posts
T-SQL Enhancements in SQL Server Denali (2011)
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that...
2011-06-07
465 reads
A Welcome Break
I’m not working, though I have checked some email and kept an eye on a few things while I’m in...
2011-06-06
501 reads
Column order can matter
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,179 reads
Great white paper: Microsoft EDW Architecture, Guidance and Deployment Best Practices
A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices.
It’s a must read if you are...
2011-06-06
1,107 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a
daily feeding of around 9 million. It is split into 10, roughly equal,
partitions. I...
2011-06-06
19 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million....
2011-06-06
515 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million. It is split into 10, roughly equal, partitions. I...
2011-06-06
4 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time
OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds...
2011-06-06
463 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds good. There will likely be Pizza and...
2011-06-06
7 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers