2014-12-22 (first published: 2014-11-23)
1,210 reads
DB memory/RAM consumption
This script is used to get the memory or RAM consumption for the database(s).
2014-12-19 (first published: 2014-11-20)
2,784 reads
2014-12-08 (first published: 2014-11-18)
1,372 reads
2014-12-02 (first published: 2014-11-12)
2,282 reads
Function for Proper Case - Most easiest way
This function is used to manage the alphabet case, which means the first letter of all the words will be in caps.
2014-11-26 (first published: 2014-11-03)
1,273 reads
Identify Missing Sequence/Identity Numbers
This script is used to identify the missing sequence numbers or identity numbers.
2014-11-20 (first published: 2014-10-29)
1,109 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers