Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,101 through 14,115 (of 59,095 total)

RE: import .BCP files into sql server

Can you post a link as to where you got the files so we might do some experiments to help you, please?
--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 13, 2017 at 8:30 pm

#1963667
RE: Timing is Everything

Good article, Phil. I also wish that people would learn that "Set Based" <> "All In One Query".
--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 13, 2017 at 8:23 pm

#1963666
RE: Timing is Everything

Steve Jones - SSC Editor - Friday, October 13, 2017 5:15 PM
Nice one.
Just make sure when you're doing timings, use that million...
--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 13, 2017 at 8:22 pm

#1963665
RE: calculation

adisql - Friday, October 13, 2017 5:26 PM
Hi,
TOTAL datatype is (numeric(10,0),null)
STR datatype is (numeric(20,15),null)
REPLACE(FORMAT(CAST(ROUND((
CASE
WHEN SUM(CASE WHEN a.TOTAL IS NOT...
--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 13, 2017 at 8:16 pm

#1963664
RE: SQL CPU maxing out - need some guidance

By any chance, did you use Entity Framework (EF) to create the GUIs? This sounds precisely like something we went through recently. It turned out to the connection strings for...
--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 13, 2017 at 8:09 pm

#1963663
RE: Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly?

You're still joining the inline Tally functionality with the blob and, no matter how you swing it, that's still going to be a performance problem. A "nibbler" While Loop will...
--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 13, 2017 at 5:17 pm

#1963659
RE: TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO

mrpellepelle - Thursday, October 12, 2017 8:16 AM
Hi guys,
i wonder why executing a TRUNCATE and INSERT INTO Command is mutch slower than ...
--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 13, 2017 at 12:26 pm

#1963629
RE: Scalar function syntax error

saintor1 - Friday, October 13, 2017 6:10 AM
Ok *success*, I think that I figured out the use of table UDF...
SELECT ...
--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 13, 2017 at 9:45 am

#1963598
RE: Can't zero pad a variable

Thanks, Phil. Good to see mostly consistency between disparate machines on these.
--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 13, 2017 at 9:43 am

#1963597
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, October 12, 2017 11:24 AM
Things need tuning for sure, though this is a third party...
--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 13, 2017 at 9:30 am

#1963592
RE: Scalar function syntax error

Luis Cazares - Thursday, October 12, 2017 9:15 AM
saintor1 - Thursday, October 12, 2017 9:01 AM
--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 12, 2017 at 11:53 pm

#1963493
RE: Can't zero pad a variable

Phil Parkin - Thursday, October 12, 2017 9:04 AM
Jeff Moden - Thursday, October 12, 2017 8:54 AM
--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 12, 2017 at 11:41 pm

#1963491
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

quinn.jay - Thursday, October 12, 2017 8:19 AM
Jeff Moden - Wednesday, October 11, 2017 2:35 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)

October 12, 2017 at 10:59 am

#1963438
RE: Can't zero pad a variable

Phil Parkin - Thursday, October 12, 2017 6:01 AM
Jeff Moden - Wednesday, October 11, 2017 8:10...
--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 12, 2017 at 8:54 am

#1963388
RE: What Pizzas do DBA's prefer?

Ed Wagner - Wednesday, October 11, 2017 8:04 PM
There are so many good types of pizza out there that it's hard 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)

October 11, 2017 at 11:43 pm

#1963312

Viewing 15 posts - 14,101 through 14,115 (of 59,095 total)