Forum Replies Created

Viewing 15 posts - 12,031 through 12,045 (of 49,552 total)

  • RE: Copy Default trace from a server to your local machine

    The files the default trace creates are normal profiler trace files. You can copy them anywhere, open in profiler, load into SQL, whatever.

    It has a very limited set of events,...

    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 20, 2013 at 9:02 am

    #1643111

  • RE: Returning stored procedure results into a CTE or temp table?

    The INSERT ... EXEC can be used to insert into a table variable or temp table. A CTE however, despite its name, is not a table and hence can not...

    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 20, 2013 at 9:01 am

    #1643108

  • RE: Impact of creating a non clustered index

    Impact in what sense?

    It's going to take time, time in which the table will be locked. It will take space. It will add time to index maintenance. If you've done...

    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 20, 2013 at 7:41 am

    #1643078

  • RE: Benefits of DBCC Check DB and performance

    HanShi (8/19/2013)

    This way the CHECKDB will have less performance impact on the disks with the original databasefiles.

    Exceedingly unlikely, unless you happen to be running CheckDB at a time when large...

    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 20, 2013 at 7:32 am

    #1643073

  • RE: Benefits of DBCC Check DB and performance

    Grant Fritchey (8/20/2013)

    But, by snapshotting to a seperate set of disks and then performing DBCC there, you won't be seeing the physical layout checks run against the original set of...

    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 20, 2013 at 7:29 am

    #1643071

  • RE: Stand by or no recovery in Log shipping ???

    As I said earlier

    Do you need to read the secondary? For example, offloading reports. If so, use standby. If not, use no recovery.

    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 20, 2013 at 5:02 am

    #1643014

  • RE: EXCEPT vs NOT IN vs LEFT OUTER JOIN

    Not sure about the EXCEPT, but...

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    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 20, 2013 at 4:50 am

    #1643012

  • RE: What should be the best approach to identify performance problems in Production environment

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

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

    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 20, 2013 at 4:21 am

    #1643000

  • RE: Issues with partitioning...

    T.Ashish (8/19/2013)

    One more Issue:

    Is it going to change in next version?

    Partitioning is not primarily for performance. It's for management, data loads, easy archiving. That it doesn't magically improve performance...

    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 20, 2013 at 3:43 am

    #1642987

  • RE: Partition Function SQL Server?

    Partitioning is not primarily for performance.

    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 19, 2013 at 5:20 pm

    #1642910

  • RE: Backup during re-index

    Nothing to do with reindex.

    The reason's given. "The specified network name is no longer available.", the network dropped and the backup failed as a result.

    p.s. 18 days to reindex? What's...

    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 19, 2013 at 4:06 pm

    #1642893

  • RE: Removing log information from log file by using DBCC SHRINK FILE

    You can, but bear in mind that only works if the database was shut down cleanly before removing the log. Otherwise you'll end up with a database that fails 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

    August 19, 2013 at 4:04 pm

    #1642891

  • RE: How many log files will exist in a SQL Server Database with 4 secondary files?

    You only need one log file. You can create more, but there's very seldom a good reason to do so.

    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 19, 2013 at 4:02 pm

    #1642889

  • RE: Transaction not getting cleared in SIMPLE recovery model ?

    There's no such thing as a nested transaction. It's a syntactical lie, they don't actually exist.

    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 19, 2013 at 3:45 pm

    #1642882

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/19/2013)

    I think the number of people posting questions without first doing one iota of research has gone up. I also think the homework questions have increased. ...

    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 19, 2013 at 12:21 pm

    #1642807

Viewing 15 posts - 12,031 through 12,045 (of 49,552 total)