PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it's my third day here. I have already...
2013-10-17
568 reads
Superman
PASS Summit 2013 – Day 2: The PASS Spirit
This is my second day into the PASS Summit 2013, and the excitement is still rising. My first day was...
2013-10-16
391 reads
PASS Summit 2013 – My First Day and Paul White
This is my first time to attend the PASS Summit. I was very excited about it, and I planned to...
2013-10-15
317 reads
How Much Unallocated Space do I Have in My Database Files
In a previous post, I wrote about when and how to shrink your database files. The bottom line was that...
2013-08-13
2,346 reads
My Summary of 24 Hours of PASS
Once a year, just before the annual PASS Summit, there is a promotional event called 24 Hours of PASS. The...
2013-08-05
438 reads
When and How to Shrink Your Database
Most DBAs know that shrinking a database is a bad thing. But in many cases, there is no DBA around,...
2013-08-01
604 reads
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers