Forum Replies Created

Viewing 15 posts - 39,466 through 39,480 (of 49,552 total)

  • RE: Lock Store Procedure in sql 2005

    For what it's worth, there is virtually nothing you can do in SQL to stop an administrator from doing what he wants with the 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 27, 2009 at 10:09 am

    #984470

  • RE: Ndx Corruption

    If, after you've got the checkDB results, you're not 100% sure what they mean or what you need to do, post the full output of checkDB and someone will help...

    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 27, 2009 at 10:08 am

    #984468

  • RE: SQL Server 2005 won't start with "not enough space" error

    My guess is that someone altered the starting size of tempDB. If I recall, such changes only happen when SQL restarts.

    You should be able to start SQL if you use...

    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 27, 2009 at 9:41 am

    #984444

  • RE: Abusing Table Variables?

    Mohit (4/27/2009)

    In my experiment I populated it with 1000 rows; using that sample code it was about 2300 reads, and using adjust code that is just selecting the rows 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 27, 2009 at 9:36 am

    #984440

  • RE: .ldf file is very big

    Please read through this - Managing Transaction Logs[/url]

    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 27, 2009 at 9:34 am

    #984437

  • RE: assembly does not allow partially trusted callers

    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/Topic705013-359-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

    April 27, 2009 at 9:33 am

    #984436

  • RE: In which location the SQL Server objects are stored

    This query, when run in the context of the DB in question, will show you where all the files associated with that database are.

    select name, filename from sysfiles

    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 27, 2009 at 4:10 am

    #984242

  • RE: SQL Server Version Info

    Alberto De Rossi (4/24/2009)

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

    Major and minor version of SQL as well as the CPU architecture. The 8.00.2039 indicates SQL 2000...

    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 27, 2009 at 2:03 am

    #984210

  • RE: In which location the SQL Server objects are stored

    Tables, views, functions and procedures are all stored within the database file, hence there's no path to them. Or are you looking for the location of the SQL database files...

    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 27, 2009 at 1:56 am

    #984207

  • RE: Abusing Table Variables?

    Mohit (4/26/2009)

    any recommendations I can do from SQL Side to improve it? I am getting TempDB relocated to a new SAN hdd next week to give tempdb it's own...

    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 27, 2009 at 1:50 am

    #984202

  • RE: A strange problem with 'select' performance

    johny (4/26/2009)

    To GilaMonster:

    It should take a same time for all the records when using NVARCHAR.

    But now the records ending with '9' take much more time than the non-9 records.

    This 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

    April 27, 2009 at 1:35 am

    #984200

  • RE: Why Cursor is Slower?

    Wish (4/26/2009)

    I got the answer why cursor is slow. It acquires locks which table variable does not do, and that is why Cursor is

    slow.

    Nope. Cursors are slow because they...

    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 4:31 pm

    #984142

  • RE: Are the posted questions getting worse?

    RBarryYoung (4/26/2009)

    For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from my hospistal bed,...

    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 3:16 pm

    #984132

  • RE: Abusing Table Variables?

    Not about the code itself, but do you have permission from the vendor to post their code up in public? If not, it might be a good idea to write...

    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:57 pm

    #984128

  • RE: SQL Injection?

    sqlqueue (4/26/2009)

    so how i can i dig more towards it ? and if my server is impacted with sql injection issue how can i figure out ?

    You're going 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

    April 26, 2009 at 2:30 pm

    #984123

Viewing 15 posts - 39,466 through 39,480 (of 49,552 total)