Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,941 through 14,955 (of 59,097 total)

RE: Things to consider while creating new table for an application

You seem to be missing some Primary Keys from some of the tables. While an actual primary key isn't always uber important, clustered indexes usually are. Also, MS like 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)

June 4, 2017 at 1:15 pm

#1945314
RE: Need some help with some "XML Hell" please.

Ok... here's what I've found out about the XML index that Magoo suggested. Regardless of the outcome, his suggestion was a great idea that needed to be tested. Thanks again,...
--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)

June 4, 2017 at 11:37 am

#1945313
RE: How to get date from JSON in correct format?

Thanks for the feedback! 😉
--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)

June 4, 2017 at 10:22 am

#1945308
RE: Need some help with some "XML Hell" please.

I haven't. I'll give that a try. Thank you
mister.magoo - Tuesday, May 30, 2017 6:05 PM
Nice to see you having to 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)

June 4, 2017 at 8:25 am

#1945301
RE: Why Scalar Functions Can Be Costly

Eirikur Eiriksson - Saturday, June 3, 2017 8:59 AM
Jeff Moden - Saturday, June 3, 2017 8:44 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)

June 4, 2017 at 12:06 am

#1945291
Reply To: Why do some DBAs avoid DATETIME2?
Heh... obviously, by the link you posted, you know some of the reasons why I avoid it. Add to that that I have no need for the extended early dates...
- This reply was modified 7 years, 5 months ago by Jeff Moden.
- This reply was modified 2 years, 2 months ago by Jeff Moden. Reason: Cleanup code messed up due to forum "Upgrades"
--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)
June 3, 2017 at 11:48 pm

#1945290
RE: TempBD space issue

Lynn Pettis - Friday, June 2, 2017 2:07 PM
It is possible that tempdb was set to an initial size of 30 GB...
--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)

June 3, 2017 at 9:51 pm

#1945285
RE: How to get date from JSON in correct format?

Can't test it because I'm no where near a 2016 box just now but if all the dates in your JSON are in the DMY format, then just add 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)

June 3, 2017 at 9:37 pm

#1945283
RE: selecting columns and rows from pivot table

It's easy. Just rename (re-alias) the column names and limit the rows with a WHERE clause. Like this.

SELECT year1 = year3
,count1 = count3
--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)

June 3, 2017 at 9:16 pm

#1945282
RE: SQL Server Performance

By the same token, you can have a fire breathing monster of a server on a network with speeds that we could only dream of and still run into performance...
--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)

June 3, 2017 at 10:24 am

#1945254
RE: XML import from a cross-tab Report

Nice article. It would, however, be helpful if you would attach sample data in the "Resources" section so that people can "play" with your good code for additional learning through...
--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)

June 3, 2017 at 9:14 am

#1945252
RE: Calculating values for Primary Key

Just to establish some warm fuzzies that a concurrent update won't ever interfere with the correct calculation (unique sequential number) of the MatCodeID, I would add a WITH (TABLOCKX) to 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)

June 3, 2017 at 9:08 am

#1945251
RE: Why Scalar Functions Can Be Costly

Mickey Stuewe - Sunday, January 3, 2016 11:24 PM
Comments posted to this topic are about the item Why Scalar Functions Can...
--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)

June 3, 2017 at 8:48 am

#1945246
RE: Why Scalar Functions Can Be Costly

Alan.B - Monday, January 4, 2016 11:16 AM
Eirikur Eiriksson (1/4/2016)
Worse still are the multi-statement table-valued functions, in fact there is no excuse...
--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)

June 3, 2017 at 8:44 am

#1945245
RE: Remove non-unicode characters from a column

Jacob Wilkins - Friday, June 2, 2017 12:11 PM
Jason A. Long - Friday, June 2, 2017 11:45...
--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)

June 2, 2017 at 9:58 pm

#1945234

Viewing 15 posts - 14,941 through 14,955 (of 59,097 total)