What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,325 reads
Blog Posts
Costco & Blueberry Muffins
You’ve probably heard of Costco, one of those warehouse type stores that sells stuff in bulk. We buy stuff there...
2009-08-20
567 reads
Managing Your Database
It seems that I see posts like this one more often than I'd like. Or at least some variation on...
2009-08-20
864 reads
Practical or Silly?
I won $25 from Thinkgeek via Intel from a twitter contest. Can you follow that? I posted a question for...
2009-08-20
1,098 reads
Things to consider...
Hi.... I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....Cool Stuff:
1.SSMS: now...
2009-08-20
562 reads
Two Book Recommendations
I have two new books that I can heartily recommend. This isn’t a review of either book since I’ve only...
2009-08-20
569 reads
August SQL Server User Group – Near Real-time Data Warehouse
Well we had a really good meeting this week at our User Group. There were about 17 physical attendees and...
2009-08-19
854 reads
Buck Woody Joins SQLSaturday Advisory Council
Just announced at http://blog.sqlsaturday.com/2009/08/sqlsaturday-advisory-council-newest.html, Buck makes three – one more to go coming up soon!
2009-08-19
543 reads
Don’t Use USE (in SSIS, at least)
I ran into a situation this week that brought to light a subtle syntactical error I’d made in creating an...
2009-08-19
756 reads
I/O You a followup - More about I/O, Performance Tuning & Troubleshooting....
Yesterday, I blogged about basic I/O usage with some useful scripts, DMVs, and links to more in-depth details on examining...
2009-08-19
1,636 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