Find Largest Tables To Compress
In this post I’m gong to show some T-SQL that will show you the compression state of tables and how to quickly find objects that are worth compressing.
Last...
2013-04-16
6 reads
Richie Lee's SQL Stuff
Cumulative Updates - SQL Server 2012 RTM CU7
A 7th Cumulative Update is available for those users still on the RTM branch of SQL Server 2012. This is in keeping with Microsoft’s Incremental Service Modelling.
http://support.microsoft.com/kb/2823247You may have...
2013-04-16
2 reads
Unknown Unknowns: SSAS Version Number and Default Admins
With Service Packs and Cumulative Updates rapidly released for SQL, it can be hard to keep up with what version you have installed where. It’s easy enough to find...
2013-04-09
5 reads
Cumulative Updates - SQL Server 2012 SP1 CU3
As part of theirIncremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #3.http://support.microsoft.com/kb/2812412
This CU contains 38 fixes and is pertinent for versions 11.0.3000...
2013-03-19
5 reads
Important Update for SQL Server 2012 SP1
One of the challenges we faced this week was a high CPU usage on one of our SSAS Cluster boxes when there was very little activity, plus some errors...
2013-01-21
4 reads
SQL Bits XI Registration is Now Open
Hi all,
registration to attend SQL Bits is now open.
http://www.regonline.com/Register/Checkin.aspx?EventID=1163518
There’s a 600 capacity limit and they anticipate it to fill rather quickly. More details can be found here:
http://sqlbits.com/
Hope to see...
2013-01-11
2 reads
Reports on Disk Space and Space in Files
Previously I have blogged about how to check for free space in a database at a file level; a file for a database can be very large, but the...
2013-01-05
2 reads
List of Disks and Free Space
Recently I have been supporting our move from TFS from 2010 to TFS 2012. The database instances is stored on a server that I do not have log on...
2013-01-03
1 reads
SQLBits XI Dates Announced
SQLBits XI has been announced for the 2-4th of May 2013. Having taken place in London this year, it is moving back North to the Midlands at the East...
2012-12-31
Introduction to Hekaton Part One: MVCC
Hello folks, welcome to a post focusing on one of the future features of SQL Server. SQL Server 2012 is barely a year old, yet there is already talk...
2012-12-30
6 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers