Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,591 through 37,605 (of 59,072 total)

RE: Query time out

mithun.gite-1086228 (7/18/2010)
Thanks for the reply,
This is not a actually a SQL job but its just similar to that , at scheduled time bunch of sps will start executing pulling data...
--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)

July 18, 2010 at 12:58 pm

#1194655
RE: Average Inventory (Stock) Age

gah (7/18/2010)
also a sincere thanks to Jeff Modem for his article
It's actually spelled "Moden" but I'll take the compliment. 🙂 Thanks, Graham.
--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)

July 18, 2010 at 12:54 pm

#1194653
RE: Cursors to compare to values

Sagar Sawant (7/17/2010)
Hi,
Why you are using cursors? it's degrade the performance of sql query and also consuming memory..
Use while loop instead of cursor. [font="Arial Black"]You can see the dramatic performance[/font]......
--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)

July 18, 2010 at 12:44 pm

#1194650
RE: BCP Utility

Do the changes you're making make some data wider than the column that it was intended 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)

July 18, 2010 at 12:35 pm

#1194648
RE: Very Tough CSV Data Import to SQL 2005 DB Table Challenge

Does that mean that you're all set?
--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)

July 18, 2010 at 12:11 pm

#1194647
RE: SUBSTRING coding problem

Agreed... trailing spaces could come into play (and I always forget about them). Nicely done.
--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)

July 18, 2010 at 12:05 pm

#1194646
RE: Generating SubTotals using GROUPING

Hugo Kornelis (7/17/2010)
Jeff Moden (7/16/2010)
Nice job, Sunil. I especially liked the fact that you compared what some folks go through with multiple queries (in one form or another) 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)

July 18, 2010 at 11:55 am

#1194645
RE: Checking expiry dates in a table

magasvs (7/17/2010)
That was Friday's madness 🙂
SELECT * FROM YourTable
WHERE convert (datetime,YourColumn) =
DATEADD(month,1,convert (datetime,convert(varchar(10), getdate(), 101), 101))
Heh... madness indeed.
--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)

July 18, 2010 at 11:52 am

#1194644
RE: Between Statment only for current day

jon pill (7/17/2010)
How can I check that I am permitted to create and amend tables?
Just try it manually, I guess.
--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)

July 18, 2010 at 11:49 am

#1194643
RE: Becoming a business intelligence architect

da-zero (7/17/2010)
Jeff Moden (7/16/2010)
da-zero (7/14/2010)
Jeff Moden (7/13/2010)
Have you got a link for all of the requirements, Steve? Thanks.
:blink:
I think I have an URL where you can download experience. If...
--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)

July 18, 2010 at 11:46 am

#1194642
RE: Are the posted questions getting worse?

Roses are Red,
Violets are Blue,
Some poems rhyme,
But this one don't.
😛
--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)

July 18, 2010 at 11:41 am

#1194641
RE: summing up the previous row values up to date level

jprabha.d (7/16/2010)
Hi All,
How Do we Sum up the Values As Per the Date in a Particular Month ,I am Designing the Report wher i have to Drill Down...
--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)

July 16, 2010 at 10:20 pm

#1194468
RE: Insert data into one table column with multiple values of another table column

How are you controlling the number of times the name goes into the table?
The method I showed you works. What's wrong with using 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)

July 16, 2010 at 10:18 pm

#1194467
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

MikeAngelastro-571287 (7/14/2010)
I think that replies should avoid attacking the author of an article. That is not productive at all. The author took the initiative to share an experience....
--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)

July 16, 2010 at 10:04 pm

#1194465
RE: Checking expiry dates in a table

magasvs (7/16/2010)
There ar emany ways to do it. This is just an example for the date in character format
Understood. So why not pick a simple way?
--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)

July 16, 2010 at 10:00 pm

#1194464

Viewing 15 posts - 37,591 through 37,605 (of 59,072 total)