Forum Replies Created

Viewing 15 posts - 8,011 through 8,025 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/25/2014)

    Oh dear, the backup process for the production database is changing the recovery model of the development database. Help me.

    I've seen that in production systems. Multiple times.

    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, 2014 at 2:29 pm

    #1740860

  • RE: DBCC DBREINDEX results in INSERT INTO [table1] SELECT * FROM [table1]

    Maxer (8/25/2014)

    So I wonder why my profiler trace isn't showing that activity, maybe a function of table size or something? (Or I am missing some columns)

    Probably the events your capturing.

    Also,why...

    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, 2014 at 10:19 am

    #1740758

  • RE: DBCC DBREINDEX results in INSERT INTO [table1] SELECT * FROM [table1]

    Yup, the guy's right.

    Please note that DBCC IndexRebuild is deprecated, has been so since SQL 2005. Use ALTER INDEX.

    As for examining the code of DBCC Index Rebuild, you'd have...

    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, 2014 at 10:09 am

    #1740756

  • RE: upgrade fail/slow rollback?

    Grant Fritchey (8/25/2014)

    Instead of downgrading, I'd suggest tuning the queries and structures so that they perform better. There's not a massive known improvement in performance between most SQL Server versions....

    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, 2014 at 8:41 am

    #1740739

  • RE: Drop Existing while creating Index

    er.mayankshukla (8/25/2014)

    Why unique clustered is only allowed with drop_existing as ON.

    It isn't. You can drop a unique clustered index. You can create a unique clustered index without the DROP_EXISTING clause.

    Besides,...

    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, 2014 at 7:42 am

    #1740708

  • RE: upgrade fail/slow rollback?

    Sapen (8/25/2014)

    But a day/two's worth of data is in the 2012 database and I will have to do a data compare and move over the new records to the 2008...

    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, 2014 at 7:39 am

    #1740705

  • RE: CTE

    Can't see anything wrong.

    Make sure that the statement before the CTE (if there is one) is terminated 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

    August 25, 2014 at 3:58 am

    #1740649

  • RE: CTE

    What error are you getting?

    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, 2014 at 3:47 am

    #1740646

  • RE: Drop Existing while creating Index

    er.mayankshukla (8/25/2014)

    Well It means that whenever I fire Drop and create index command with drop_existing option.

    Sql engine waits to check for create command after drop command.

    No. If you run 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

    August 25, 2014 at 2:38 am

    #1740636

  • RE: Drop Existing while creating Index

    er.mayankshukla (8/25/2014)

    What if I Only fire a drop Clustered Index command and NO Create command ?

    Then every single nonclustered index on the table will be rebuilt, they have to be...

    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, 2014 at 2:23 am

    #1740633

  • RE: High value of work files and Work table

    WhiteLotus (8/24/2014)

    How do I know which query or StoreProc that has crap code because there are hundreds of StoreProc?

    You don't.

    This is one of the flaws at looking at just perfmon...

    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, 2014 at 1:01 am

    #1740626

  • RE: Question regarding the difference between two different ways to populate a new table in TSQL

    Jeff Moden (8/23/2014)

    Cathy DePaolo (8/22/2014)

    I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve...

    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 24, 2014 at 2:30 pm

    #1740588

  • RE: InPlace Updates for Key columns

    Lowell (8/22/2014)

    i believe it's a design structure built into SQL, where in place updates are never truly performed.

    False.

    Inplace updates are indeed performed. Any update which is not a key column...

    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 23, 2014 at 3:17 am

    #1740457

  • RE: InPlace Updates for Key columns

    Because a change to a key column (key of an index) means that the row must move from one page to another (indexes are logically ordered by their keys). If...

    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 23, 2014 at 3:16 am

    #1740456

  • RE: Are the posted questions getting worse?

    That was the post, I didn't remember exactly and couldn't be bothered looking.

    I've said many times that indexes won't help poor *query* design and that indexes shouldn't be created where...

    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 23, 2014 at 3:06 am

    #1740453

Viewing 15 posts - 8,011 through 8,025 (of 49,552 total)