Forum Replies Created

Viewing 15 posts - 28,846 through 28,860 (of 49,552 total)

  • RE: What caused SQL Server to roll back old changes?

    wa-sql (12/16/2010)

    Any ideas on why a group of transactions could spontaneously roll back without any intentional or accidental user action?

    They wouldn't. SQL doesn't randomly change data. The rule is that...

    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

    December 16, 2010 at 6:03 am

    #1263398

  • RE: SQL DBA Certification Information

    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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

    December 16, 2010 at 3:16 am

    #1263349

  • RE: (urgent) Backup from SQL Server express 2008, restore to 2005?

    It's not possible. Downgrade is not and never has been possible. The compatibility mode is totally irrelevant. The DB is attached to SQL 2008 R2 instance, it's a SQL 2008...

    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

    December 15, 2010 at 3:45 pm

    #1263208

  • RE: Strange Temp Tables

    How much higher than zero?

    Are you absolutely sure there are no user connections of any form?

    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

    December 15, 2010 at 3:43 pm

    #1263207

  • RE: Strange Temp Tables

    mvillegascuellar (12/15/2010)

    I´ve finally know what these things are, Thank you parthi-1705 and GilaMonster, for clearing this up to me. I tested what you told me about a temp table inside...

    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

    December 15, 2010 at 3:16 pm

    #1263193

  • RE: Strange Temp Tables

    parthi-1705 (12/15/2010)

    Please have a look at help file in SQL Server 2008

    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/72bb62ee-9602-4f71-be51-c466c1670878.htm

    on A. Moving the tempdb database Topic

    I'm familiar with moving tempDB. The question is why are you...

    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

    December 15, 2010 at 3:06 pm

    #1263186

  • RE: Strange Temp Tables

    mvillegascuellar (12/15/2010)

    I really think they are not variable tables

    Those are table variables, that's how SQL names them.

    SQL can cache temp tables if they're used a lot, but there's no data...

    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

    December 15, 2010 at 2:48 pm

    #1263172

  • RE: Strange Temp Tables

    parthi-1705 (12/15/2010)

    This are temporary tables ,these tables are created such as running stored procedures with Temp tables.If the stored procedure fails then you will be facing this type of problems.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

    December 15, 2010 at 2:45 pm

    #1263170

  • RE: Slight Problem :(

    LutzM (12/15/2010)

    If you never performed any backup (including transaction log) you must have a huge log file by now... :unsure:

    If they're never run any backups (including full backup) 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

    December 15, 2010 at 2:13 pm

    #1263155

  • RE: where not exists...

    Exists checks for a row in the subquery. Not a matching row. A row. Any row. Hence, because your subquery returns a single row, the NOT EXISTS returns false always....

    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

    December 15, 2010 at 2:09 pm

    #1263149

  • RE: where not exists...

    http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-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

    December 15, 2010 at 2:06 pm

    #1263147

  • RE: How to Make a Dynamic Stored Procedure Query

    dso808 (12/15/2010)

    The above returns an incorrect syntax error. Suggestions? Thanks.

    You posted in the SQL 2008 forum, so I assumed you were using SQL 2008.

    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

    December 15, 2010 at 2:01 pm

    #1263142

  • RE: View is not ordered. Why?

    evald (12/15/2010)

    I'm just trying to say that if the order clause is not working in some cases for some reason than its useless and confusing give the possiblity to 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

    December 15, 2010 at 8:54 am

    #1262936

  • RE: Could not locate entry in sysdatabases for database

    Does it change anything if you wrap the dbname in [] in the use statement?

    sp_msforeachdb 'USE [?];select db_name()'

    p.s. No need for distinct, you're selecting a single constant value.

    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

    December 15, 2010 at 8:44 am

    #1262927

  • RE: sql performance

    homebrew01 (12/15/2010)

    premkuttan.lakshmanan (12/15/2010)

    in sp_who2 the coressponding blkby for spid 101 is 101 and in the corresponding command column it shows as killed/Rollback . Does it mean that the activity 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

    December 15, 2010 at 8:17 am

    #1262882

Viewing 15 posts - 28,846 through 28,860 (of 49,552 total)