T-SQL Tuesday #7 - StreamInsight
The 7th T-SQL Tuesday is upon us and you can read about it on SQL Chicken’s blog. He’s hosting this...
2010-06-08
1,979 reads
Blog Posts
T-SQL Tuesday #7: T-SQL Enhancements in SQL 2008.
In this edition of T-SQL Tuesday, Jorge Segarra (Blog | Twitter) asks us what our favorite new feature of SQL 2008...
2010-06-08
1,120 reads
Blogging at TechEd
I’ll be at TechEd on Monday/Tuesday. Not going to sessions as I don’t have the time to stay there all...
2010-06-07
358 reads
Cannot Connect to SQL Server
I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to...
2010-06-07
645 reads
Daily SQL Server 2008 New Feature – Day 17
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-07
482 reads
Defensive Database Programming Chapter 01
Today I am finally getting around to the review of the first chapter as promised. I talked about the book...
2010-06-07
799 reads
Get Index Details
We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One...
2010-06-07
597 reads
Interactive Sort Order using Reporting Services 2008
Sorting results in a tabular style report is a common request from business users. Sometimes, they want to see the...
2010-06-07
845 reads
June 2010 S3OLV Meeting
The S3OLV monthly meeting is being held this Thursday. We will be meeting at the same location and time as...
2010-06-07
488 reads
Master Data Services
You need consistent, reliable data. You want data that you can trust.
This is usually data about your transactions, slowly changing...
2010-06-07
547 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