Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,731 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
New Windows Azure Virtual Labs
Getting started with new technologies can be a pain. That makes all the new labs that Microsoft just posted extremely...
2013-09-10
590 reads
Developers Rate Azure One of Their Favorite Tools
Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...
2013-09-09
1,271 reads
Speaker of the Month: September 2013
This is my second post in what I hope will be an ongoing series. You can see the rules for...
2013-09-06
863 reads
sp_executesql, Parameters and Parameter Sniffing
I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess...
2013-09-05
1,532 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
628 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
544 reads
Make the PASS Summit Work For Your Employer
It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy...
2013-09-02 (first published: 2013-08-26)
1,960 reads
One for My SQL Sisters
Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I...
2013-08-30
1,787 reads
Windows Azure SQL Database and Throttling
When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept...
2013-08-29
1,533 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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