Jeff Moden

Forum Replies Created

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

RE: UPDATE Duplicates Except for One Record in a Table

Sergiy - Thursday, June 1, 2017 11:22 PM
donato1026 - Tuesday, May 30, 2017 1:11 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)

June 4, 2017 at 9:29 pm

#1945327
RE: Help with query

Now that there are multiple solutions for this problem, I have to ask, if the "current" start date will be replaced with the previous end date, why is there any...
--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 9:22 pm

#1945326
RE: Devide ' n' Conquer techniques in t-sql query writing

By the same token, a lot of people think that "set-based" means "all in one query". While set-based code frequently does result in a single query, it's not always 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 4, 2017 at 8:49 pm

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

Jackson89 - Sunday, June 4, 2017 4:21 PM
Jeff Moden - Sunday, June 4, 2017 1:15 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)

June 4, 2017 at 7:03 pm

#1945323
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, 7 months ago by Jeff Moden.
- This reply was modified 2 years, 3 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

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