Forum Replies Created

Viewing 15 posts - 32,416 through 32,430 (of 49,552 total)

  • RE: user security

    Yup.

    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

    June 16, 2010 at 8:28 am

    #1181020

  • RE: Exec Stored Procedure

    Please post table definitions and sample data. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    What's the dynamic SQL string that gets executed? Use Print...

    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

    June 16, 2010 at 6:08 am

    #1180889

  • RE: Non Disclosure Agreements (What's the point?)

    Steve-3_5_7_9 (6/16/2010)

    Are you talking about South Africa, or somewhere else?

    SA. Need multiple written warnings, proof of disciplinary hearings and the dismissed person can still take the case 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

    June 16, 2010 at 6:07 am

    #1180887

  • RE: user security

    The sa login cannot be dropped. There's also no way to obtain a password. If you have another sysadmin login, you can change the sa password.

    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

    June 16, 2010 at 5:56 am

    #1180880

  • RE: Exec Stored Procedure

    Are there any rows in the table with a classification of 0?

    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

    June 16, 2010 at 5:55 am

    #1180879

  • RE: Non Disclosure Agreements (What's the point?)

    Steve-3_5_7_9 (6/16/2010)

    Actually, this makes a lot of sense. Sometimes it is difficult to terminate someone, especially if they have great performance reviews, so having a NDA on record would...

    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

    June 16, 2010 at 5:53 am

    #1180877

  • RE: Help in writing this query

    Patience, this is a forum, not a chat room. When someone has time they'll help you.

    You want to maybe show us the query that you're using? The one that doesn't...

    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

    June 16, 2010 at 5:14 am

    #1180867

  • RE: Help in writing this query

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    June 16, 2010 at 3:58 am

    #1180843

  • RE: Error in My Function Syntax

    If your function states RETURNS TABLE (inline table valued function), what must follow the RETURNS statement is a single select statement, nothing else. If you want IF statements, you need...

    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

    June 16, 2010 at 3:45 am

    #1180839

  • RE: Microsoft SQL Certification - Beginners

    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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

    June 16, 2010 at 3:30 am

    #1180837

  • RE: Are the posted questions getting worse?

    Jack Corbett (6/15/2010)

    Been off-line for a couple weeks of vacation and have 1 more week left with intermittent internet access and when I am on-line I'm ranking abstracts for the...

    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

    June 16, 2010 at 3:24 am

    #1180835

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (6/16/2010)

    Damn Damn Damn, ive mislaid my sql magic wand.

    http://www.sqlservercentral.com/Forums/FindPost937995.aspx

    Perhaps if i shouted at the server .....

    Well he's got index scans, not seeks, so there is a slight possibility...

    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

    June 16, 2010 at 3:16 am

    #1180833

  • RE: TSQL query Performance Issue

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Try reversing the order of the columns in the nonclustered index on TableB. Make it (TableBName, TableAGuid)

    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

    June 16, 2010 at 3:16 am

    #1180832

  • RE: Where is my declared table stored?

    sachnam (6/16/2010)

    temprary variables like in your case pyhsically remains in RAM.

    Temp table or Hash(#) tables are kept in the data file of a Tempdb database till the session 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

    June 16, 2010 at 2:52 am

    #1180822

  • RE: INDEX REBUILD

    There are lots of good custom scripts that will rebuild just those indexes that need it. Try the one Michelle wrote - http://www.sqlfool.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

    June 15, 2010 at 2:20 pm

    #1180670

Viewing 15 posts - 32,416 through 32,430 (of 49,552 total)