Forum Replies Created

Viewing 15 posts - 16 through 30 (of 275 total)

  • RE: Large LDF Despite Frequent Backups

    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

    #1222592

  • RE: Ways to backup restore Very Large Database (VLDB)

    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

    #1218624

  • RE: Evaluation Copy?

    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...

    September 3, 2010 at 12:11 pm

    #1216359

  • RE: Evaluation Copy?

    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

    #1216213

  • RE: HAVING without GROUP BY

    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

    #1214382

  • RE: compatibility level of reportServer & reportserverTempdb changing to 100 every day at same time

    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

    #1210612

  • RE: Query Duplicates

    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

    #1208703

  • RE: License question on the bundled Visual Studio Premier Partner Edition.

    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

    #1208117

  • RE: Calculating the Size of a Multi File Database Backup

    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

    #1204751

  • RE: Round up or down II

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

    August 10, 2010 at 6:53 am

    #1204728

  • RE: Basic

    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...

    August 6, 2010 at 2:19 pm

    #1203782

  • RE: Basic

    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

    #1203479

  • RE: AWE

    sudhakara (7/28/2010)

    jezza101 (7/28/2010)

    sudhakara (7/28/2010)

    But i dont know why only 4 GB can able to access even if i have 6 GB of RAM in my system.

    You might find the answer...

    July 28, 2010 at 7:43 am

    #1199237

  • RE: Disable All Triggers

    Good question and use of the undocumented sp_MSforeachdb.

    Now, I have a remark here, the question stated "...disable all triggers in a database".

    As Hrvoje noted above, Database scoped triggers as well...

    July 1, 2010 at 7:39 am

    #1187661

  • RE: PRINT vagaries

    Great question.... something new learned 🙂

    June 30, 2010 at 12:27 pm

    #1187268

Viewing 15 posts - 16 through 30 (of 275 total)