Ask the Unicorn: Why is it Important to Know Tables in Filegroups?
Earlier this week, I wrote a quick blog post on a throw-away script I had written. The blog post was DETERMINING...
2013-02-01
635 reads
Blog Posts
Database Lifecycle Management for Azure SQL Database
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,931 reads
FLOAT datatype casting issue
Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...
2013-02-01
5,140 reads
Reblog: January 25 to January 31
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-01
916 reads
SQL Intersection 2013 – Las Vegas in April
It’s not too hot, it can be fun, and after a full day of SQL Server learning, there are lots...
2013-02-01
1,233 reads
SQL Server 2012 Diagnostic Information Queries (Feb 2013)
Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-02-01
1,003 reads
SSIS 6 Million Rows in 60 Seconds using standard laptop
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,145 reads
SSRS 101 – Prerequisites
Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things...
2013-02-01 (first published: 2013-01-23)
4,268 reads
AD FS Token Based Authentication In Code
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
423 reads
Day 24 of 31 Days of Disaster Recovery: Handling Corruption in a Clustered Index
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,852 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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