Carlo, nice try with this Question of the Day, but I really learned more with Hugo's explanation......

Great review.

We have been using SQLdm for quite a while now, focused on our main application and its DB server and it has provided timely and invaluable help...

Run this against your msdb and it will give you an idea what tables are the big ones. If the sum of the ReservedKB column is not adding up close...

That's where a tool like Idera's SQL Diagnostic manager comes in handy, as you can go back in time and see things like active sessions running and what command it...

Using a 3rd party tool like LiteSpeed is probably the answer for you.

We have a 1.3TB DB that used to take about 2.5-3 hours using the native backup. With LiteSpeed...

Steve Jones - Editor (9/3/2010)

---

IF it's eval edition, you can get info here: http://mangalpardeshi.blogspot.com/2009/05/expiration-date-of-sql-server.html

If you want to query each server, I'd think that eval edition had a note in the...

That will only provide you with the Version/Edition of the running SQL instance. As of SQL 2005 the licensing info is no longer stored anywhere as...

Again a great question Hugo! Really makes you think (more than) twice about what to answer..... something new learned...again 🙂

OP wrote "After the upgrade, we...

The problem here is that you are grouping by "CONID, Type,LID, CID, ContactCode, Date, EmpID", so only repetitions of same data for all those rows would "add" to the count...

... meaning you need only to...

If you used the backup with multiple files, you would use a command like this to restore from multiple files:

RESTORE DATABASE

[DatabaseName]

FROM

DISK = N'Path_to_file_1.bak',

DISK =...

Hugo, nice question and very nice job on explaining it!

Lynn Pettis (8/6/2010)

---

Richard M. (8/6/2010)

---

I always chuckle when Wikipedia is cited as a reference. Wkipedia, although a nice place to look up stuff (you basically find anything you are looking...

I always chuckle when Wikipedia is cited as a reference. Wkipedia, although a nice place to look up stuff (you basically find anything you are looking for), is not always...