Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the...
2011-11-21
659 reads
Blog Posts
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the sp_MStableSpace script. Not a lot more to be said...
2011-11-21
9 reads
An Informal Compendium of SSAS Errors, Part 6: Common Errors
This is the last in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-20
1,297 reads
Content Shift, Still SQL, Just More SharePoint
Many of you may have notice that I have been a little inconsistent with my posts lately. It’s been a...
2011-11-20
644 reads
DBA Team Structure – Thoughts From Real Life
I once talked about the DBA team building about 3 years ago, now when I look back, I still believe...
2011-11-20
3,343 reads
DBA in Space: Behind the Scenes—Question 1
This is a continuation of my DBA in Space journal.
In the opening of the first episode of DBA in Space,...
2011-11-18
640 reads
Managing By Walking Around
For a long time a core piece of my ‘style’ has been to wander the halls a couple times a...
2011-11-18
608 reads
Reference Dimensions
A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...
2011-11-18
1,471 reads
SQL Server – When will my backup finish?
The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are...
2011-11-18
3,482 reads
SQL Server ® 2012 Release Candidate (RC0)
Finally it is here, the SQL Server 2012 RC0 is ready for download, click this link and you’ll be downloading...
2011-11-18
761 reads
Blogs
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers