Forum Replies Created

Viewing 15 posts - 20,926 through 20,940 (of 49,552 total)

  • RE: Unique key

    shah.simmy (1/18/2012)

    hi this is just que i am confused.

    how many unique key we can have in a table?

    Should be able to have 1000. Of course, that's a little 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 18, 2012 at 12:53 pm

    #1435458

  • RE: SSRS 2008 R2 Security Level Granularity

    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/Topic1238163-1633-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 18, 2012 at 11:34 am

    #1435424

  • RE: About when will SQL Server 2012 be released?

    First half this year is the only thing that MS has stated publicly.

    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 18, 2012 at 11:04 am

    #1435413

  • RE: Identity Out of Step

    Can you post the code that does the inert and the retrieval of the identity?

    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 18, 2012 at 9:48 am

    #1435372

  • RE: Transaction Scopes..

    Are your users happy with getting duplicate data, entire sets of rows multiple times? Have they been asked?

    Have you considered one of the snapshot isolation levels? Have you tuned 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

    January 18, 2012 at 9:34 am

    #1435363

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/18/2012)

    From time to time, the questions are really getting worse.

    This one made my LMAO:

    OP: I have performance issues and I'm totally clueless.

    Gail: Hire a consultant.

    OP: I'm the consultant.

    Gail:...

    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 18, 2012 at 8:45 am

    #1435310

  • RE: Performance Issue In DB

    Geoff A (1/18/2012)

    you could start by looking at your 10 worst performing queries;

    SELECT DISTINCT TOP 10

    t.TEXT QueryName,

    s.execution_count AS ExecutionCount,

    s.max_elapsed_time AS MaxElapsedTime,

    ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0), 0) AS AvgElapsedTime,

    s.creation_time AS...

    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 18, 2012 at 8:17 am

    #1435284

  • RE: Performance Issue In DB

    Dhirju (1/18/2012)

    i m a consultant 😀

    I'll be more specific then. Hire a consultant that specialises in performance tuning.

    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 18, 2012 at 8:07 am

    #1435272

  • RE: IF any of my system database is crashed my sql server will work ah ?

    No. The system databases are required (you might get partially away with a broken MSDB, but SQL Agent would not work)

    Interview question?

    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 18, 2012 at 8:05 am

    #1435268

  • RE: How to find which files are there in backup, without restoring?

    RESTORE HEADERONLY

    Lists the backup sets within the file.

    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 18, 2012 at 7:48 am

    #1435251

  • RE: Performance Issue In DB

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Or hire a consultant.

    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 18, 2012 at 7:47 am

    #1435249

  • RE: Which version to buy

    http://msdn.microsoft.com/en-us/library/cc645993.aspx#SSIS

    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 18, 2012 at 7:47 am

    #1435247

  • RE: Transaction Scopes..

    santhosh_ms3 (1/18/2012)

    I have 2 questions here.

    1. What is the scope of read uncommited transaction isolation - will it be across the session ?

    From the point you enable it to 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

    January 18, 2012 at 7:44 am

    #1435244

  • RE: Maximum transaction size?

    I had a quick look through the SQL error messages table, there's no error message that resembles that. There's messages about aborting the transaction because the log is full, 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

    January 18, 2012 at 7:39 am

    #1435239

  • RE: Maximum transaction size?

    There's no hard limit on the amount of data that a single transaction can process (other than the one imposed by the amount of available log space)

    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 18, 2012 at 6:59 am

    #1435206

Viewing 15 posts - 20,926 through 20,940 (of 49,552 total)