Forum Replies Created

Viewing 15 posts - 30,496 through 30,510 (of 49,552 total)

  • RE: GetDate() not working

    Brandie Tarvin (9/21/2010)

    Every time I've set a default column to NOT NULL, I'm forced to specify it in all INSERT statements and override it because the INSERT statement will fail...

    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

    September 21, 2010 at 6:14 am

    #1224722

  • RE: Log file increasing

    What's the value of log_reuse_wait_desc in sys.databases for this 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

    September 21, 2010 at 5:35 am

    #1224694

  • RE: SQl Query performace

    Recommendation:

    1) Consider removing that index hint

    2) Widen the index [dbo].[SubCategoryNAICSCode].[IX_NAICSCode], add SubCategoryID as an include column

    What's the total number of rows in the BusinessData table?

    Post revised exec plans (preferably without...

    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

    September 21, 2010 at 4:45 am

    #1224670

  • RE: CHECKDB

    You need to run it, and in non-peak hours is the best time.

    Is weekly enough? Well, depends on how long you retain backups. Ideally you should be running CheckDB...

    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

    September 21, 2010 at 3:31 am

    #1224638

  • RE: I want to attach *.mdf file of Sql server 2000 to Sql server 2008

    Nope. The way to upgrade a SQL database (and said upgrade involves changing the internal file structure, system table definitions and a fair bit more) is to attach it 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

    September 21, 2010 at 3:22 am

    #1224633

  • RE: Create Index SQL 2005

    You're cross joining two tables? Why?

    That in itself will give performance problems if those tables are largish.

    And yes, table definitions, index definitions and execution plan please, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    September 21, 2010 at 2:58 am

    #1224623

  • RE: Datafile increased due to DBCC

    Craig Farrell (9/21/2010)

    To do this, without screwing up workload any more then its going to, it takes a snapshot of the recordset, meaning it makes a copy of it in...

    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

    September 21, 2010 at 2:56 am

    #1224621

  • RE: SQl Query performace

    Yup, something wrong with those xml files. I can't load them either.

    abcim, how did you generate those plans?

    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

    September 21, 2010 at 2:49 am

    #1224618

  • RE: Trace Data from major blocking incident

    Craig Farrell (9/20/2010)

    Edit: Alternate option if you can't run this in a new db... use the (NOLOCK) hint on the sql call for both tables, at the very least 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

    September 21, 2010 at 2:47 am

    #1224616

  • RE: Is this a 2005 bug?

    Jack Corbett (9/20/2010)

    You have to be careful with ISNUMERIC because it doesn't mean that the value will CONVERT/CAST to a numeric data type.

    It means that the value will...

    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

    September 21, 2010 at 2:05 am

    #1224598

  • RE: How to dump a table from a Prod database to a dev database

    sqlbuddy123 (9/20/2010)

    Also... DTS

    Deprecated in SQL 2005, replaced by SSIS, should not be used for new development, will be removed in a future version of SQL Server.

    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

    September 20, 2010 at 3:56 pm

    #1224424

  • RE: Questions for SQL 2008 express edition

    jerry-621596 (9/20/2010)

    The database size is now listed as 10GB making the Express edition practical for more users.

    I believe that's 2008 R2 Express.

    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

    September 20, 2010 at 3:38 pm

    #1224419

  • RE: Log Shipping

    Or, if you don't want to believe me, how about someone who used to work on the storage engine team for SQL 2005.

    http://sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.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

    September 20, 2010 at 3:11 pm

    #1224407

  • RE: Are the posted questions getting worse?

    This misconception is one that I'm getting sick of addressing:

    http://www.sqlservercentral.com/Forums/FindPost989783.aspx

    Or should I say 'trying to address'

    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

    September 20, 2010 at 3:06 pm

    #1224404

  • RE: Log Shipping

    AndrewSQLDBA (9/20/2010)

    I was experiencing the chain being broken when a full backup was taken.

    Andrew, there's something else happening that's breaking the log chain, because full backups do 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

    September 20, 2010 at 3:03 pm

    #1224402

Viewing 15 posts - 30,496 through 30,510 (of 49,552 total)