Forum Replies Created

Viewing 15 posts - 34,336 through 34,350 (of 49,552 total)

  • RE: MCITP: Database Administrator

    Tara-1044200 (1/29/2010)

    can we beleive some online question banks which gurantee passing exams ?

    Many of those are braindumps. Actual questions taken from the exams in violation of the NDAs that anyone...

    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

    January 29, 2010 at 5:42 am

    #1110656

  • RE: TempDB into Memory

    vbprogrammer1986 (1/28/2010)

    If U want to work with temp table which must be placed in memory for fast access.u can use table variable instead of temp table overhead.

    table variable always take...

    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

    January 29, 2010 at 5:38 am

    #1110650

  • RE: TempDB into Memory

    SQL manages the buffer pool, you cannot control what's in there or on disk.

    SQL will try, as far as possible, to keep temp tables and table variables in memory because...

    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

    January 29, 2010 at 5:34 am

    #1110646

  • RE: SQL Server 2008 Fulltext catalog not getting populated.

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic855810-1550-1.aspx

    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

    January 29, 2010 at 5:32 am

    #1110644

  • RE: Rollback the committed transaction !!!

    You've got nested transactions. With nested transactions, all a commit does is decrement @@trancount until it reaches 0, then the transaction is actually committed. A rollback however will always roll...

    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

    January 29, 2010 at 5:30 am

    #1110643

  • RE: Log growing Unpredictably

    You're updating 50 000 rows in a single transaction? That's gonna cause the log to grow. The log will have to be big enough to store the before and after...

    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

    January 29, 2010 at 5:24 am

    #1110641

  • RE: audio resources for sql / win server / mcdba / general it.

    http://dotnetrocks.com/

    http://runasradio.com/

    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

    January 29, 2010 at 5:23 am

    #1110640

  • RE: Managing SYSADMIN access to data

    Nothing can be denied to a sysadmin.

    You need encryption here, but not using SQL Server's certificate-based encryption. The sysadmins will have full rights to the certificates and hence will 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

    January 29, 2010 at 5:21 am

    #1110638

  • RE: Update a filed in the group

    No, if you group by the course date, you're asking for the minimum course name PER course date.

    Your requirements are not clear.

    Do you want the minimum course name per date?...

    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

    January 29, 2010 at 5:19 am

    #1110635

  • RE: Find tables unused since last SQL Server restart

    It's not since the last SQL start, it's since the last database start. If the DB is closed, taken offline, detached or restored, those stats are also cleared. Watch 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

    January 28, 2010 at 10:25 pm

    #1110458

  • RE: To Include or Not to Include (covering indexes)

    Apollo74x (1/28/2010)

    Also - nice blog:

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    Thanks. (It's my blog in case you didn't realise)

    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

    January 28, 2010 at 10:19 pm

    #1110456

  • RE: To Include or Not to Include (covering indexes)

    Apollo74x (1/28/2010)

    I'm slightly confused on your question of if the columns are in the same order. I probably confused you in my description.

    I missed that the index was on...

    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

    January 28, 2010 at 2:03 pm

    #1110358

  • RE: To Include or Not to Include (covering indexes)

    Apollo74x (1/28/2010)

    One of the fields showed a huge amount of user seeks on a column that already has an index on it. The only difference, is the missing 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

    January 28, 2010 at 1:44 pm

    #1110348

  • RE: How to add a column to a view

    ALTER VIEW <ViewName>

    AS

    <Entire select statement here>

    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

    January 28, 2010 at 12:59 pm

    #1110321

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/28/2010)

    GilaMonster (1/28/2010)

    CirquedeSQLeil (1/28/2010)

    We meet second Thursday of each month. Pacific Time zone.

    Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm,...

    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

    January 28, 2010 at 11:05 am

    #1110241

Viewing 15 posts - 34,336 through 34,350 (of 49,552 total)