Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,576 through 22,590 (of 59,099 total)

RE: Copy SSRS reports from Dev to Stage to Prod.

As a bit of a sidebar, I read some of the comments that follow that article and some dude said the performance of RS "sucks". When I read 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)

October 28, 2014 at 9:19 am

#1755256
RE: Copy SSRS reports from Dev to Stage to Prod.

Thanks, ol' friend. Great minds think alike. I just found the following example that uses RS and, at first blush, looks fine. Combined with the official link...
--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)

October 28, 2014 at 8:52 am

#1755249
RE: do you have a StripNonNumeric ITVF function?

I took the two contenders from your good post, Alan, and added on of my own. Here's the code for the function I use for such things. Yeah......
--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)

October 28, 2014 at 12:34 am

#1755098
RE: do you have a StripNonNumeric ITVF function?

Out of all of these submittals, which post has the fastest code? I'd check for myself but I'm on the run right now but want to check the "best"...
--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)

October 27, 2014 at 4:17 pm

#1755059
RE: Need help with Index Rebuild and Reorganize job set up.

spaghettidba (10/27/2014)
dinsab11 (10/26/2014)
I even looked Ola Hallengren's scripts but so complicated to make my own.
Please some one post the script here, I would be grateful.
Requirements: (this is on 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)

October 27, 2014 at 8:38 am

#1754954
RE: Dynamically change background color in SSRS reports using custom code

High Marks for you, Stan. Low marks for SSRS, though. I can't believe that there's nothing built in for this very common requirement. It's amazing how 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)

October 27, 2014 at 1:25 am

#1754842
RE: round to two digit after decimel

Lynn Pettis (10/26/2014)
Jeff Moden (10/26/2014)
QQ-485619 (10/26/2014)
what if that is a column name, e.g.
select sum(saletotal)/NumberofDays
select sum(saletotal)/NumberofDays+0.0
Actually: select sum(saletotal)/(NumberofDays+0.0) -- << Remember order of precedence for mathematics.
COFFEE!!! I NEED COFFEE!!! :-D...
--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)

October 26, 2014 at 11:13 pm

#1754833
RE: Rank duplicates, but only rows involved in duplicates

I usually go for a simple million row test but data is getting larger and larger so I thought I'd give everyone the opportunity to play with a table 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)

October 26, 2014 at 10:42 pm

#1754832
RE: Rank duplicates, but only rows involved in duplicates

Eirikur Eiriksson (10/26/2014)
Jeff Moden (10/25/2014)
Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day,...
--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)

October 26, 2014 at 8:16 pm

#1754825
RE: round to two digit after decimel

QQ-485619 (10/26/2014)
what if that is a column name, e.g.
select sum(saletotal)/NumberofDays
select sum(saletotal)/NumberofDays+0.0
--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)

October 26, 2014 at 6:10 pm

#1754824
RE: Need help with Index Rebuild and Reorganize job set up.

dinsab11 (10/26/2014)
Hello,
I tried to find online the script I need but unable to do so. I even looked Ola Hallengren's scripts but so complicated to make my own.
Please some...
--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)

October 26, 2014 at 6:04 pm

#1754823
RE: Rank duplicates, but only rows involved in duplicates

Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good...
--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)

October 25, 2014 at 1:31 pm

#1754783
RE: Temporal SQL Server Databases

Randy AV (10/24/2014)
We did a very deep dive into looking at Prior Art as did the USPTO examiner. A lot of the prior art was ours, based on 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)

October 24, 2014 at 8:44 pm

#1754757
RE: SSIS Help..

rocky_498 (10/24/2014)
Thanks for your help, got it I can use multicast for different file, how about ?
Source:-
Add, New, Pro, Len, Source
Acorn,Null,Null,Null,Null
Null,FC,Null,Null,Null
Null,Null,Day,Null,Null
Null,Null,Null,2:00,Null
Null,Null,Null,Null,Phone
Null,Null,Null,Null,Web
Destination File:-
Add, New, Pro, Len, Source
Acorn,FC,Day,2:00,Phone
Acron,FC,Day,2:00,Web
this format ?
To be honest,...
--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)

October 24, 2014 at 6:29 pm

#1754754
RE: The 10 (.5) Commandments for IT Professionals

I missed this article the first time around and glad it was republished. Absolutey awesome job. I especially like the part about putting the documentation into the code...
--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)

October 24, 2014 at 5:02 pm

#1754748

Viewing 15 posts - 22,576 through 22,590 (of 59,099 total)