Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,936 through 34,950 (of 59,099 total)

RE: Are the posted questions getting worse?

LutzM (2/22/2011)
Jeff Moden (2/21/2011)
...
I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en tha lak.
Here's my...
--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)

February 25, 2011 at 3:59 pm

#1291823
RE: Odd Questions

Koen Verbeeck (2/25/2011)
I've seen that list of question before, and there are sure some legitimate ones in there, as they are just math quizzes in disguise.
For example:
“Out of 25 horses,...
--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)

February 25, 2011 at 8:30 am

#1291564
RE: Bulk Insert of CSV file

harmand (2/25/2011)
THANK YOU
Another problem. I have catalog table with a description field. If the description has a comma in it the field in the flat file is in double...
--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)

February 25, 2011 at 7:37 am

#1291529
RE: Change rows into column and vice versa without using pivot method.

Please see the following article as a starter... and, yes, we still need to know the version of SQL you are using...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

February 25, 2011 at 7:35 am

#1291528
RE: Change rows into column and vice versa without using pivot method.

anandvish2006 (2/25/2011)
Change rows into column and vice versa without using pivot method.
Which version of SQL?
--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)

February 25, 2011 at 7:32 am

#1291527
RE: Return records at least 10 minutes apart from last valid record without CURSOR

Rob Reid-246754 (2/25/2011)
These are the statements I need to change to reflect the issue in hand, namely that each race needs to be at least ten minutes apart from 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)

February 25, 2011 at 7:28 am

#1291521
RE: Help needed to decode comma delimited string and insert into tables

SQLkiwi (2/24/2011)
JJH82 (2/17/2011)
a table called CLOB contains ROW_ID (pk)
PARSE_CLOB (where the strings sit)
Are you using OPENROWSET BULK SINGLE_CLOB to load the initial table from a file? If so, best...
--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)

February 25, 2011 at 5:12 am

#1291457
RE: Help needed to decode comma delimited string and insert into tables

@JJH82,
Dang... I've just not been able to devote the time to this problem. Do you have a solution, yet, or do you still need help on this one?
--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)

February 24, 2011 at 8:49 pm

#1291350
RE: Return records at least 10 minutes apart from last valid record without CURSOR

@rob-2,
Ok, considering the Quirky Update can do this on a million rows in somewhere between 2 and 7 seconds, I have to ask... are you all set or do you...
--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)

February 24, 2011 at 7:18 pm

#1291344
RE: Return records at least 10 minutes apart from last valid record without CURSOR

SQLkiwi (2/24/2011)
The logic is easier to express in loop form, so if you need speed and elegance, I would transfer the logic to your favourite .NET language (I would 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)

February 24, 2011 at 7:15 pm

#1291343
RE: Grouping and crosstab like behaviour.... hairy query

Your example output has the following in it...
Select '65310-07G00-000' as 'RangeFrom', '65310-07G10-000' as 'RangeTo', '0.2129380000' as 'Factor'
The largest value for 65310 in your...
--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)

February 24, 2011 at 7:20 am

#1290969
RE: Return records at least 10 minutes apart from last valid record without CURSOR

Pseudo-Cursors are great for replacing cursors. It's recursion and triangular joins you usually want to avoid as a replacement.
So far as a replacement so you don't have to redact...
--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)

February 24, 2011 at 7:11 am

#1290959
RE: Temp DB

subha.mcts2005 (2/22/2011)
Hi,
one of my production server Tempdb Mdf file has increased 2GB with in 2 Hours on today morning.
why it was happened? what are the causes for this?
please...
--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)

February 23, 2011 at 4:46 pm

#1290685
RE: View - Need Dynamic From Clause for Cross Server Select/Join

I think Chaz is talking about "synonyms" which work quite well for this sort of thing.
Of course, the best thing to do would be to make your production and test...
--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)

February 23, 2011 at 4:44 pm

#1290684
RE: Finding duplicate values in very large table. Select Row_number() over too slow

I guess I'd have to ask... why do they allow the "dupes" to continue?
--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)

February 23, 2011 at 4:29 pm

#1290681

Viewing 15 posts - 34,936 through 34,950 (of 59,099 total)