Generating Estimated Plan and the Plan Cache
Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
No.
What? Still here? You want more?...
2015-08-18 (first published: 2015-08-10)
1,781 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
PASS Board Update: July 2015
I was actually travelling for most of July and some of that was on holiday with the family, the real...
2015-08-13
588 reads
Leadership: A Name and A Principle
I’m actively working to put together the leadership course that I talked about here and here. No, not full time. I...
2015-08-11
508 reads
Grant’s Fly-by-night Leadership Course – The Plan
Get a better nameDefine my personal goals for the courseI won’t be sharing these with you. I may share them...
2015-08-07 (first published: 2015-07-28)
1,893 reads
Reading Your Execution Plans
I’m putting the finishing touches on the all day seminar on execution plans that I’ll be putting on at DevConnections this...
2015-08-06
929 reads
PASS Needs You!
It’s time.
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for...
2015-08-05
577 reads
But we've always done it that way…
Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.
2015-08-03
157 reads
Differences Between Actual & Estimated Plans
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The...
2015-08-03
875 reads
Hey Kids! Let’s Put on a Show at the Old Barn
Alternate Title: I’m traveling a bunch. Let’s get together and talk.
A bunch of trips and presentations coming up, so I...
2015-07-29
971 reads
SQL Server Management Studio – Footloose and Fancy Free
That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact,...
2015-07-20
732 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers