Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,441 through 19,455 (of 59,072 total)

RE: Slow performance when using Table Type Parameter and passing through c#

brad.mason5 (10/9/2015)
Is there a better way to pass 50,000 INTs over the wire?
Are the numbers are being generated by the app? What I mean by that is it seems...
--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 9, 2015 at 1:15 pm

#1832647
RE: Make a column immutable, once set it sticks

terry999 (10/9/2015)
I hope I remember this checksum computed column for future next time I need something similar.
Careful now. There IS a thing in SQL Server that's actually called 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 9, 2015 at 7:48 am

#1832536
RE: Need best way to move historical data out

krypto69 (9/29/2015)
These tables are barely used and are taking up way too much space and time for maintenance.
Are ANY rows that are older than 2 years EVER updated? Also,...
--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 9, 2015 at 7:32 am

#1832523
RE: Need help putting data into XML format

philcart (10/8/2015)
Jeff, surely you're forgetting the times when you need a XSL file and namespaces declarations :-D:-D
Heh... not forgetting... trying to give it a chance. I figured it was bad...
--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 8, 2015 at 9:57 pm

#1832443
RE: Need help putting data into XML format

I think it fascinating that the end result in the form of XML is 919 characters (without spaces) and that the code to conditionally drop the tables, recreate the 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)

October 8, 2015 at 7:52 pm

#1832432
RE: Best practice of storing many queries to export data?

Eric M Russell (10/8/2015)
Personally, I'd rather not deal with 100 separate SSIS packages, even if they are auto generated by BIML. If you can leverage BIML or .NET to programmatically...
--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 8, 2015 at 9:40 am

#1832339
RE: Create Weeks Calendar from Date in SQL 2012

helal.mobasher 13209 (9/30/2015)
my related question is although number of days in each week is rather consistent (6) if we expand the year from 2014 to 2020, but number of weeks...
--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 8, 2015 at 9:32 am

#1832335
RE: Create Weeks Calendar from Date in SQL 2012

helal.mobasher 13209 (9/30/2015)
I need to create a week calendar from date in SQL 2012. Week date starts with Sunday regardless if first Sunday or last Sunday overlaps with previous or...
--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 8, 2015 at 9:26 am

#1832331
RE: Calculate number of months between dates for multiple records

LeeFAR (10/8/2015)
Thank you John. You have pointed me in a direction that will work. I think kicker was the -1 and I was just not thinking.
Maybe. What...
--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 8, 2015 at 9:13 am

#1832324
RE: MERGE to single Flat FILE with different formats

John Rowan (10/8/2015)
Great solution Jeff. I'd say that would work great as long as the OP has the ability to create tables for their ETL. I've worked on...
--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 8, 2015 at 9:02 am

#1832319
RE: MERGE to single Flat FILE with different formats

I don't use SSIS so please pardon me if it sounds like I'm trivializing the use of SSIS for such things in saying, wouldn't it be easier to do 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)

October 7, 2015 at 10:56 pm

#1832210
RE: Aging Software

xsevensinzx (10/7/2015)
It really just depends. I see a great deal of benefit if I happen to use the bathroom and my toilet detects I could potentially have cancer based on...
--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 7, 2015 at 9:31 pm

#1832205
RE: Issues and performance of importing XML into SQL Server 2008

Sideout1972 (10/7/2015)
With that said, when you need to transmit a complex data file which has multiple nodes that need to go multiple nodes deep, XML is a reasonable format. ...
--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 7, 2015 at 9:28 pm

#1832204
RE: Import CSV. Multiple Rows. Split order when items total 720g

Apologies. I lost track of this one mostly because it's for Integration Services, which I don't use. Did you ever get an answer to this?
--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 7, 2015 at 8:49 pm

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

jeffrey yao (9/24/2015)
jeffrey yao (8/28/2015)
This is a nice article that generates lots of interesting discussions and topics.
But from pure technical perspective, I feel there is one special deficiency I do...
--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 7, 2015 at 8:47 pm

#1832200

Viewing 15 posts - 19,441 through 19,455 (of 59,072 total)