Jeff Moden

Forum Replies Created

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

RE: An Introduction to Database Design

SQLkiwi (1/23/2011)
I have made a number of small changes to the published text based on comments received so far. Thanks to everyone for their opinions and insights.
You've folded 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)

January 24, 2011 at 5:52 pm

#1277553
RE: Creating a comma-separated list (SQL Spackle)

UMG Developer (1/24/2011)
You said 10,000 accounts, but your code only creates 1,000. I just wanted to make sure 1,000 is what you ran with so my results would be comparable.
Agh!...
--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 3:17 pm

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

mister.magoo (1/24/2011)
Dave,
I haven't tested yours, but can see that it does not meet with Sir Jeff's strict guidelines....
BWAA-HAA!!!... I'm just the humble tester here. The OP posted the original...
--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 3:14 pm

#1277489
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

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