Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,931 through 18,945 (of 59,098 total)

RE: How to do IN statement as a parameter

Interestingly enough, I think that anyone passing 100K parameters to a stored procedure is 1) doing something wrong or 2) doing something really wrong. 😀 There are lot'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)

December 20, 2015 at 3:01 pm

#1847007
RE: Why is trivial plan creating statistics

Adi Cohn-120898 (12/20/2015)
I think that it is a trivial plan. If I understand correctly (and I admit that that I might not understand it correctly:-D), a trivial plan is...
--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)

December 20, 2015 at 2:43 pm

#1847005
RE: how to dispaly subtotals

Absolutely agreed on all points except for #2 (heh... you had to know :-D).
On point #1, I absolutely agree that because the OP wants both the raw data and 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)

December 20, 2015 at 1:45 pm

#1847002
RE: How to do IN statement as a parameter

Ah... never mind, Eirikur. I found Phil's old article. My memory was correct. [font="Arial Black"]IF [/font]you pass the parameters as well formed XML as Phil discovered, you...
--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)

December 20, 2015 at 12:16 pm

#1846998
RE: How to do IN statement as a parameter

Eirikur Eiriksson (12/20/2015)
Jeff Moden (12/20/2015)
Eirikur Eiriksson (12/20/2015)
Piling on, while the string splitting method works fine when working with small number of values the performance degrades very quickly when the number...
--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)

December 20, 2015 at 11:53 am

#1846996
RE: how to dispaly subtotals

J Livingston SQL (12/19/2015)
seems you asked a very similar question here
http://www.sqlservercentral.com/Forums/Topic1515448-392-1.aspx
Ah crud. I wish I had read that and visited that post before spending time explaining on this 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)

December 20, 2015 at 11:48 am

#1846994
RE: how to display totals grand total in t-sql

kiril.lazarov.77 (11/20/2013)
Jeff Moden (11/19/2013)
clayman (11/19/2013)
dastagiri16 (11/19/2013)
hi,
i need the text like "TOTAL" ...rollup wont give it...
Please advice
Use SSRS
BWAAAA-HAAAA!!!! Sure it's easy to get to the moon. All you...
--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)

December 20, 2015 at 11:38 am

#1846993
RE: how to dispaly subtotals

As a bit of a sidebar, Jason's good code requires two full scans of the underlying table... one for the Detail rows and 1 for the Sub-Total rows. 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)

December 20, 2015 at 11:23 am

#1846992
RE: how to dispaly subtotals

Ok, first, the following is how you should post data for your requests. Yes, I'll admit that your example is quite easy but people (like me) don't like to...
--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)

December 20, 2015 at 11:07 am

#1846991
RE: how to dispaly subtotals

Jason A. Long (12/20/2015)
Just because you CAN do something in SQL doesn't mean you SHOULD do it in SQL.
Heh... yeah... so where would you do it? SSRS? Front...
--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)

December 20, 2015 at 8:53 am

#1846985
RE: how to dispaly subtotals

dastagiri16 (12/19/2015)
In my first post I have given sample data..
But not as readily consumable data. In order to demonstrate the answer using code, we'd have to create a 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)

December 20, 2015 at 8:50 am

#1846984
RE: time series from particular day in month 1 to particular day in month 2

I guess I'd have to have a clarification meeting with the customer. I just can't imagine why anyone would want to add a day offset to each month. ...
--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)

December 20, 2015 at 8:47 am

#1846983
RE: Why is trivial plan creating statistics

I'm not an expert by any means but, IIRC, it's not actually a "Trivial" query. It has a WHERE clause and the optimizer will typically build stats if they...
--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)

December 20, 2015 at 8:41 am

#1846981
RE: No reaction on dbcc emptyfile

Any time a file is "shrunk" it does so at the expense of extreme fragmentation because of a lousy "non-Norton" method of doing the shrink that they never let Paul...
--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)

December 20, 2015 at 8:36 am

#1846980
RE: How to do IN statement as a parameter

xsevensinzx (12/20/2015)
But, it should at least be noted there will be a performance decrease with any UDF, data conversions, etc. But splitter-to-splitter, the DelimitedSplit8K surely seems like the way to...
--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)

December 20, 2015 at 8:22 am

#1846979

Viewing 15 posts - 18,931 through 18,945 (of 59,098 total)