Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,536 through 14,550 (of 59,101 total)

RE: Data flow concept - Thoughts wanted

Seems like it would use a whole lot less resources if you...
1. Bulk insert just the first row as a blob.
2. Split the first row to get...
--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 24, 2017 at 11:47 pm

#1956753
RE: Trying to create function to create folders (and sub folders)

barsuk - Thursday, August 24, 2017 11:07 PM
you can also incorporate creating folders via mkdir:
SET @Path = '\\xxxxxxx\yyyyyy\'
SET @ssql...
--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 24, 2017 at 11:42 pm

#1956752
RE: Curious Case of SUM Function

This "spackle-size" article actually packs one hell of a wallop if you take the time to read it and understand the examples given. People forget about things such as precision, 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)

August 24, 2017 at 8:37 am

#1956643
RE: SQL Server - It's not really a Mailer Service, is it?

My apologies for the delay.
Here's the proc I use to send email from SQL Server without using sp_Send_DBMail. This is my "presentation" version that I give to others 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)

August 24, 2017 at 7:58 am

#1956626
RE: Dynamic pivot and calculating total and ordering the total

Heh... bit of a long day for me. Just getting back from work. Glad you folks sussed it. Nice job, Thom!
--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 23, 2017 at 11:27 pm

#1956545
RE: Interactive sorting by calculated column percentage

lucaskhall - Wednesday, August 23, 2017 11:29 AM
I am trying to add an interactive sort to a table using an expression 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)

August 23, 2017 at 4:51 pm

#1956515
RE: Potential presentation idea: What a cookbook can teach us about programming

Kevin3NF - Wednesday, August 23, 2017 11:33 AM
I can burn water....
Heh... funny that you should mention that. The monopropellant fuel that 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 23, 2017 at 4:46 pm

#1956514
RE: SQL Server - It's not really a Mailer Service, is it?

My humble opinion is that, as with all else, "It Depends".
I agree that SQL Server is an expensive product and it's a shame to turn it into an...
--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 23, 2017 at 4:31 pm

#1956513
RE: Data flow concept - Thoughts wanted

Tom_Hogan - Wednesday, August 23, 2017 1:59 PM
Orlando Colamatteo - Wednesday, August 23, 2017 1:12 PM
--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 23, 2017 at 4:13 pm

#1956509
RE: Data flow concept - Thoughts wanted

Tom_Hogan - Wednesday, August 23, 2017 7:11 AM
In the meantime, we have an intern manually loading the text files to staging...
--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 23, 2017 at 3:52 pm

#1956507
RE: Send and save a copy of an email (as .msg)

Thom A - Wednesday, August 23, 2017 1:37 AM
Jeff Moden - Tuesday, August 22, 2017 7:44 PM
--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 23, 2017 at 8:39 am

#1956401
RE: Dynamic pivot and calculating total and ordering the total

I'm thinking that this is actually a pretty easy thing to do using a CROSS TAB with ROLLUP and a bit of SQL prestidigitation with pre-aggregation, the summing of times,...
--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 23, 2017 at 8:34 am

#1956397
RE: Best Approach For Junction Table Mainrenace

vincentshanecurtis - Tuesday, August 22, 2017 10:35 PM
Thanks for the reply. You actually hit on another question I had yet to research,...
--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 22, 2017 at 11:03 pm

#1956291
RE: SQL Update with Subquery

Seems like this is becoming more and more common and I don't get it. Why do people ask a question and then never come back when people ask for clarification?
--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 22, 2017 at 10:25 pm

#1956284
RE: Function quick...where clause not :(

Vets5 - Tuesday, August 15, 2017 2:00 AM
Hi,
I have a function which returns a table really quickly but when I add 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)

August 22, 2017 at 10:22 pm

#1956283

Viewing 15 posts - 14,536 through 14,550 (of 59,101 total)