Does the SQL Server Database Filename Matter?
Do you know the basics of how to create a database? Hopefully you do and can do so without the...
2013-01-17
2,800 reads
Blog Posts
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This...
2013-01-17
6 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of...
2013-01-17
1,240 reads
Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new...
2013-01-17
1,045 reads
MDX #24 – Leave out a dimension member using Except() Function
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression
Many of the MDX functions, such as NonEmpty(),...
2013-01-17
17,100 reads
New Years Aspirations – James Rowland-Jones – PASS
Thanks for agreeing to do this James; I know as you run your own company your time is billable!
Before we...
2013-01-17
1,534 reads
SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries
After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to...
2013-01-17
1,239 reads
SQLBits XI - My second most eagerly awaited event of 2013...
I bet you are half wondering what is the first? Well that would be the birth of my second child...
2013-01-17
793 reads
STATS_DATE() Doesn’t Indicate The Validity of Statistics
From time to time, you might have caught yourself in a conversation similar to the following:
Fred: Hey folks, we have...
2013-01-17
1,275 reads
The right terminology for the right audience
For those who has the privilege of being in the technology consulting industry for some time and started out in...
2013-01-17
395 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