Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,771 through 19,785 (of 59,098 total)

RE: Best way to optimize view that contains millions of rows

It's not the View that needs to be optimized. It's the queries that call it that need to be optimized.
--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)

August 26, 2015 at 5:59 pm

#1822640
RE: Add Value of same item number

Dee Dee-422077 (8/26/2015)
hi ,
My data look like this:
ITEMID DESC QTY PRICE
134 ...
--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)

August 26, 2015 at 5:46 pm

#1822638
RE: How can I group near duplicate records under a new common field?

Off topic a bit, I'm not sure why anyone in the right mind would store an SSN in a Unicode data type and, unless the fact that it's encrypted had...
--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)

August 26, 2015 at 5:40 pm

#1822637
RE: Slow site

Very slow at 18:46 EDST. Ya just gotta love relying on 3rd parties. This and other problems we've seen over the last 5 years is why we 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)

August 26, 2015 at 4:50 pm

#1822635
RE: Slow site

robert.chipperfield (8/26/2015)
From a monitoring point of view, it looks like things have remained stable since that change. If anyone is still seeing otherwise, please pop something on this thread.
Thanks,
Rob
This was...
--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)

August 26, 2015 at 1:38 pm

#1822615
RE: Command for adding new drives?

Want a cool Sig (8/26/2015)
Any drawbacks to detach, move and reattach DB?
Read the documentation in the link I provided because the answer is "It Depends".
--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)

August 26, 2015 at 1:20 pm

#1822610
RE: The Tally Table

Wayne West (8/26/2015)
Ed Wagner (8/26/2015)
Jeff Moden (8/26/2015)
Wayne West (8/26/2015)
Jeff Moden (8/26/2015)
dwain.c (8/25/2015)
Thank the Buddha for whoever came up with the idea of a Tally table in the first place! ...
--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)

August 26, 2015 at 1:19 pm

#1822609
RE: The Tally Table

Wayne West (8/26/2015)
Jeff Moden (8/26/2015)
dwain.c (8/25/2015)
Thank the Buddha for whoever came up with the idea of a Tally table in the first place! I just love 'em (but probably...
--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)

August 26, 2015 at 11:51 am

#1822575
RE: Command for adding new drives?

Google and Books Online are your friends here. Please see the following.
Google or Books Online is your friend here. Please see the following.
https://msdn.microsoft.com/en-us/library/ms345408(v=sql.100).aspx
--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)

August 26, 2015 at 8:06 am

#1822489
RE: Becoming a consultant

christop (8/26/2015)
Ive noticed a couple of contract jobs on jobsites, 3 / 4 months work at £Xxx per day, so ideally finding a few of these every few months would...
--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)

August 26, 2015 at 7:52 am

#1822478
RE: Slow site

+1000... there has to be a word worse than excruciating over the last couple of days. It's not consistently bad but it's been absolutely killer slow for extended periods...
--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)

August 26, 2015 at 7:31 am

#1822469
RE: udf with tally table runs slower than while loop

You bet. It's one of my favorite charts because of the line for the rCTE. Absolutely amazing how comparatively slow those bad boys can be.
--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)

August 26, 2015 at 7:20 am

#1822459
RE: The Tally Table

dwain.c (8/25/2015)
BTW. Has anybody Googled "Tally Table" recently? Try hitting the I'm Feeling Lucky button.
Don't even need to hit the "Feeling Lucky" button. Your good article 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)

August 26, 2015 at 1:51 am

#1822398
RE: The Tally Table

dwain.c (8/25/2015)
Thank the Buddha for whoever came up with the idea of a Tally table in the first place! I just love 'em (but probably everybody knows that).
In my...
--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)

August 26, 2015 at 1:41 am

#1822394
RE: Email Formatted HTML Table with T-SQL

mister.magoo (8/25/2015)
Jeff Moden (8/25/2015)
greg.bull (4/27/2015)
Just wondering if anyone has worked out how to control foreground AND background colours for cells in a formatted table?
In essence to combine these:
'font/@color' = case...(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)

August 25, 2015 at 5:03 pm

#1822353

Viewing 15 posts - 19,771 through 19,785 (of 59,098 total)