Forum Replies Created

Viewing 15 posts - 32,476 through 32,490 (of 49,552 total)

  • RE: Reject duplicate Time within 01 minute

    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 13, 2010 at 11:27 pm

    #1179668

  • RE: Upgraded SQL 2000 To 2008 ... What Replaces Query Analyzer & Enterprise Mgr?

    Management Studio

    It's on the SQL dvd, you can install it from there onto your workstation. When you run through the installer, deselect the database engine and make sure that workstation...

    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 13, 2010 at 11:27 am

    #1179619

  • RE: backup

    There's no chance of data loss from changing recovery models.

    What you probably want to do is to take a log backup right after going back to full recovery, as tail-log...

    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 13, 2010 at 8:36 am

    #1179606

  • RE: how to secure the database

    Could you explain the situation in more detail please? I'm not sure what you're asking.

    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 13, 2010 at 7:40 am

    #1179604

  • RE: Issue with Ordering of Location names in table

    Sanchit297 (6/13/2010)

    So my requirement is to get the data sorted before the EXE runs and picks data from the tblMainTable or in other words i need to put data 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

    June 13, 2010 at 7:36 am

    #1179603

  • RE: Issue with Ordering of Location names in table

    As I said, putting an order by on an insert statement (insert into tblMainTable select from #TempStore) is a waste of time. Tables are unordered sets and the order that...

    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 12, 2010 at 2:08 pm

    #1179566

  • RE: Issue with Ordering of Location names in table

    If you want rows ordered, you must put an order by on the select that retrieves data from the table. There's no point in an order by on an insert...

    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 12, 2010 at 1:41 pm

    #1179564

  • RE: Index consideration.

    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/Topic936426-360-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

    June 12, 2010 at 7:06 am

    #1179534

  • RE: Index consideration.

    Select * from table requires that SQL read the entire table. There's no index that can help with that operation.

    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 12, 2010 at 7:05 am

    #1179533

  • RE: procedure works without end CPU 100%

    Can you post the definition of the rachunki table, and all indexes on it?

    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 12, 2010 at 7:03 am

    #1179532

  • RE: Corrupt Constraints - How to get rid of

    Please run this an post the full results

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    What's the error that you get when you ty to drop the constraint?

    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 12, 2010 at 2:59 am

    #1179521

  • RE: procedure works without end CPU 100%

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

    Why add a drop indexes?

    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 12, 2010 at 2:42 am

    #1179520

  • RE: Setting up the Primary Key

    This may be worth a read. Bear in mind that by default, the primary key is the clustered index.

    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

    June 12, 2010 at 2:41 am

    #1179519

  • RE: Are the posted questions getting worse?

    GabyYYZ (6/11/2010)

    Hi Steve, I was wondering if you received an email I sent to webmaster@SQLServerCentral.com about an upcoming re-publication of an article I wrote way back? Are articles typically...

    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 11, 2010 at 2:01 pm

    #1179416

  • RE: Are the posted questions getting worse?

    Trey Staker (6/11/2010)

    They use SQL Server as the database and insist on truncating the transaction log nightly before each backup.

    Bad, but not the worst. At least they're insisting...

    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 11, 2010 at 10:47 am

    #1179318

Viewing 15 posts - 32,476 through 32,490 (of 49,552 total)