Determining Default Trace Location
While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find...
2013-01-09
1,805 reads
StrateSQL
SQL Saturday Fargo Update
It’s been a while since I mentioned anything about the SQL Saturday in Fargo. So I thought I would let...
2013-01-08
578 reads
Index Analysis Update – January 2012
In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis. The update today fixes those issues....
2013-01-08
748 reads
January 2013 – Monthly SQL Server Checklist
Today is the first Monday of 2013. Do you know if your servers are ready to take on the first...
2013-01-07
681 reads
Last Weeks Top 10 “Reading” Links #14
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-07
908 reads
Reblog: December 28 to January 3
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-04
1,037 reads
Wrapping Up 2012
Last year, I did a wrap up post of the year to see where I landed from where I wanted...
2012-12-31
1,630 reads
Last Weeks Top 10 “Reading” Links #13
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-31
1,723 reads
Reblog: December 21 to December 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-28
1,114 reads
PASSMN Presentation Materials
Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN). The turnout was quite excellent...
2012-12-28
734 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?