Disabling Indexes Published on SQLServerCentral.com
It's been a while since I had anything up on SSC, a combination of Steve being in good shape on...
2008-07-22
488 reads
Blog Posts
Tool Review: Password Safe
I think we all struggle to keep up with various credentials needed to live our internet lives (single sign on...
2008-07-21
548 reads
Delayed gratification
Call me odd, but I enjoy taking certification tests. It may be that I've always tested well, or perhaps it's...
2008-07-20
667 reads
Why Are Stored Procedures Too Hard?
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
862 reads
Patching
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,919 reads
Follow Up Notes on the Custom Whiteboard
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
513 reads
JSSUG Speaking Event: Reporting Services 2008
We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting....
2008-07-17
717 reads
Tools
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,178 reads
Comments on Dissecting SQL Server Execution Plans by Grant Fitchey
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,361 reads
Reminder - Midlands PASS Chapter Meeting - July 17 - MVP John Welch
The Midlands PASS Chapter hosts:
SQL Server MVP John Welch
July 17, 2008 at Training Concepts
The Midlands PASS chapter will hold a...
2008-07-16
631 reads
Blogs
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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