Forum Replies Created

Viewing 15 posts - 39,481 through 39,495 (of 49,552 total)

  • RE: trace

    Trace flags are completely separate and distinct from SQL Trace.

    SQL Trace (profiler) is what's shown in the sys.traces view. They are traces of events that occur on the server 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

    April 26, 2009 at 2:27 pm

    #984122

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/26/2009)

    Isn't it beautiful outside this weekend? I'm about to close the lid on my laptop and go commune with nature. This is too pretty...

    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

    April 26, 2009 at 10:07 am

    #984101

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/26/2009)

    True enough, Gail. I'm guilty both of assuming that Flo is on 2005/2008 and that a dashboard application looking at huge files only needs a "close...

    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

    April 26, 2009 at 8:19 am

    #984077

  • RE: 'If Exists'

    buz_gray (4/26/2009)

    I'm new to SQL Server and it's a little exasperating that 'If Exists' should work but seems not to and my alternative does but seems to be little documented!

    Are...

    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

    April 26, 2009 at 8:02 am

    #984073

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/26/2009)

    As for the dashboard, where big tables are concerned, even using

    --

    select count(*) from dbo.sometable as numberOfRows

    --

    is going to run slower than

    --

    declare @tableStats table

    (name varchar(50), numberOfRows int,...

    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

    April 26, 2009 at 7:43 am

    #984067

  • RE: Read Only Server

    Chris Hancock (4/25/2009)

    Maybe someone could convince me that we won't have any sizing problems. Currently we have about 300 users, total Data size approx. 300 GB, largest tables 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

    April 26, 2009 at 5:29 am

    #984057

  • RE: Update table using procedure - Help

    saurabh.dwivedy (4/25/2009)

    I would like to still understand this in a bit more detail - Why does it not work?

    Because it's not valid syntax. Nothing fancier than that.

    Is 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

    April 26, 2009 at 2:50 am

    #984041

  • RE: Maintenance Plan - System Databases - More than just backup?

    DKG (4/26/2009)

    As per my knowledge, The model database is a template, used by Microsoft SQL Server when creating other databases, such as tempdb or user databases. When a new 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

    April 26, 2009 at 2:47 am

    #984040

  • RE: Are the posted questions getting worse?

    WayneS (4/25/2009)

    2. For the slowness of the reports, he was copying the tables needed for a specific report to a temp table (he did not add any indexes to 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

    April 25, 2009 at 3:16 pm

    #984012

  • RE: AdventureWorks in SQL Server 2005

    You'll find it up on Codeplex[/url]. Search for adventureworks and then check the available versions, make sure you get the 2005 version not the QL 2008 version.

    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

    April 25, 2009 at 2:58 pm

    #984010

  • RE: Update table using procedure - Help

    saurabh.dwivedy (4/25/2009)

    Interesting problem. I tried the following options

    DECLARE @Z INT

    SET @Z = (EXEC USP_TEMP111) ---> this does not work. Sql server throws an error saying incorrect syntax near 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

    April 25, 2009 at 1:36 pm

    #984007

  • RE: Are the posted questions getting worse?

    Florian Reischl (4/25/2009)

    The more I learn the more I konw what I do not know

    Psst, Flo, there's typo in your sig.

    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

    April 25, 2009 at 1:28 pm

    #984005

  • RE: Maintenance Plan - System Databases - More than just backup?

    DKG (4/24/2009)

    We used to do intigrity check every day for the system database exludeing model&tempdb

    Why do you exclude model?

    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

    April 25, 2009 at 1:27 pm

    #984004

  • RE: Physically moving the database to be used ona separate server

    You should probably also include a quick installation guide for SQL Express, in case the marker doesn't have it already installed

    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

    April 25, 2009 at 10:38 am

    #983980

  • RE: How to prevent column name changes

    stankirk (4/24/2009)

    OK. Well, that helps me to better understand that I don't know what I'm doing, at least.

    🙂 Not intentional.

    Gail, you have a big picture in mind when you say,...

    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

    April 25, 2009 at 3:53 am

    #983917

Viewing 15 posts - 39,481 through 39,495 (of 49,552 total)