Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,732 reads
Blog Posts
Seeing Yourself as Others Do
As life skills go one of the hardest is to see yourself as others do – they apply all kinds of...
2011-10-25
866 reads
SQL Server XQuery Against Execution Plans
One of the greatest things about all the DMOs is how you can combine the information they present to you...
2011-10-25
2,045 reads
The Basics of Joins – Skill #4
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-10-25
1,313 reads
Troubleshooting THREADPOOL Waits
Today I want to talk about a specified wait type that can be sometimes very hard to
troubleshoot: the THREADPOOL wait...
2011-10-25
12,600 reads
Tuesday Hardware Tidbits
There have been a few interesting developments on the hardware front over the past week that I want to cover...
2011-10-25
1,067 reads
ALTER SCHEMA
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,869 reads
Brad or Spot?
Today we have another guest post from Steve Jones.
I’m no expert on animals, but I have a little experience out...
2011-10-24
619 reads
Deploying SSIS Packages with BIxPress
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find...
2011-10-24
1,445 reads
GiveCamp Tampa 2011
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by...
2011-10-24
1,022 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...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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