A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
5 reads
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,431 reads
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-12
1,263 reads
Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,398 reads
S–3–X Talk Week: This Totally Won’t be Awkward
We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...
2010-10-11
539 reads
Forgotten T-SQL Cheat Sheet
You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...
2010-10-11
1,451 reads
Updates on SQLSaturday#59.....6 Weeks to go!
I just wanted to update everyone on our event happening in NYC, November 20, 2010. We have just six weeks...
2010-10-11
548 reads
PASS Update #44 (Budget)
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
523 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,576 reads
SSMS Tip – Tab Groups
A few months ago as I came across tab groups in SSMS and once I found them I was very...
2010-10-11
1,099 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers