I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2019-04-26 (first published: 2017-11-01)
5,125 reads
As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...
2019-04-26 (first published: 2018-10-02)
2,322 reads
I manage a few servers used to host SQL Instances for development and test purposes. Each of those instances hosts...
2019-04-26 (first published: 2018-04-24)
2,953 reads
I recently had an incident where I was looking into the cause of a long running process for a client....
2019-04-26 (first published: 2018-09-18)
2,092 reads
My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I...
2019-04-26 (first published: 2019-04-22)
1,971 reads
If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...
2019-04-26 (first published: 2018-08-08)
2,262 reads
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace...
2019-04-26 (first published: 2018-10-16)
2,126 reads
In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an...
2019-04-26 (first published: 2018-09-25)
5,981 reads
TDE is commonly described as “at-rest” encryption, i.e. it protects your data wherever it is stored on disk. This includes...
2019-04-26 (first published: 2018-01-03)
3,190 reads
In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for...
2019-04-26 (first published: 2017-10-24)
4,770 reads
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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