Cumulative Update – 10 for SQL Server 2012 Service Pack 1 Is Now Available !
The 10th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-05-21
982 reads
Blog Posts
DBA Myths: A table with a primary key is not a heap
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,642 reads
How SQL Server statistics are generated and updated
One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...
2014-05-21 (first published: 2014-05-16)
6,341 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
1,198 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
558 reads
Quick Tips – SQL Prompt Stop the Yelling
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-21
2,008 reads
Setting Up Your Custom Data Collector Set
Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable...
2014-05-21
598 reads
SSRS Nugget: displaying placeholders when no rows are returned
A few days ago there was an interesting question on the forum:
How can I get None in each cell of...
2014-05-21 (first published: 2014-05-15)
2,352 reads
Submitted My Application For the 2014 PASS Nominating Committee
I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...
2014-05-21
496 reads
Supported Compatibility Levels in SQL Server
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in...
2014-05-21
17,389 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?