Forum Replies Created

Viewing 15 posts - 31,891 through 31,905 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (7/9/2010)

    She showed remarkable restraint against the vuvuzelas. I was checking the news every day expecting to read about carnage in the streets.

    The day 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

    July 11, 2010 at 3:53 am

    #1191198

  • RE: Rebuild Index - Strange Problem

    SpiderDK (7/10/2010)

    Any article/BOL on this?

    I had the understanding that a clustered index only contained columns added to it, not all in table, if so no need for a index...

    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

    July 10, 2010 at 2:53 pm

    #1191167

  • RE: Managing Transaction Logs

    Chris Houghton (7/10/2010)

    Am i right in thinking then that data doesn't "move" from the transaction log (ldf) to the data file (mdf). The database engine modifies data pages in...

    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

    July 10, 2010 at 1:47 pm

    #1191158

  • RE: CHECK constraint

    index_us (7/10/2010)

    I am able to do it fine with a trigger but I am required to do it with a CHECK.

    Why are you 'required' to use a constraint? Is this...

    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

    July 10, 2010 at 1:45 pm

    #1191157

  • RE: CHECK constraint

    Trigger?

    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

    July 10, 2010 at 9:32 am

    #1191141

  • RE: Rebuild Index - Strange Problem

    scott.pletcher (7/9/2010)

    I don't see any restrictions like that in MS docs on online index rebuilds. So that is an odd error.

    http://msdn.microsoft.com/en-us/library/ms188388%28SQL.90%29.aspx

    Indexes, including indexes on global temp tables, can be...

    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

    July 10, 2010 at 4:47 am

    #1191129

  • RE: Rebuild Index - Strange Problem

    Jeffrey Williams-493691 (7/9/2010)

    Because the clustered index is the table - and the table has a text column. If the index was a non-clustered index, you could rebuild it online...

    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

    July 10, 2010 at 4:43 am

    #1191128

  • RE: SQL JOINS BETTER WAY

    Alan Vogan (7/9/2010)

    GilaMonster (7/9/2010)

    Alan Vogan (7/9/2010)

    Test 1: I ran with several columns selected (not exactly your query but one that made sense for the data). Query B ran 1 second...

    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

    July 9, 2010 at 1:36 pm

    #1190999

  • RE: SQL JOINS BETTER WAY

    Alan Vogan (7/9/2010)

    Test 1: I ran with several columns selected (not exactly your query but one that made sense for the data). Query B ran 1 second faster than Query...

    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

    July 9, 2010 at 11:20 am

    #1190954

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/9/2010)

    Alvin Ramard (7/9/2010)

    CirquedeSQLeil (7/9/2010)

    Alvin will soon be making a christmas soon that involves flux capacitors, pork chops, and bears

    Did you mean a Christmas song? I could probably...

    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

    July 9, 2010 at 11:10 am

    #1190946

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (7/9/2010)

    Does the plan involve a fiber-optic laser assembler?

    I still prefer the disassemblers, much less to clean up afterwards.

    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

    July 9, 2010 at 10:56 am

    #1190938

  • RE: Killed tran log backup process

    You can restart the service. The DB will go into recovery, for how long is another matter. Could be seconds, could be hours.

    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

    July 9, 2010 at 7:18 am

    #1190786

  • RE: Error while attaching a .mdf file

    You could try and hack it into the server then see what state it comes up in.

    http://sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-hack-attach-a-damaged-database.aspx

    Once you've got it in, query sys.databases, check the state_desc for that database and...

    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

    July 9, 2010 at 6:36 am

    #1190758

  • RE: Find procedure name in trigger

    You could always have every proc check for existence of a temp table, if not exists create it, then insert the name of the proc into that temp table. In...

    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

    July 9, 2010 at 6:25 am

    #1190748

  • RE: Restoring a database

    Cannot be done as part of the restore. Restore recreates the database as it was at the time it was backed up. You can run scripts afterwards to drop users,...

    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

    July 9, 2010 at 6:20 am

    #1190741

Viewing 15 posts - 31,891 through 31,905 (of 49,552 total)