Forum Replies Created

Viewing 15 posts - 40,471 through 40,485 (of 49,552 total)

  • RE: How can I place a stored procedure in a certain file-group ?

    GSquared (3/9/2009)

    Stored procedures and other code objects are, to my knowledge, always in the Primary filegroup.

    Yup. They're stored in the system tables and the system tables are always in PRIMARY.

    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:29 am

    #956120

  • RE: how to exit from a cursor

    Post the code please?

    My guess is you're referencing the cursor after it's deallocated.

    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:11 am

    #955808

  • RE: workout plans

    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 1:09 am

    #955807

  • RE: workout plans

    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 1:00 am

    #955805

  • RE: How to create trigger for all tables in database on insert, update table?

    thieuquanghuy (3/8/2009)

    FOR LOGIN_EVENTS

    The only thing that trigger is going to catch are the CREATE LOGIN, ALTER LOGIN and DROP LOGIN statements.

    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 8, 2009 at 2:05 pm

    #955715

  • RE: Which exeutable file running behind the database?

    Perry Whittle (3/8/2009)

    i had a telephone interview last week for a job and the interviewer asked me to provide port numbers for some commonly used TCP ports (e.g. DNS, SQL,...

    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 8, 2009 at 1:59 pm

    #955712

  • RE: Which exeutable file running behind the database?

    Paul Randal (3/8/2009)

    If you don't know the name of the executable, how can you do resource balancing on a machine with multiple instances - e.g. using WSRM?

    You look it up...

    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 8, 2009 at 1:33 pm

    #955704

  • RE: Urgent : Sql server db tuning

    Dean Cochrane (3/8/2009)

    The correct solution to your problem is not to beat SQL Server into tortured subservience, it is to rewrite the bad code into good code.

    😎 May I steal...

    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 8, 2009 at 1:06 pm

    #955698

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/8/2009)

    Gail, do they have the "Inspector Gadget" cartoon over there? I find that tune flushes everything else out.

    I've seen it, long, long ago. Can't recall...

    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 8, 2009 at 1:04 pm

    #955697

  • RE: Which exeutable file running behind the database?

    Perry Whittle (3/8/2009)

    also depends on if they mean client or server side. Server process is sqlservr.exe

    Server or client, how important is it really for a candidate to know that? Seriously,...

    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 8, 2009 at 11:40 am

    #955690

  • RE: Poll on backup validation

    Paul Randal (3/7/2009)

    So far the most popular answer is that backups are never validated :crazy:

    At least they have backups.

    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 8, 2009 at 11:33 am

    #955689

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/8/2009)

    Yes.... I speak of Him Who Must Not Be Named !! :w00t:

    Flash Gordon?

    p.s. Thank you to whoever started that one. I still have that theme tune...

    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 8, 2009 at 11:23 am

    #955685

  • RE: Are the posted questions getting worse?

    Chris Morris (3/8/2009)

    GilaMonster (3/8/2009)

    Mike is one of those people on my blacklist, due to his repeated demonstrations that he wants us to do the work and present him with a...

    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 8, 2009 at 11:10 am

    #955681

  • RE: Stored Procedure

    sudarram (3/7/2009)

    Please tell me what type of stored procedures are called Housekeeping Stored procedures.

    Depends who you ask. That's not a term with a universally accepted definition.

    Why is it important to...

    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 8, 2009 at 11:09 am

    #955680

  • RE: Lets help the experts help themselves

    Bob Hovious (3/7/2009)

    I think the idea of an articles editorial board is a fantastic one, but having participated in one in another field let me say that is is a...

    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 8, 2009 at 3:22 am

    #955641

Viewing 15 posts - 40,471 through 40,485 (of 49,552 total)