Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,536 through 32,550 (of 59,099 total)

RE: Hierarchical Dataset using a Self-Referencing Table

Please see the following article...
http://www.sqlservercentral.com/articles/T-SQL/72503/
--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)

September 18, 2011 at 1:35 pm

#1383124
RE: Generate a unique number for a record

{Edit} Post withdrawn... wrong 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)

September 18, 2011 at 1:18 pm

#1383121
RE: Please help me out this question?

pathuripr (9/17/2011)
Question # 11: Create a loop to...
This is just so wrong... What is the name of the school where they are teaching you to do such a thing in...
--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)

September 18, 2011 at 1:05 pm

#1383119
RE: IDENTIFIERS !!!

karthikeyan-444867 (9/14/2011)
Jeff (one of my most valuable sql teacher) ,
Thanks a lot 🙂 I understand the concepts now.
I appreciate you for spending some time for me to give a detailed...
--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)

September 18, 2011 at 12:46 pm

#1383112
RE: Query optimizing 2

Rokh (9/16/2011)
Well I'll be dammed. The first query is faster then the more readable and shorter query...
I've tested it using 19 million records.
In that case, could you post the CREATE...
--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)

September 18, 2011 at 12:38 pm

#1383110
RE: HOW TO ADD THE NULL VALUE TO SELECT

Ah... understood. So, are you all set now?
--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)

September 18, 2011 at 12:08 pm

#1383109
RE: Jeff Moden elected Exceptional DBA of 2011

I sure do appreciate all the great feedback you good folks have given. It's been my pleasure to serve.
--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)

September 18, 2011 at 12:04 pm

#1383107
RE: Query optimizing 2

I still need to know which table ToCity and SalesAmount are in to optimize this to the tune of about a 300%+ performance gain. Are they in the Sales_City...
--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)

September 16, 2011 at 6:05 am

#1382495
RE: HOW TO ADD THE NULL VALUE TO SELECT

Frances L (9/15/2011)
SELECT HREMP_Adp.EMPLNO, HREMP_Adp.LNAME + ', ' + HREMP_Adp.FNAME+ HREMP_Adp.MI AS [Full Name] FROM HREMP_Adp INNER JOIN ...
--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)

September 15, 2011 at 9:00 pm

#1382359
RE: Query optimizing 2

Also, if your table has more cities in it than what you have in the query, add the following WHERE clause just before the GROUP BY...
...
--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)

September 15, 2011 at 8:52 pm

#1382358
RE: Query optimizing 2

Rokh (9/15/2011)
It's not the desired result. Here's the deal:
Using this query:
select
b.Sold_To_Country,
...
--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)

September 15, 2011 at 8:36 pm

#1382357
RE: Can I create a Policy that will enforce a standard?

jason.stamm (9/15/2011)
We have a few databases where we do not want the developers to write queries that cross databases. I was thinking perhaps I could enforce this as 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)

September 15, 2011 at 8:16 pm

#1382355
RE: Insert Into temp table and then copy into 'real' table

l.danks (9/15/2011)
Here's a snippet from the stored procedure as it is now (sorry about the messy format) - if there is anything particularly stupid that I'm missing please let me...
--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)

September 15, 2011 at 7:31 pm

#1382349
RE: Advice on running totals using a cursor

zapouk (9/15/2011)
I think I've covered that one by rebuilding the running totals from the earliest date in the table that will be affected by the new batch of rows. 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)

September 15, 2011 at 4:50 pm

#1382307
RE: Advice on running totals using a cursor

LutzM (9/14/2011)
Jeff Moden (9/13/2011)
Oddly enough, it wouldn't take much more time to do the Quirky Update on a million row table than it would be to go through all 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)

September 15, 2011 at 7:47 am

#1381966

Viewing 15 posts - 32,536 through 32,550 (of 59,099 total)