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
8 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
11 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
11 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
5 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
7 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
9 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
7 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
1 reads
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
17 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers