Forum Replies Created

Viewing 15 posts - 23,896 through 23,910 (of 49,552 total)

  • RE: How to Use LIKE with Table variable

    I still don't see a table variable anywhere, nor is there any definition (create table) for the table public.

    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

    August 26, 2011 at 5:40 am

    #1373675

  • RE: Get the Best out of the Database using Optimal Indexes

    Please stop spamming the forums

    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

    August 26, 2011 at 5:37 am

    #1373671

  • RE: How to Use LIKE with Table variable

    I don't see a table variable anywhere there. What's the definition of the table 'public'?

    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

    August 26, 2011 at 5:36 am

    #1373669

  • RE: Back in the saddle

    Christi Wilson (8/26/2011)

    REPEATABLE

    Not a keyword by itself and not new.

    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

    August 26, 2011 at 5:21 am

    #1373662

  • RE: Dead lock problem.

    titan 90903 (8/26/2011)

    Can you explain me one thing. I thought if I set transaction with isolation as serializable then only one proccess can get into trasaction body, and every...

    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

    August 26, 2011 at 4:52 am

    #1373652

  • RE: partitioned index usage by partition

    Index usage is tracked on an index level, not partition level

    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

    August 26, 2011 at 4:45 am

    #1373651

  • RE: What happens if the Domain Controller is down?

    Perry Whittle (8/26/2011)

    If your domain only has 1 domain controlller the services will still run unless you try to restart them, authentication attempts will also be hampered (i.e. logging into...

    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

    August 26, 2011 at 3:41 am

    #1373640

  • RE: sql query takes long time to execute

    Script the indexes the same way you scripted the tables

    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

    August 26, 2011 at 3:20 am

    #1373637

  • RE: Dead lock problem.

    The deadlock is between the select @Count and the update... Two threads are both taking a shared lock on a row that the select is reading and then, when 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

    August 26, 2011 at 2:34 am

    #1373615

  • RE: Backup and old file delete GOTCHAs!

    jpSQLDude (8/25/2011)

    So there are two issues. Right at 12:05am when your Full backups start, there is no TLog backup happening. But the way I've seen it set up, 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

    August 25, 2011 at 4:17 pm

    #1373540

  • RE: Filegroup question

    A clustered index is the data.

    http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    August 25, 2011 at 1:55 pm

    #1373475

  • RE: Stored Procedure's Security

    Devil's Bloody Advocate (8/25/2011)

    My uderstanding is that the only decryptors of stored procedures was based on sql7 and before. When sprocs are encrypted within SQL 2005 & 2008 there 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

    August 25, 2011 at 1:12 pm

    #1373452

  • RE: Help to identify the user database that originated the Insert

    cristiano.testai (8/25/2011)

    Just a consideration. If there are two active connections at the same time in the database and two users concurrently perform an insert in the users table,...

    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

    August 25, 2011 at 1:06 pm

    #1373450

  • RE: Help to identify the user database that originated the Insert

    cristiano.testai (8/25/2011)

    The Users table uses a "identy" for primary key.

    Ok, doesn't change anything

    The moment to save the User I do not have the key code to perform 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

    August 25, 2011 at 12:21 pm

    #1373427

  • RE: Non-clustered indexes

    jwbart06 (8/25/2011)

    I get the same message when I try to create my non-clustered huge index.

    I don't know but I think the exam is wrong!

    The exam likely isn't, but the exam...

    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

    August 25, 2011 at 12:09 pm

    #1373418

Viewing 15 posts - 23,896 through 23,910 (of 49,552 total)