Forum Replies Created

Viewing 15 posts - 151 through 165 (of 459 total)

  • RE: Usage Based Pricing

    Binary1010 (3/3/2010)

    My favorite example of a terrible pricing "scheme" is a vendor (won't name names...it's not microsoft) that wanted to charge us first for the software on a per user...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 3, 2010 at 8:41 am

    #1127835

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/3/2010)

    GabyYYZ (3/3/2010)

    Alvin Ramard (3/1/2010)

    ...

    Most of the talk that I heard about medal standings referred to total medal count, not the number of gold medal. I think it...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 3, 2010 at 8:32 am

    #1127824

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/1/2010)

    ...

    Most of the talk that I heard about medal standings referred to total medal count, not the number of gold medal. I think it would make more...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 3, 2010 at 8:17 am

    #1127804

  • RE: Randomizing Result Sets with NEWID

    Paul White (3/1/2010)

    GabyYYZ (3/1/2010)

    One option, especially if you have an indexed identity column on your source table, is to generate a separate table of random row numbers, create a clustered...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 2, 2010 at 7:55 am

    #1127115

  • RE: Ditch the Clustered index on a table?

    arr.nagaraj (3/2/2010)

    Not too sure whether I got your question correct, But anyways thought of asking this.

    Did you try disabling the Non clustered index during the pruning process and then enabling...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 2, 2010 at 7:38 am

    #1127091

  • RE: Randomizing Result Sets with NEWID

    SQLBOT (3/1/2010)

    I also forgot to say that there is the NEWSEQUENTIALID() function if you're going to batch load.

    That should wreck your cluidx a little less, too.

    If NEWSEQUENTIALID() is the default...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 2, 2010 at 7:35 am

    #1127084

  • RE: Randomizing Result Sets with NEWID

    Neil Franken (3/1/2010)

    Hi There

    Cool article but here is what I have found with newid().

    ...

    Right lets say the profile(salary) matches 1,5 million rows in the database. SQL server will return all...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 1, 2010 at 7:51 am

    #1126459

  • RE: Most efficient way to retrieve top identity value.

    GSquared (2/2/2010)

    Like Lowell said, the Output clause can get that for you pretty efficiently. I've used that lots of times in lots of procs.

    Thanks everyone for their help, and...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 4, 2010 at 12:52 pm

    #1113948

  • RE: Enabling Encryption in SQL 2008 but preventing DBA's/System Admin role from viewing encrypted data

    really? I was under the impression that PCI meant I couldn't see the data at all during routine maintenance...Hmm...this could make things interesting.

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 29, 2010 at 10:55 am

    #1110887

  • RE: Are the posted questions getting worse?

    GilaMonster (1/25/2010)

    Urgent! Urgent! Urgent!

    http://www.sqlservercentral.com/Forums/Topic853117-145-1.aspx

    Exterminate! Exterminate!

    You know, sometimes I feel like recommending people use MS Access. (I have a headache...where's my sledgehammer?)

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 25, 2010 at 1:17 pm

    #1108361

  • RE: Search all columns in every table for a value

    Timothy Graffham (1/25/2010)

    You might consider removing the wildcards from the dynamic sql and allow them to be specified in the search string. That way, you could explicitly specify left...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 25, 2010 at 1:12 pm

    #1108356

  • RE: Search all columns in every table for a value

    I have a colleague working on a side project to search all columns for any errant information that looks like a credit card and I was wondering if there are...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 25, 2010 at 7:36 am

    #1108145

  • RE: Perfect is the Enemy of Good

    See signature... 🙂

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 20, 2010 at 7:47 am

    #1106054

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (1/6/2010)

    GabyYYZ (1/6/2010)

    Kit G (1/6/2010)

    GilaMonster (1/6/2010)

    GSquared (1/6/2010)

    If you can't access it, try Tarot cards to figure out the password.

    I have a set, if you need me to do a...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 6, 2010 at 11:57 am

    #1099836

  • RE: SQL Server Agent Schedule Decoder

    tskelley (1/6/2010)

    Thanks, great script. And yes, SQL 2005 or higher. I am one of those dinosaurs that still defaults to SQL2000 to keep customer backward compatibility.

    As for the...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    January 6, 2010 at 9:20 am

    #1099686

Viewing 15 posts - 151 through 165 (of 459 total)