Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 8,416 total)

  • RE: The Missing Certification

    CirquedeSQLeil (4/2/2010)

    Thanks Paul for that input.

    How do you think the Time In Service requirement should be defined?

    Not sure really - I've kept out of the discussion because it's not really...

    April 2, 2010 at 12:21 pm

    #1145021

  • RE: Are the posted questions getting worse?

    Trey Staker (4/2/2010)

    With some of the nuggets that you've posted lately and indepth discussions what don't you know? 😛 :hehe:

    I am particularly weak on: Data Collector; Extended Events; Central...

    April 2, 2010 at 12:08 pm

    #1145014

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/2/2010)

    Paul White NZ (4/2/2010)

    A good way to prepare for the MCM 😉

    Don't make me laugh so hard.

    Why laugh? :blink: :crying:

    April 2, 2010 at 11:58 am

    #1145004

  • RE: Speed up a database shrink

    Jason,

    Paul White NZ (4/2/2010)

    I would be tempted to restore the production database to the staging server, and then run a script to set up snapshot replication with row (and possibly...

    April 2, 2010 at 11:54 am

    #1145000

  • RE: The Missing Certification

    I think I would be keen on a certification that had these elements:

  • Minimal time-in-service requirement
  • An adaptive on-line multiple-choice test
  • A set of tasks to perform on a sample database

  • A short piece...

April 2, 2010 at 11:51 am

#1144997

  • RE: Speed up a database shrink

    CirquedeSQLeil (4/2/2010)

    You could do it that way, or you could setup the replication with the snapshot and filters to get what you need. You would recreate it each time...

    April 2, 2010 at 11:26 am

    #1144978

  • RE: Don't forget this date.

    CirquedeSQLeil (4/2/2010)

    Surprised it hasn't happened yet.

    vk-kirov covered it!

    April 2, 2010 at 11:24 am

    #1144975

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/2/2010)

    I used to be the same. Commuted to Denver from Colorado Springs for 15 years, survived on 4 hours sleep Monday through Friday.

    Had to Google that to...

    April 2, 2010 at 11:22 am

    #1144973

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/2/2010)

    Sounds like a gauntlet throw down there.

    Just an observation 🙂

    April 2, 2010 at 10:56 am

    #1144947

  • RE: The transient database snapshot for database 'DB1' (database ID 5) has been marked suspect due to an IO operation failure.

    Interesting that the limit on sparse file size reduced from 64GB (Windows 2003) to 16GB (Windows 2008, Vista). There appears to be a QFE for this: http://support.microsoft.com/default.aspx/kb/957065

    April 2, 2010 at 10:45 am

    #1144932

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/2/2010)

    You know, if Paul keeps up this pace (100 pts/day average) in 2 months he'll be breathing down Barry's neck. Another 30 days, he'll quite possibly be...

    April 2, 2010 at 10:21 am

    #1144914

  • RE: Are the posted questions getting worse?

    GilaMonster (4/2/2010)

    Paul White NZ (4/2/2010)

    GilaMonster (4/2/2010)

    'Table variables are not affected by explicit transaction rollbacks'?

    Operations performed on a table variable within a transaction are not undone if that transaction aborts.

    Except that...

    April 2, 2010 at 10:19 am

    #1144913

  • RE: SSMS 2008 Stored Proc WITH RECOMPILE

    "Atypical parameters" refers to the fact that SQL Server may cache a plan based on the actual parameter values passed on the first call of a procedure. If those...

    April 2, 2010 at 9:53 am

    #1144900

  • RE: Are the posted questions getting worse?

    GilaMonster (4/2/2010)

    'Table variables are not affected by explicit transaction rollbacks'?

    Operations performed on a table variable within a transaction are not undone if that transaction aborts.

    April 2, 2010 at 9:48 am

    #1144895

  • RE: Are the posted questions getting worse?

    How about:

    "Table variables are weird...not quite a variable...not quite a table. Go figure."

    😀

    April 2, 2010 at 9:42 am

    #1144882

    • Viewing 15 posts - 4,351 through 4,365 (of 8,416 total)