The one question about PowerShell that trips up almost everyone is about when and how to quote strings. Because PowerShell replaces the old command shell, it has to be able to work the way that it did with string parameters, but it also has to behave like a .NET scripting language to replace VBA. In this article, Michael Sorens explains the how and when of PowerShell quoting.
When cardinality estimates are incorrect, the parallel threads doing the query work are given uneven amounts of work to do. This problem can lead to a seeming explosion in CXPACKET waits occurring and is commonly called skewed parallelism; Paul Randal explains how to check for it.
Denzil Ribeiro looks at how SQL Server 2016's new Merge functionality in INDEX REORGANIZE simplifies Columnstore index maintenance significantly.
This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
One man’s meat is often another man’s poison. In this editorial Tony Davis looks at why a migrations-based approach to database version control might not always be best practice.
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
How to delete millions of rows with virtually no contention.
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
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...
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