The DBA often needs to know when, how much and what kind of database file has changed its size. Also nice to know the amount of free space on the drive where the files are located databases.
2017-03-29 (first published: 2016-01-07)
2,089 reads
This will Archive and Purge rows from one table to another.
2017-03-27 (first published: 2017-03-17)
784 reads
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,417 reads
2017-03-21 (first published: 2017-03-15)
479 reads
Return values from MongoDB on Linux server with Powershell
2017-03-20 (first published: 2017-03-16)
1,172 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,451 reads
2017-03-09 (first published: 2017-02-16)
1,984 reads
2017-03-07 (first published: 2017-03-01)
1,239 reads
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
512 reads
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,336 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers