Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,961 through 30,975 (of 59,101 total)

RE: Dividing a list of filenames into roughly equal batch sizes in KB

Ok... since we had to use a loop for this, I tried to make it as efficient as possible.
First, the really nasty test data I posted in my previous 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)

February 28, 2012 at 7:15 pm

#1452881
RE: Dividing a list of filenames into roughly equal batch sizes in KB

Yowch. I set up a spreadsheet to emulate the Quirky Update and I've had no joy getting something to work in a set based fashion for all scenarios. ...
--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)

February 28, 2012 at 6:10 pm

#1452874
RE: Table Optimization for fast retrival

rvasanth (2/26/2012)
I am not exactly showing it in the screen.
I just selecting and moving to temp table and doing further processing. Sometime, i export it to a textfile.
Ok... that'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)

February 28, 2012 at 1:29 pm

#1452795
RE: Incrementing a table name

Reading costs in the execution plan can be both good and bad. For example, if the old code took 5 minutes to run and the new code takes 5...
--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)

February 28, 2012 at 7:38 am

#1452599
RE: Dividing a list of filenames into roughly equal batch sizes in KB

dembones79 (2/28/2012)
The example given was just that, an example.
No problem. I get that. I just wanted to know if an idle FEL or two would be OK 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)

February 28, 2012 at 7:32 am

#1452595
RE: Need answers for interview questions...

satishm94 (2/28/2012)
Hi guys
can u guys tell me the answers to these question …PLZ
At the risk of being rude, my answer is "No". Part of being a DBA or whatever...
--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)

February 28, 2012 at 7:10 am

#1452576
RE: Incrementing a table name

davidandrews13 (2/28/2012)
([ChangedDate]>='2008-01-01 00:00:00' AND [ChangedDate]<='2008-12-31 23:59:59')
obviously, the year in the CheckConstraint changes depending on which table its against.
Also, your check constraint is incorrect. In theory, it's possible that something...
--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)

February 28, 2012 at 6:53 am

#1452559
RE: Incrementing a table name

davidandrews13 (2/28/2012)
The 7th table contains data from the year 2011 onwards, so currently i dont want to put a constraint on it.
You must include the constraint on the 7th table...
--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)

February 28, 2012 at 6:49 am

#1452558
RE: Guidelines for need to consider for SSRS report development.

Double post. Please post answers at the duplicate at the following URL.
http://www.sqlservercentral.com/Forums/Topic1258594-1633-1.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)

February 27, 2012 at 8:16 pm

#1452357
RE: Dividing a list of filenames into roughly equal batch sizes in KB

I guess my question would be, which is most important? To use all 4 FELs or to balance the load? If you have one file that is much...
--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)

February 27, 2012 at 7:50 pm

#1452353
RE: Incrementing a table name

It depends on what the "partitioning constraint/column" is setup as. If you have your tables setup by month and year, then your scenario would only look at 8 tables....
--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)

February 27, 2012 at 4:21 pm

#1452338
RE: Calendar Tables

codebyo (2/25/2012)
Excellent article! Thank you.
Now I have a question for you more experienced guys and gals. 😀
If I use a tally table like the one below would that be alright?...
--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)

February 27, 2012 at 4:08 pm

#1452337
RE: split data of month into weeks

Eugene Elutin (2/27/2012)
Jeff Moden (2/24/2012)
... Adding a couple of comments as to what each part of the code is doing just might help sway the OP away from loops 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)

February 27, 2012 at 4:05 pm

#1452336
RE: WHERE Date Range

bteraberry (2/26/2012)
Jeff, I'm a bit confused. Are you saying that parameter sniffing is more likely with dynamic sql?
No. Absolutely not. One of the statements made was 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)

February 27, 2012 at 7:05 am

#1452048
RE: @Query Parameter in sp_send_dbmail???

Thanks for posting the answer to what your own fix was. It's sure to help some other folks.
--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)

February 26, 2012 at 10:13 pm

#1451878

Viewing 15 posts - 30,961 through 30,975 (of 59,101 total)