Stop and Start Services - SQL School Video
SQL School covers a basic topic this week. MVP Andy Warren shows the various ways to stop and start your services.
2009-07-30
5,194 reads
SQL School covers a basic topic this week. MVP Andy Warren shows the various ways to stop and start your services.
2009-07-30
5,194 reads
I was doing some maintenance on the SQLSaturday web site recently and one request kinda low on the list was...
2009-07-29
3,595 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-07-28
1,445 reads
I ran across this a while back and it’s been on my ‘to blog about’ list for too long. Open...
2009-07-28
1,463 reads
Bill Graziano just made the announcement about the changes to the bylaws being published. No sweeping changes, for the most...
2009-07-28
560 reads
Just in case you don’t read the Connector today, here’s a link to an interview that PASS HQ did with...
2009-07-28
1,538 reads
I had hoped to announce this much sooner, sometimes the wheels turn slowly. But turn they do! We’re back at...
2009-07-28
1,454 reads
Steve Jones sent me this link on time management that discusses two things – getting ‘ambushed’ at the start of the...
2009-07-28
1,610 reads
Learn how you can configure your SQL Server instance using T-SQL code and sp_configure. MVP Andy Warren hosts this SQL School video.
2009-07-28
5,007 reads
2009-07-28
514 reads
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...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
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