Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,526 through 30,540 (of 59,101 total)

RE: Data in tthe same order in which it is inserted

mohammed_suhan (3/29/2012)
Thanks for the suggestions. Table is already created and there is data already in the table. But whenever I insert data from now on, i need to see the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 10:09 pm

#1466730
RE: Do not want to use a cursor but how.....

dwain.c (3/29/2012)
3. Assuming you're on SQL Server 2008, pass all the columns into the SP in a TABLE variable, thus avoiding the need for a loop around the EXEC SP...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 10:02 pm

#1466728
RE: Do not want to use a cursor but how.....

jeffrey.farr (3/29/2012)
Like I mentioned, it just parses the column/variable @TA and stores the data in another table.
Please post an example of what @TA would contain. If it's large, attach...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 10:00 pm

#1466726
RE: What is a good Salary for a DBA with 5 years experience

Heh... if you're currently making $70K, then probably. If you're a good solid DBA that can mentor Developers and do some pretty serious performance tuning, then probably not. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 9:54 pm

#1466724
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

ColdCoffee (3/29/2012)
mark hutchinson (3/29/2012)
@jeff
I was thinking about something that might look like this:
FROM
(Select Distinct CustomerID, ProductCode From #Purchase WHERE ProductCode In ('A', 'B')
) p1
This...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 9:45 pm

#1466722
RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

MyDoggieJessie (3/28/2012)
GOOD LORD JEFF!!! :w00t:
The efficiency of this using the TVF is incredible. I processed a years worth of data in just under 2 minutes...WOW - THANK-YOU!!!
The ROLLUP is not...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 9:27 pm

#1466718
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

Spam reported. And, no... $33 for a pair of jeans is no way to thank anyone.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 9:23 pm

#1466717
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

mister.magoo (3/29/2012)
Yep, I think that's flogged that one to death. I'm sleepy. G'night.
Heh... yeah. And if you've ever seen a picture of me, you know I can definitely use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 8:11 pm

#1466710
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

mister.magoo (3/29/2012)
But I think this just highlights how variable results can be depending on the actual distribution of the data....
And number of processors. Here's the 10M row 500K customer...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 8:02 pm

#1466707
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

It's amazing what adding just a couple of hundred thousand customers will do. 🙂 Here's the 10 million row run with 500,000 customers like Magoo had instead of just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 7:57 pm

#1466705
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

mister.magoo (3/29/2012)
Jeff, did you tweak the CustomerID MOD value from 50000 at all for that?
No, I sure didn't. Let me try that on my box. I'll run it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 7:42 pm

#1466702
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Here are the results from a 10 million row run. And, SURPRISE! We have a new winner! (Jonathan AC Roberts ). Also, keep in mind that I'm...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 7:22 pm

#1466698
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

codebyo (3/29/2012)
Hi, Jeff.
Indeed. I was at work and couldn't test it properly.
I should've noticed that the IN clause may bring results from either A OR B. 🙂
That's an excellent article...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 6:59 pm

#1466695
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Heh... Ok... first, I have to say that I'm amazed. This particular article got twice as many reads in 1/4 the time as the "Generating test data" article did...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 6:51 pm

#1466692
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Toby Harman (3/29/2012)
Hate to point this out, but ColdCoffee's approach is returning inaccurate results.
Specifically, it returns customers 6 and 7 from the original test data.
Not sure what happened there...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2012 at 6:33 pm

#1466686

Viewing 15 posts - 30,526 through 30,540 (of 59,101 total)