Script for compressing a database
When you have to compress a database you’d better first see the consideration for the compression.
This is a script that...
2015-01-24
400 reads
SQL Server - Convert() function
Convert () function in SQL Server to convert an expression from one data type to another data type
Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...
2015-01-24
1,879 reads
Compress that database
When you have to compress a database you'd better first see the considerationfor the compression.This is a script that I...
2015-01-24
71 reads
Video: A Better Way to Reindex
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,941 reads
I’m A Friend Of Red Gate For 2015
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...
2015-01-23
562 reads
Friday Followup For January 23, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-23
479 reads
F# Type Inference
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
40 reads
SQLPort’s new image
After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image...
2015-01-22
533 reads
SQL- Querying XML attributes from XML Column
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching...
2015-01-29 (first published: 2015-01-22)
38,550 reads
Looking Out for Others Helps You Lead
I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go...
2015-01-22
802 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
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...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers