Forum Replies Created

Viewing 15 posts - 40,456 through 40,470 (of 49,552 total)

  • RE: Restore SQL2008 File to SQL2005

    GSquared (3/9/2009)

    I think, if you downgrade the compatibility level of the database from 2008 to 2005 (100 to 90), detach the database from the 2008 server, copy the file over,...

    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

    March 9, 2009 at 2:30 pm

    #956402

  • RE: The Myth of "Content is King, No Animation/Sound/Java/etc"

    Spam. Reported to mod. No replies please.

    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

    March 9, 2009 at 2:24 pm

    #956398

  • RE: Group By clause

    Brandie Tarvin (3/9/2009)[hr Group By doesn't guarantee distinct results.

    Books Online

    Groups a selected set of rows into a set of summary rows by the values of one or more columns or...

    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

    March 9, 2009 at 2:19 pm

    #956391

  • RE: Are the posted questions getting worse?

    K. Brian Kelley (3/9/2009)

    Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:

    "If you do not understand what 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

    March 9, 2009 at 2:14 pm

    #956390

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)

    GSquared (3/9/2009)

    Grant Fritchey (3/9/2009)

    All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.

    That is too...

    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

    March 9, 2009 at 2:10 pm

    #956387

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/9/2009)

    Gail, weren't you the person who observed that GROUP BY produces the same execution plan

    as DISTINCT?

    Yup. A group by on all columns in a resultset...

    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

    March 9, 2009 at 2:05 pm

    #956386

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)

    You are one of the top 3 people on SSC

    Top 4 actually. Steve, Jeff and Remi are ahead

    so they figure if anyone knows the answer you are sure...

    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

    March 9, 2009 at 1:56 pm

    #956377

  • RE: Creating a Database Snapshot

    Jose Ianuck (3/9/2009)

    The big problem is to avoid locks or bad performance

    Locks it will avoid, bad performance, maybe , maybe not

    But create a snapshot database, it is so fast....

    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

    March 9, 2009 at 10:35 am

    #956197

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)

    I hate it when someone PM's me with a problem/question/additional info that really should be posted on an open forum thread.

    I've been getting a fair few...

    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

    March 9, 2009 at 10:28 am

    #956187

  • RE: "Answered" Posts

    Steve Jones - Editor (3/6/2009)

    I'll check them out, but they appear to be down now. Or down from the Denver area.

    Site's back up now. http://sadeveloper.net/forums/default.aspx

    Here's a thread with two replies...

    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

    March 9, 2009 at 10:06 am

    #956169

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)

    You have to wonder what people are being taught when you see code like this:

    ALTER TRIGGER [dbo].[tr_insert]

    ON [dbo].[table1]

    AFTER INSERT...

    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

    March 9, 2009 at 9:58 am

    #956158

  • RE: trigger not fired when imort data

    raj acharya (3/9/2009)

    hi but i m not importing data through bulk insert actually ... i m doing that through import and export wizard .....

    so can u pls help out...

    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

    March 9, 2009 at 9:53 am

    #956155

  • RE: Tune Stored Proc

    An hour just to do a count(*) of a table?

    Got indexes on the srcflag columns?

    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

    March 9, 2009 at 9:39 am

    #956131

  • RE: Creating a Database Snapshot

    Jose Ianuck (3/9/2009)

    so what impact does a database snapshot have on application transaction throughput and performance?

    Depends on your app, your hardware and the DB's usage. Could be anything from no...

    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

    March 9, 2009 at 9:38 am

    #956130

  • RE: Which Microsoft SQL Server MCTS | MCITP To Do?

    danielthompson (3/9/2009)

    Should I be pushing for the company to migrate the production systems to SQL Server 2008?

    That depends on whether or not you need any of the 2008...

    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

    March 9, 2009 at 9:36 am

    #956126

Viewing 15 posts - 40,456 through 40,470 (of 49,552 total)