Viewing 15 posts - 16 through 30 (of 279 total)
Carlo, nice try with this Question of the Day, but I really learned more with Hugo's explanation......
October 12, 2010 at 7:55 am
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...
October 4, 2010 at 10:23 pm
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...
September 29, 2010 at 10:15 am
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...
September 16, 2010 at 2:18 pm
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...
September 9, 2010 at 8:21 am
Steve Jones - Editor (9/3/2010)
If you want to query each server, I'd think that eval edition had a note in the...
September 3, 2010 at 12:11 pm
Michael Valentine Jones (9/1/2010)
select @@version
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...
September 3, 2010 at 8:57 am
Again a great question Hugo! Really makes you think (more than) twice about what to answer..... something new learned...again 🙂
August 31, 2010 at 9:04 am
Dave Klug (8/20/2010)
Out of curiosity, why would you want to run SSRS with a compatibility level of 90 as these databases are internal only.
OP wrote "After the upgrade, we...
August 23, 2010 at 11:21 am
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...
August 18, 2010 at 12:46 pm
Jonathan Kehayias (8/17/2010)
...You can install it just like you can install any of the client tools on end user workstations to connect to SQL Server.
... meaning you need only to...
August 17, 2010 at 1:53 pm
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 =...
August 10, 2010 at 7:17 am
Hugo, nice question and very nice job on explaining it!
August 10, 2010 at 6:53 am
Lynn Pettis (8/6/2010)
Richard M. (8/6/2010)
August 6, 2010 at 2:19 pm
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...
August 6, 2010 at 6:55 am
Viewing 15 posts - 16 through 30 (of 279 total)