SQLFool IDX Defrag Scripts
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for...
2010-01-26
932 reads
Updating a column
Hi,
I have a table name CustUsers. In this table, there is a field name: PWD
I have refreshed the production database...
2010-01-26
382 reads
2010-01-26
363 reads
It’s a Toaster
I had to install WinZip the other day, having the need to unlock a .RAR file. There’s no native support...
2010-01-26
1,161 reads
Second Normal Form (2NF)
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following...
2010-01-26
3,668 reads
Third Normal Form (3NF)
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the...
2010-01-26
2,248 reads
First Normal form (INF)
First Normal Form (INF):- A table is said to be in a First Normal Form (1NF)if it satisfy the following...
2010-01-26
801 reads
The Three Events That Brought Me Here
Recently Paul Randal (twitter, blog) instigated another meme in the SQL Server community – What three events brought you here. If...
2010-01-26
445 reads
Another Keyboard Down
I don’t know if they’re making them cheaper and shoddier or what, but it seems that I’m going through a...
2010-01-26
910 reads
Database Normalization
Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...
2010-01-26
2,816 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
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers