Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,453 reads
Blog Posts
Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...
2010-09-22
1,287 reads
Range locks do not only occur in Serializable transactions....
According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a...
2010-09-22
1,044 reads
Updates on SQLSaturday#59 in NYC
Hi, ALL: Just want to bring you some updates and news on SQLSaturday#59 @MS HQ in NYC on Nov 20, 2010. ...
2010-09-22
642 reads
Why You Should Come to SQL Saturday #48 - Columbia, SC
SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...
2010-09-22
942 reads
Instant File Initialization – Is it Turned On?
I have posted a short note on instant file initialization previously, that post can be found here. The crux of...
2010-09-21
1,728 reads
On Vacation
I’ve hit that point where it feels like I need to work longer and harder to keep up, which is...
2010-09-21
581 reads
Putting Priorities into Practice
Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into...
2010-09-21
901 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
435 reads
Software Review: Idera’s Virtual Database
Ever since the upgrade from SQL Server 6.5 to 7.0 one of the most requested features I’ve heard people complain...
2010-09-21
3,180 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers