Forum Replies Created

Viewing 15 posts - 9,616 through 9,630 (of 14,953 total)

  • RE: Deleting Millions of Rows from Multiple Tables

    dmc (5/5/2009)


    I would try my best to avoid the cursor method as well. If the vendor stored procedure is not encrypted, a .net procedure, etc you should be able...

    - 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

  • RE: how to enable auditing in sql server 2005

    You can create your own auditing with triggers, including DDL and login triggers, in 2005.

    - 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

  • RE: Deleting Millions of Rows from Multiple Tables

    Steve Jones - Editor (5/5/2009)


    I would just run the backup, as Gus noted, but I'd log it somewhere as well, maybe for review the next day. Good to know these...

    - 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

  • RE: Give me a strong Solution?

    viswa (5/4/2009)


    Thanks for reply ...

    I am not asking the books.. I need some basic ideas

    Why we are going this performance and when we need this performance tools...

    When i getting 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

  • RE: Deleting Millions of Rows from Multiple Tables

    mtassin (5/5/2009)


    Is there a way to setup a general alert when any database on the system reaches a certain log % full?

    I'd love to do this... but I've got 2000...

    - 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

  • RE: Problem with sum( ) over (partion by)

    Lynn Pettis (5/5/2009)


    I'm thinking that SalesOrder and ReceiptNumber should be reversed allowing SalesOrder to be duplicated. Two receipts for each order. If you make the ReceiptNumber the PRIMARY...

    - 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

  • RE: Percentages performance

    I just tried this:

    set nocount on;

    if object_id(N'tempdb..#T') is not null

    drop table #T;

    if object_id(N'tempdb..#T2') is not null

    drop table #T2;

    create table #T (

    ID int identity primary key,

    Val int);

    insert into #T (Val)

    select abs(checksum(newid()))

    from...

    - 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

  • RE: SET vs SELECT

    JohnG (5/5/2009)


    Jack Corbett (5/5/2009)


    Jeffrey Williams (5/4/2009)


    I generally use SET myself - mostly because it prevents issues where you can get the wrong value returned from a SELECT. When using...

    - 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

  • RE: Are the posted questions getting worse?

    He was yelling.

    - 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

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    I can honestly claim that I dropped out of both kindergarden and college!

    I went to college for 1 quarter. Couldn't stand it.

    I'm thinking of going back to get 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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/5/2009)


    Then you have those that would bite the hand that is trying to feed them.

    Wow! I don't think I've seen that many significant errors in a script...

    - 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

  • RE: Are the posted questions getting worse?

    MarkusB (5/5/2009)


    Ok, I stayed away from this thread so far and it looks like it's about a lot of other things not related to the quality of the questions but...

    - 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

  • RE: Problem with sum( ) over (partion by)

    First, your sample data doesn't work. Lynn already pointed out that the PK can't have duplicate values, but the whole idea for this is that you provide a script...

    - 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

  • RE: disk full

    goparaju.chandu (5/5/2009)


    my d:\\ drive was full. i wnt to some space to D:\\ .

    Buy a bigger drive. Or add more drives to the array.

    - 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

  • RE: Are the posted questions getting worse?

    RBarryYoung (5/4/2009)


    Folks:

    I posted my first Microsoft CONNECT suggestion yesterday. It's suggestion #440375 entitled "Add Query-based bulk EXECUTE", you can find it here. Please...

    - 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

Viewing 15 posts - 9,616 through 9,630 (of 14,953 total)