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 I use for compressing databases. Of course you...
2015-01-24
5 reads
When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...
2015-01-24
5 reads
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
392 reads
When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...
2015-01-24
16 reads
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,872 reads
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,592 reads
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
39 reads
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
475 reads
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...
2015-01-23
559 reads
I had an SSD die last year. It was one of my traveling SSDs, where I keep spare copies of...
2015-01-23 (first published: 2015-01-16)
6,619 reads
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,937 reads
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Next up in my series talking about The Burrito Bot is diving into the...
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers