Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,396 through 31,410 (of 59,101 total)

RE: Numbers

bitbucket-25253 (1/3/2012)
Thank goodness for Jeff Moden's writing in the series of articles called "SPACKLE"
Speakiing of thos short but SO INFORMATIVE ARTICLES, what happend to the entry in the left...
--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)

January 16, 2012 at 8:15 pm

#1434379
RE: about the site itself

SQLRNNR (1/13/2012)
LutzM (1/13/2012)
The "missing" reputation system might be exactly the reason for this site to be what it is to me: the best and most professional SQL Server site.
I prefer...
--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)

January 16, 2012 at 7:29 pm

#1434375
RE: multiple column in one column with same id

mario.balatellii (1/16/2012)
i can't do it like that..
Gosh... if you set the output mode of the result window to TEXT with "columns" instead of the GRID mode, then Paul's answer would...
--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)

January 16, 2012 at 7:14 pm

#1434374
RE: Getting the difference from current row and previous row

hemaljoes (1/16/2012)
However temp table has about 12,000 rows.
There for executing the query it take about 90 seconds.
How can I do my query in less time.
I believe you may have a...
--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)

January 16, 2012 at 7:00 pm

#1434373
RE: Data Warehouse Design Suggestion

sdhan79 (1/15/2012)
Hi all, I am about to build my first DW for our company. I tried build one last year, but I was pulled into another project, and...
--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)

January 16, 2012 at 4:17 pm

#1434358
RE: Returning a column per date in a range

SQL Kiwi (1/16/2012)
If you oppose the idea that people should be allowed to explore recursive solutions in general, please explain your reasoning.
Nope... not opposed to rCTEs... just counting rCTEs. ...
--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)

January 16, 2012 at 9:04 am

#1434123
RE: Are the posted questions getting worse?

Roy Ernest (1/16/2012)
Change of topic... I got my second part of my Audit series published here... Yay..!!!!
And I got a A+ review for the year 2011 from my CTO. So...
--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)

January 16, 2012 at 7:34 am

#1434073
RE: Are the posted questions getting worse?

GilaMonster (1/16/2012)
I really wish people would stop assuming that the exams have questions like 'What role do you need to perform bulk insert', because they don't. Back in the 2000...
--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)

January 16, 2012 at 7:33 am

#1434071
RE: Returning a column per date in a range

SQL Kiwi (1/16/2012)
Yes, but how do you know there isn't a superior recursive solution to this problem? Are you assuming there isn't? I have no problem with people linking to...
--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)

January 16, 2012 at 7:29 am

#1434067
RE: Returning a column per date in a range

SQL Kiwi (1/16/2012)
As you know, there are cases where recursive CTEs provide the optimal solution. Had I read, and taken literally, your article on counting rCTEs, I might never have...
--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)

January 16, 2012 at 7:22 am

#1434066
RE: Returning a column per date in a range

SQL Kiwi (1/15/2012)
Jeff Moden (1/15/2012)
Were you or were you not saying that it would be ok to use a counting rCTE here (for this particular problem) or not?
I was saying...
--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)

January 16, 2012 at 5:14 am

#1434002
RE: Are the posted questions getting worse?

GilaMonster (1/16/2012)
The question is, how else do you use the practice tests? Using them, seeing that you're short on a particular area and ignore it? Using them, seeing that you're...
--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)

January 16, 2012 at 4:57 am

#1433990
RE: Creating million row test tables?

I absolutely agree... the warning about NEWID() not producing precisely the same information for any two runs is well known and the reminder is much appreciated. Most demonstrations of...
--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)

January 16, 2012 at 4:24 am

#1433976
RE: Returning a column per date in a range

@paul-2...
SQL Kiwi (1/11/2012)
drew.allen (1/11/2012)
Bob Cullen-434885 (1/10/2012)
I started to look at an alternative approach, using a recursive CTE to generate a continuous list of dates that covered the report range
Jeff Moden...
--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)

January 15, 2012 at 7:27 pm

#1433873
RE: Creating million row test tables?

SQL Kiwi (1/13/2012)
Regarding:
GSquared (1/12/2012)
Another way is to get something like RedGate's data generator.
For any serious usage, this is a much better approach than hacking something together based on NEWID. ...
--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)

January 15, 2012 at 7:00 pm

#1433872

Viewing 15 posts - 31,396 through 31,410 (of 59,101 total)