Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of...
2014-06-06
11,404 reads
Blog Posts
Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your...
2014-06-06
712 reads
Friday Followup For June 6, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-06-06
382 reads
Is PowerShell worth the time?
This is a good question for me to ask. I’ve been learning it, and working through examples in my PowerShell...
2014-06-06 (first published: 2014-06-04)
3,772 reads
Reblog: May 30 to June 5
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-06-06
768 reads
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
750 reads
Using a Hyper-V VHD in an Azure VM
I’m in the process of moving some my lab environments that I use for teaching SQL Server classes to Azure....
2014-06-06
1,288 reads
Attaching All Databases with PowerShell–Refactoring out Write-Host
Someone posted a note to me on Twitter that noted that Write-Host is not recommended for your scripts. I checked...
2014-06-05
1,042 reads
Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,360 reads
Who has the DAC open?
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,619 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?