Forum Replies Created

Viewing 15 posts - 30,961 through 30,975 (of 49,552 total)

  • RE: CTE - How to surpass the limit

    shield_21 (9/1/2010)

    I just noticed now, when I set statistics io to on and run split8k function (using VARCHAR(7999) data type), it produces no result.. Does it mean, it has 0...

    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 1, 2010 at 6:05 am

    #1214885

  • RE: Are the posted questions getting worse?

    BrainDonor (9/1/2010)

    Was August the month for SHRINKDATABASE and SHRINKFILE? The forums appeared to have these through them like a stick of sea-side rock for the past month.

    I'm surprised Gail's link...

    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 1, 2010 at 6:03 am

    #1214883

  • RE: FILEGROUP BACKUP RESTORATION

    Yes.

    Please, please, please read up on this in BoL.

    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 1, 2010 at 12:56 am

    #1214755

  • RE: FILEGROUP BACKUP RESTORATION

    You need to restore primary first (from a filegroup backup of primary or a full db backup) then you can restore the backup of the other file group. You'll also...

    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 1, 2010 at 12:45 am

    #1214747

  • RE: need help to copy database from SQL server 2000

    Why don't you just take a backup of the 2000 database and restore it on SQL 2005? Far easier than scripting and importing

    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 31, 2010 at 3:57 pm

    #1214629

  • RE: Timeouts across multiple applications

    Won't be much, if anything, of use in the default trace. It's got a limited set of events.

    Run a server-side trace (Not using the profiler GUI) and have a go...

    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 31, 2010 at 3:45 pm

    #1214623

  • RE: Killed/Rollback

    Please note: 6 year old thread.

    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 31, 2010 at 3:42 pm

    #1214621

  • RE: WITH CLAUSE

    Edit: Nevermind...

    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 31, 2010 at 3:10 pm

    #1214615

  • RE: Is BCP deprecated in SQL 2008 R2 or not?

    Jan Van der Eecken (8/31/2010)

    I sometimes wonder where these kinds of unsubstantiated statements come from.

    People misunderstanding what they've read or been told. People making stuff up to make themselves sound...

    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 31, 2010 at 2:28 pm

    #1214594

  • RE: Error on creating a stored procedure

    You have an END without a BEGIN. Remove the END or add a matching BEGIN.

    p.s. Shouldn't the NOCOUNT ON be before the update, not after?

    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 31, 2010 at 12:57 pm

    #1214561

  • RE: Is BCP deprecated in SQL 2008 R2 or not?

    Or run profiler while a bcp task is running and see if it fires either of the Deprecation Announcement or Deprecation Final Support 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 31, 2010 at 12:40 pm

    #1214551

  • RE: Is BCP deprecated in SQL 2008 R2 or not?

    Look under the BCP entry in Books Online. If there is no deprecation message there, it is not officially deprecated.

    Ask the client's program manager to get you the source for...

    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 31, 2010 at 12:37 pm

    #1214550

  • RE: name in sys.master_files is different than database name

    The 'name' column in sys.master_files isn't the database name. It's the logical name of the file. To get the database name, either join to sys.databases or use the db_name function

    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 31, 2010 at 12:32 pm

    #1214545

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/31/2010)

    Ray K (8/31/2010)

    Steve Jones - Editor (8/31/2010)

    I'm not surprised, I think we have more and more hybrid people.

    You're right. I run on both gasoline and electricity.

    :hehe:

    For me...

    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 31, 2010 at 12:28 pm

    #1214540

  • RE: Are the posted questions getting worse?

    WayneS (8/31/2010)

    Hey gang...

    I saw a post yesterday (I think) where someone had figured out how to post the greater-than/less-than signs in code snippets where they would show up that way....

    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 31, 2010 at 12:27 pm

    #1214538

Viewing 15 posts - 30,961 through 30,975 (of 49,552 total)