Forum Replies Created

Viewing 15 posts - 28,906 through 28,920 (of 49,552 total)

  • RE: How to Make a Dynamic Stored Procedure Query

    david_wendelken (12/13/2010)

    Yo! Original Poster! Listen Up!

    The last post by the Original Poster (OP) stated that he's going to read over that blog post in detail. Hence he is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 1:18 pm

    #1261910

  • RE: Restore database

    rds 20124 (12/13/2010)

    I have used this:

    Use Master

    Go

    RESTORE DATABASE [rotary1] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\rotary.bak'

    WITH NORECOVERY,

    MOVE N'Rotary_Primary' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\rotary1_1.mdf',

    MOVE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 6:53 am

    #1261673

  • RE: Shrinking Databases

    It's backing up the changed extents, but like full backups it'll need enough of the tran log to ensure a consistent restore, however I don't think dfalso was talking about...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 6:44 am

    #1261667

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/13/2010)

    Anyone remember the Nightwatch on Babylon 5?

    "Traitors cannot hide"

    I watched the three Season 3 'all-hell-breaks-loose' episodes just last weekend.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 5:39 am

    #1261634

  • RE: Deploying SSAS or SSRS

    Did your friend try a google search?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 4:01 am

    #1261598

  • RE: The database could not be exclusively locked to perform the operation.

    The bigger question here is why exclusive access was needed, ie why CheckDB couldn't use the snapshots it normally does. Were there any other errors in the error log, any...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 3:21 am

    #1261590

  • RE: Restore database

    Post the exact script you used.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 3:18 am

    #1261589

  • RE: Are the posted questions getting worse?

    <sigh> I meant a photo of myself.

    Some days I wonder why I put up with you bunch. 😉

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 12:43 am

    #1261547

  • RE: SQL Server 2008 R2 eating 500 MB on server.

    SQL is a memory hog, the more memory it can get, the better. That said, 500MB memory is nothing for a production server. If I had to guess, I'd say...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 12:42 am

    #1261546

  • RE: Are the posted questions getting worse?

    I wonder, if I change my avatar to a photo, will I stop having people call me Mr or Sir?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 12, 2010 at 1:44 pm

    #1261460

  • RE: Improving Windows startup time w/lower priority SQL Server...

    You could always set the service to start manually and only start it when you need it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 12, 2010 at 7:15 am

    #1261417

  • RE: unique clustered index on 2 columns

    ahmed7.bi (12/12/2010)

    i have read that only one unique clustered index can be created on a table and many non clustered index

    then how come the below commands works fine as it...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 12, 2010 at 7:13 am

    #1261416

  • RE: What better way to update statistics?

    3)

    Write a job step that runs at the end of that job and updates stats (with full scan) on the tables touched by that cleanup. There's no point in wasting...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 12, 2010 at 12:38 am

    #1261385

  • RE: DBCC PAGE

    🙂

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 11, 2010 at 12:11 pm

    #1261319

  • RE: How can I get this selection in one TSQL run ?

    You don't need a temp table, however this does require either a subquery or a CTE. A CTE isn't really a table (despite its name), it's a named subquery

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 11, 2010 at 11:52 am

    #1261316

Viewing 15 posts - 28,906 through 28,920 (of 49,552 total)