Invalid SKU Error when Adding a Node to a SQL 2008 Cluster
When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error
2008-09-07
3,242 reads
Scripts
2008-09-05
1,273 reads
generate save, delete, get, and list objects for a table
crates sp and function template for a table
2008-09-05
221 reads
Monitor database growth - a better way for sp_spaceused
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,080 reads
Quick and dirty way to make a very large table
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,348 reads
Check Fragmentation on All Indexes on Database
In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-03 (first published: 2008-07-10)
4,708 reads
2008-09-03
244 reads
2008-09-02 (first published: 2008-07-10)
2,707 reads
2008-08-27
1,042 reads
2008-08-27 (first published: 2008-07-03)
2,203 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers