Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,251 through 35,265 (of 59,099 total)

RE: Are the posted questions getting worse?

Grant Fritchey (1/24/2011)
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
Absolutely awesome. I didn't believe...
--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 24, 2011 at 11:43 am

#1277399
RE: Specialize in SQL Server(DBA, BI Developer)

First, buy a copy of the Developer's Edition for your computer at home and go through the books step-by-step. Then start answering questions on forums like 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)

January 24, 2011 at 7:07 am

#1277179
RE: best SQL Server crash course

GilaMonster (1/23/2011)
Please note: 5 year old thread
Sure it is... and it's still, ummm... "surprising" that companies will hire people for SQL Server without them really knowing anything about SQL Server....
--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 24, 2011 at 6:54 am

#1277170
RE: Are the posted questions getting worse?

Roy Ernest (1/24/2011)
Steve Jones - SSC Editor (1/22/2011)
Definitely not SQL related, but my kid got his black belt today. Very proud of him.
http://www.youtube.com/watch?v=DtIOe4IsUq8
Congrats to both of you... Well done.
Speaking 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 24, 2011 at 6:47 am

#1277168
RE: Are the posted questions getting worse?

mister.magoo (1/24/2011)
Jeff Moden (1/23/2011)
Slight departure from the norm on this thread. One of our own made an absolute killing on a nasty problem. See "mister.magoo"s final code post...
--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 24, 2011 at 6:46 am

#1277167
RE: Filter a table to get unique rows in a certain logic

Agreed. "It Depends". I've found that my old box does some things quite differently especially when compared to something like a laptop.
--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 24, 2011 at 6:18 am

#1277160
RE: Filter a table to get unique rows in a certain logic

mister.magoo (1/24/2011)
ColdCoffee (1/24/2011)
Dave Ballantyne (1/24/2011)
WHILE @@ROWCOUNT=3
Even i have a doubt in the code , Magoo... Do we really need UNPIVOT ? i guess, your code will work even...
--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 24, 2011 at 6:00 am

#1277155
RE: Filter a table to get unique rows in a certain logic

moadh.bs (1/24/2011)
Thx everyone I would never hoped for this number of solutions, I will shrotly post the results.
Moad,
The final solution that Magoo posted is the right one. It both...
--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 24, 2011 at 5:56 am

#1277152
RE: Are the posted questions getting worse?

Slight departure from the norm on this thread. One of our own made an absolute killing on a nasty problem. See "mister.magoo"s final code post on the following...
--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 23, 2011 at 11:04 pm

#1277052
RE: Queries on Queries for Performance

sql_butterfly (1/23/2011)
Hello Sir, its not like I didn't give it a try. I read a lot and tried lotz of options and tested them as well. However whatever I 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 23, 2011 at 10:40 pm

#1277047
RE: Formatting Dates with 3 Character Months (SQL Spackle)

You bet. Thanks for the feedback, the tips, and a couple of other things.
As a side bar, recursive CTE's tend to be a bit slow and resource intensive for...
--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 23, 2011 at 10:05 pm

#1277041
RE: Surely there is a way to import CSV data in this situation?

Brian McGee-355525 (1/23/2011)
My situation:
1. I have a table in one database with a column which contains the contents of a CSV file
2. I have a table in another database into...
--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 23, 2011 at 10:03 pm

#1277040
RE: SQL Server to Calculate net PAY

Considering many local taxes based on address and the like not to mention constantly changing tax laws, my suggestion would be to not do it in SQL Server. 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)

January 23, 2011 at 9:59 pm

#1277039
RE: Filter a table to get unique rows in a certain logic

OMG! How did the old cartoon series used to say it? "Ahhhh, Magoo... You've done it again!". Well done. NOW I can go to bed! ...
--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 23, 2011 at 9:34 pm

#1277037
RE: Filter a table to get unique rows in a certain logic

Ugly is OK... especially if Ugly works fast. I'll give it a try.
--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 23, 2011 at 9:22 pm

#1277035

Viewing 15 posts - 35,251 through 35,265 (of 59,099 total)