Getting data and log size of all databases
Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...
2011-12-03
1,923 reads
Blog Posts
Installing SQL Server 2012 Release Candidate 0
In my last post, I indicated that my plan was to post by Dec. 3 on the topic of data...
2011-12-03
2,192 reads
“Beyond Rounded Corners” at the Microsoft BI User Group of Minnesota-Dec 6, 2011
Come join me and other Business Intelligence professionals at the Microsoft BI User Group meeting at Microsoft’s new offices in...
2011-12-02
460 reads
Autogrow guidelines
I always enable autogrow on my databases. However, it’s there for emergencies, not as a space management tool. I monitor...
2011-12-02
5,818 reads
DBA in Space: Behind the Scenes—Question 10
This is a continuation of my DBA in Space journal.
Alien Brad is not looking very well (more boils), or very...
2011-12-02
855 reads
MythBusting–“Table variables have no statistics”
Ok, as myths go, its a pretty weak one. In fact, it is true, this whitepaper explicitly states that. But...
2011-12-02
3,075 reads
Now to End of Year
My friend Steve Jones posted Shutting Down for a Week and in that he talked about doing too much, trying...
2011-12-02
756 reads
Re-blog – November 25 – December 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-12-02
500 reads
SQL Server 2008 R2 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
I've uploaded to SkyDrive a complete step by step guide for a SQL Server 2008 R2 installation because I prefer...
2011-12-02
34,460 reads
SQL Server 2012 (“Denali”) Licensing
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,497 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers