Forum Replies Created

Viewing 15 posts - 29,236 through 29,250 (of 49,552 total)

  • RE: How can I Pass a Table variable in Stored Procedure?

    Before you wander down this path, please be aware that this is seriously bad practice. It's a major SQL injection vulnerability, it's defeating the point of stored procedures.

    If you want...

    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

    November 23, 2010 at 1:18 am

    #1254222

  • RE: Re LogShipping

    First step. Find the error message.

    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

    November 22, 2010 at 11:26 pm

    #1254191

  • RE: Need to Migrate SSIS 2005 Packages into SSIS 2008

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1024848-148-1.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

    November 22, 2010 at 11:25 pm

    #1254190

  • RE: Need to Migrate SSIS 2005 Packages into SSIS 2008

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1024848-148-1.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

    November 22, 2010 at 11:24 pm

    #1254189

  • RE: Restore from 2008 R2 TRM to 2005 SP2 - is it possible?

    parthi-1705 (11/22/2010)

    Is the version of SQL Server with which the database is to be made compatible. The value must be one of the following:

    80 = SQL Server 2000

    90 =...

    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

    November 22, 2010 at 10:56 pm

    #1254184

  • RE: DBCC Commands like CHECKDB and calculating estimated Duration

    YSLGuru (11/22/2010)

    GilaMonster (11/22/2010)

    I finsihed the DBCC CHECKDB run and it found 0 allocation errors and 12 consistency errors in one table and thats it. The minimu repair level is...

    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

    November 22, 2010 at 10:53 pm

    #1254183

  • RE: How can I Pass a Table variable in Stored Procedure?

    Please post new questions in a new thread. Thanks.

    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

    November 22, 2010 at 10:36 pm

    #1254177

  • RE: tempdb

    Very good question. I had a system with a 1TB database that heavily used tempDB (lots of temp tables all the time). Our TempDB? 6 files of 10GB each. More...

    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

    November 22, 2010 at 3:40 pm

    #1254099

  • RE: DBCC Commands like CHECKDB and calculating estimated Duration

    Run a checkDB, see the output.

    Checksum error is a damaged page, it's a page that has been modified by something since SQL wrote it out to the filesystem. The main...

    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

    November 22, 2010 at 1:44 pm

    #1254020

  • RE: Partition Table Switch Error

    The error states that the clustered index is different. 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

    November 22, 2010 at 1:07 pm

    #1253991

  • RE: How to make data(.mdf) to equal size slices!

    pavan_srirangam (11/22/2010)

    Suggest this then if nothing is the solution then I will force them to change the queries.

    Wrong way around. Fix the cause, not the symptoms

    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

    November 22, 2010 at 1:04 pm

    #1253987

  • RE: How to make data(.mdf) to equal size slices!

    I stand by my original recommendation. Fix the root cause. Don't fix the symptoms.

    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

    November 22, 2010 at 12:34 pm

    #1253961

  • RE: Verifying Backups and status

    First things first. What's the exact version?

    SELECT @@Version

    8.0.7 doesn't match with any version of SQL 2000.

    As for the backups, you're going to have to build up a script yourself. It'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

    November 22, 2010 at 11:45 am

    #1253927

  • RE: DBCC Commands like CHECKDB and calculating estimated Duration

    A logical consistency-based I/O error is an invalid page in the data file (further proven by the incorrect checksum). A physical I/O error is one where the OS was asked...

    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

    November 22, 2010 at 11:37 am

    #1253921

  • RE: DB Status?

    SQL 2000

    Brent's script is written for SQL 2005 and portions for only SQL 2008. That script is not going to run on SQL 2000. Some things can be done, 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

    November 22, 2010 at 11:02 am

    #1253900

Viewing 15 posts - 29,236 through 29,250 (of 49,552 total)