Forum Replies Created

Viewing 15 posts - 12,046 through 12,060 (of 14,953 total)

  • RE: Two databases with the same physical file names and locations

    Same logical names does make sense. Glad you got that sorted out.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 11:37 am

    #869198

  • RE: Two databases with the same physical file names and locations

    I must be missing something here. You can't have two files on the same computer with the same name in the same directory. File systems don't work that...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:49 am

    #869150

  • RE: Questions on File Placement

    Matt Cherwin (9/9/2008)

    What GSquared said, with one addition: in the SAN environments I've worked in, two LUNs with different RAID levels will automatically be on separate spindle sets. So, even...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:47 am

    #869148

  • RE: Maintenance plans failing.

    I found a page that might have relevant data: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1410900&SiteID=1

    Try that. The post there was solved by changing the command to update the value.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:46 am

    #869147

  • RE: Questions on File Placement

    Multiple logical drives gives no advantage. Splitting across phyisical drives gives you several advantages. I've tested this.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:39 am

    #869141

  • RE: specific character validation

    I can't duplicate the behavior you're describing with what I have for testing. Might be something specific to your data.

    Are the stats up-to-date on your tables? Are the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:25 am

    #869128

  • RE: Joining to empty tablecausing problem

    MrBaseball34 (9/8/2008)

    GSquared,

    Looks good except I need to filter by the o.MRN and o.DateOfService.

    Also many records come over with Comments and several others have NULL Comments.

    The particular DOS that I am...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:19 am

    #869123

  • RE: SPID Blocking itself with Sch-S on a table variable

    SPIDs are re-used and can have different owners very easily. Might be as simple as that.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:16 am

    #869119

  • RE: Newbie need help with SQL script

    Correct me if I'm not understanding this correctly:

    What you seem to be doing is moving data from a production environment to a testing environment in order to test new/modified code...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:10 am

    #869115

  • RE: save varbinary in file

    I think I need to know a bit more about what you're storing and how you're trying to retrieve it. You mentioned something about text files, but not why...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:04 am

    #869112

  • RE: Cascading delete in many to many

    mitch (9/8/2008)

    Many thanks guys, you've made me rethink my approach to this. My reason for having the tPerson and tChild tables seperate is that the tPersons are parents 99% of...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 9:02 am

    #869111

  • RE: Reporting Services

    Reports are just XML definitions. You should be able to just add them.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 9, 2008 at 8:50 am

    #869098

  • RE: MISSING CONSTRAINTS AND TRIGGERS

    Download a free trial of ApexSQL Diff, or RedGate Compare, and that will find the missing stuff and create a script that will do all of the fixing for you....

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 8, 2008 at 12:08 pm

    #868651

  • RE: specific character validation

    I'd move the part about validname like '%' + badname + '%' to the Join clause, but otherwise it looks fine.

    I created a 100-thousand row copy of your table and...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 8, 2008 at 12:07 pm

    #868649

  • RE: Joining to empty tablecausing problem

    First, why a Full Outer Join? I'd make it a left join. That won't affect your issue, but it will improve performance.

    Second, why a cursor? Why not...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    September 8, 2008 at 11:50 am

    #868638

Viewing 15 posts - 12,046 through 12,060 (of 14,953 total)