Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,496 through 39,510 (of 59,072 total)

RE: Off topic: Images in the forums

J M-314995 (3/5/2010)
I'm not one that has ever had the need to post any sort of picture/image online. From time to time, I think it would be really helpful...
--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 5, 2010 at 6:40 pm

#1129518
RE: Using Start and End dates to create a number of months column

Garadin (3/5/2010)
Debbie Edwards (3/5/2010)
Its quite exciting to find out about a new bit of SQL 😀
Debbie
I'd agree with that completely. Had some fun playing with "GROUPING SETS" this morning...
--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 5, 2010 at 6:34 pm

#1129516
RE: horizontal vs vertical table structure

chidev (3/4/2010)
The fields will be id - year - revenue - net income - income tax - earnings before tax - etc
If it's truely and only for historical lookups 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)

March 5, 2010 at 5:55 am

#1129102
RE: CLR, to be or not to be, that is the question!

Roust_m (3/3/2010)
I've posted it already: Post #876546
I saw that and didn't see the function being used in the code and figured it was an incomplete listing. I don't see...
--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 4, 2010 at 10:01 pm

#1128946
RE: Calculating Moving Averages with T-SQL

sushil9313333532 (3/4/2010)
hi ..........i m aldon .how 2 improve my sql tech.
By reading very well written articles like this one and by running and studying the code in 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 4, 2010 at 8:24 pm

#1128933
RE: Calculating Moving Averages with T-SQL

Oddly enough, I've been thinking about this problem off and on for the last couple of days and then I saw your article today. I have to agree with...
--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 4, 2010 at 8:22 pm

#1128932
RE: Calculating interest query

This is the link John tried to post...
http://www.imdb.com/title/tt0151804/
It's a cult classic, totally silly, and (unfortunately) sometimes truer than life in a cube. 😛
--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 4, 2010 at 7:25 pm

#1128924
RE: Decoupling in Relational Databases

timclaason (3/3/2010)
And although the "SQL Ninjas" out there were quite offended by the simplicity of the article, along with non-standard terms I used (normalization versus decoupling, bridge tables versus link...
--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 4, 2010 at 7:11 pm

#1128923
RE: Decoupling in Relational Databases

marvin.elder (3/4/2010)
I had never heard of a 'bridge' table in my 30 years of relational database design and modeling.
That's pretty amazing in itself. How about a "relation table" or...
--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 4, 2010 at 6:15 pm

#1128914
RE: A Cheap Fix?

rmechaber (3/4/2010)
We gave it to them in the form of their own server with a SAN "snapshot" delivered from production every night at midnight. I have to say that...
--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 4, 2010 at 9:15 am

#1128557
RE: Best Performance SQL Server version

Thamizh (3/3/2010)
Yes Jeff u r right .Its all about what the customer has but what i want to know is only from the DBA's part.What DBA's like to go blindly...Anyway...
--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 4, 2010 at 8:15 am

#1128529
RE: Best Performance SQL Server version

GSquared (3/4/2010)
Jeff Moden (3/3/2010)
"All the above" depending on what the customer has. It's also not a really good question because of things like the Enterprise Edition of any version...
--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 4, 2010 at 8:12 am

#1128524
RE: Decoupling in Relational Databases

I agree with Gary's comments (and some of the others), as well. If this were the script to one of those 3 to 5 minute little movies that show...
--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 4, 2010 at 6:16 am

#1128456
RE: A Cheap Fix?

reuben.anderson (3/4/2010)
I find that there's rarely (very rarely) a need for business users to write their own queries. Most adhoc data functions can be solved through OLAP tools. If there's...
--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 4, 2010 at 6:03 am

#1128443
RE: A Cheap Fix?

JamesNZ (3/4/2010)
Couldn't you consider using Resource Governor to control what these "power users" can do to stop affecting everything with their users?
Heh... I do use "Resource Governor".... it's called...
--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 4, 2010 at 5:52 am

#1128426

Viewing 15 posts - 39,496 through 39,510 (of 59,072 total)