Table Variables Are Only in Memory: Fact or Myth
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
662 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
3 Weeks to the PASS Summit
The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...
2009-10-10
626 reads
Another Book
Well, part of one anyway. I wrote three chapters of Rob Walter’s new book, Beginning SQL Server 2008 Administration. I...
2009-10-10
541 reads
PASS Log Reader Awards
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
719 reads
SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
593 reads
Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-07
3,203 reads
Hey, ho, where’d you go…
Ohio?
I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again)....
2009-10-06
526 reads
Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,198 reads
Free Stuff and a SQL Server Standard Update
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
711 reads
Minor Celebration
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,382 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
Comments posted to this topic are about the item Shining a Light on Shadow...
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
isnull, coalesce overhead
hi, one of our sister division's erp extract view is going thru at least...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers