Forum Replies Created

Viewing 15 posts - 40,171 through 40,185 (of 49,552 total)

  • RE: another problem I can't seem to work out.

    foxjazz (3/24/2009)

    being as sarcastic as possible, you may control the order if you wish. Maybe using order by??

    Excuse me? I'm trying to help you here. Maybe you can take...

    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

    March 24, 2009 at 9:20 am

    #965313

  • RE: How to Insert Named Marks into a Transaction Log in sql server 2000?

    Please don't start a new thread for an existing problem, especially when you haven't answered the questions that have been asked in the older thread.

    No replies to this thread please....

    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

    March 24, 2009 at 8:55 am

    #965286

  • RE: Recover SQL 2005 (Comp. lvl 80) DB on SQL 2000

    david.griswold (3/24/2009)

    Second, I am fairly new to SQL 2005. I currently have one SQL 2005 server running several DBs in Comp. level 80. Does this mean that 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

    March 24, 2009 at 8:46 am

    #965276

  • RE: another problem I can't seem to work out.

    Edit: Crosspost

    DT1 = select productcontrolid from productcontrol where productcontrolid > @max-2 - 25

    What controls the order? What makes a particular row row 1, not row 13?

    Basically, what I'm asking 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

    March 24, 2009 at 8:40 am

    #965268

  • RE: Date-ing Myself & Other T-SQL Date Tricks (and bad puns)

    YSLGuru (3/24/2009)

    Where did you see this formula listed ofr getting the Start of the month?

    I don't recall seeing it anywhere. The version to trim the time off a date 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

    March 24, 2009 at 8:40 am

    #965266

  • RE: Sysadmin, DB_Owner and Datareader

    Kop_Eoin (3/24/2009)

    So USE [dbname]

    GO

    GRANT VIEW Definition TO [reader_role]

    GRANT VIEW DEFINITION ON [database|schema|object] TO [role|user]

    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

    March 24, 2009 at 8:31 am

    #965254

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/24/2009)

    How many of you all travel to Europe for Pass?

    PASS US if I can afford it (and it's an expensive flight from where I am). Fortunately I don't...

    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

    March 24, 2009 at 8:30 am

    #965252

  • RE: SQL problem: cachestore flush

    The database aspnetdb is set to autoclose. The close of the DB is causing the cache flush.

    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

    March 24, 2009 at 8:26 am

    #965243

  • RE: Automatic Bakup Error

    GilaMonster (3/24/2009)

    Does the SQL Service account have access to 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

    March 24, 2009 at 8:24 am

    #965240

  • RE: Date-ing Myself & Other T-SQL Date Tricks (and bad puns)

    Converting to varchar and back is a poor way of getting the start of month. It's much slower than using date functions.

    select dateadd(mm, datediff(mm,0, getdate()),0)

    Then the formatting to not show...

    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

    March 24, 2009 at 1:44 am

    #964998

  • RE: Automatic Bakup Error

    Does the directory C:\Inetpub\vhosts\httpdocs\ exist? Does the SQL Service account have access to 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

    March 24, 2009 at 1:38 am

    #964996

  • RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

    shishir999_ril (3/23/2009)

    In my SP, I'm trying to delete the No. of rows on the basis of some conditions.

    So, that query is acting as recurssive. Is there a way to change...

    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

    March 24, 2009 at 1:34 am

    #964993

  • RE: DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS

    Vishal Singh (3/23/2009)

    Although, I believe the REPAIR_ALLOW_DATA_LOSS command itself take the database in the SINGLE USER mode..:-)

    It doesn't. You have to explicitly set the DB to single user mode before...

    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

    March 24, 2009 at 1:32 am

    #964992

  • RE: Active Tasks and Recent Posts not worikng Right...

    I mostly use the 'posts since last visit' and I'd like it to be able to contain a day or two's posts. I'm probably not going to read threads older...

    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

    March 23, 2009 at 2:50 pm

    #964798

  • RE: Active Tasks and Recent Posts not worikng Right...

    Steve Jones - Editor (3/23/2009)

    Any suggestions for a setting?

    What's the average number of threads that are posted to per day?

    Maybe have the threshold different for the 3 recent...

    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

    March 23, 2009 at 2:43 pm

    #964791

Viewing 15 posts - 40,171 through 40,185 (of 49,552 total)