Forum Replies Created

Viewing 15 posts - 45,046 through 45,060 (of 49,552 total)

  • RE: A Release from Data

    David Reed (8/14/2008)

    My wife and I met on the sparring mat in a college ROTC unarmed combat course; she broke my nose and I knew that she was 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 14, 2008 at 10:58 am

    #858256

  • RE: DMV For Index Maintenance In 2005

    Paul Timmerman (8/14/2008)

    1. I am using sys.dm_db_index_physical_stats. How exactly is this data kept current? It is very convenient to have this is handy management view, but I...

    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 14, 2008 at 10:38 am

    #858243

  • RE: Index Question

    Mark Beringer (8/14/2008)

    The tables has about 40 Columns, I have 14 reports that all expect the 3 WHERE clause conditions, the only difference are the columns that are returned, 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 14, 2008 at 9:50 am

    #858197

  • RE: SQL Server 2005 not using all CPU in multiprocessor (peak on 1 cpu alternatively)

    Usually that's because some other resource is a bottleneck. It's fairly hard on modern servers to max out a lot of CPUs for long periods due to the much slower...

    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 14, 2008 at 9:49 am

    #858195

  • RE: Sql Server 2000 Std using only 25% CPU

    Won't help. SQL does not use one CPU per datafile or anything like that. Decisions around splitting data files should be based on IO load. Secondary log files are usually...

    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 14, 2008 at 9:11 am

    #858162

  • RE: User Stored Procedure Starting Name with sp_

    Paresh Randeria (8/14/2008)

    "When you call a stored procedure that starts with sp_, SQL Server always checks the master database first, even if the stored procedure is qualified with the database...

    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 14, 2008 at 9:01 am

    #858147

  • RE: A Release from Data

    Ted Pin (8/14/2008)

    I preferred bo staff. I still yearn to try Kendo however...

    I prefer bokken, with jo staff a close second. Never tried a bo, it looks difficult.

    I tried Kendo...

    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 14, 2008 at 8:52 am

    #858137

  • RE: Strange DBCC CHECKDB error

    sunshine (8/14/2008)

    But I'll run without that now.

    Please do. I would like to see just the informational output without any comments on repair.

    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 14, 2008 at 8:50 am

    #858134

  • RE: Unable to attach db

    jigo0624 (8/14/2008)

    We have a system where the log file got full. By accident (or not) the log file was deleted. I tried attaching the mdf file but 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

    August 14, 2008 at 8:41 am

    #858129

  • RE: Strange DBCC CHECKDB error

    sunshine (8/14/2008)

    No good backup, this db has been corrupt for quite some time, i'm trying to fix what i can with what i have.

    this is the output with no...

    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 14, 2008 at 8:40 am

    #858127

  • RE: Developers using Profiler

    rocky (8/14/2008)

    Should developers be allowed to use Profiler in development and test regions?

    All opinions appreciated, thanks!

    In dev and test, I would say yes. It helps a lot in testing and...

    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 14, 2008 at 8:36 am

    #858118

  • RE: Index Question

    Mark Beringer (8/14/2008)

    After testing the STATISTICS IO & TIME I have found that the Clustered Index Scan has more reads but took less time to execute then the Index Seek.

    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 14, 2008 at 8:33 am

    #858112

  • RE: Strange DBCC CHECKDB error

    That's refering to the allocation pages (GAM, SGAM, PFS). They're not actually objects, but they say which pages in the files are used, available and how much space on them....

    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 14, 2008 at 8:31 am

    #858108

  • RE: New SQL Server Injection Attack????

    bcronce (8/14/2008)

    Last timeI created a web app, there was a procedure to test to see if incoming data was valid SQL and if so, to throw an exception. How does...

    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 14, 2008 at 8:24 am

    #858104

  • RE: Index Question

    Mark Beringer (8/14/2008)

    Thanks for your help, I will check the tme and reads! 🙂

    STATISTICS IO

    and

    STATISTICS TIME

    are the best for this. (both SET options)

    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 14, 2008 at 5:18 am

    #857959

Viewing 15 posts - 45,046 through 45,060 (of 49,552 total)