Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,866 through 11,880 (of 59,099 total)

RE: how do i find a specific status, and only that status

Lynn Pettis - Tuesday, July 10, 2018 12:40 PM
So am I wrong to provide other alternatives? Is so I will just go...
--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)

July 14, 2018 at 10:30 am

#1997594
RE: how do i find a specific status, and only that status

Lynn Pettis - Tuesday, July 10, 2018 9:36 AM
John Mitchell-245523 - Tuesday, July 10, 2018 9:26...
--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)

July 14, 2018 at 10:21 am

#1997593
RE: how do i find a specific status, and only that status

saravanatn - Saturday, July 14, 2018 12:57 AM
Jeff Moden - Friday, July 13, 2018 9:37 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)

July 14, 2018 at 9:22 am

#1997592
RE: Importing XML Files into a flat table

Luke L - Saturday, July 14, 2018 8:17 AM
Jeff Moden - Saturday, July 14, 2018 7:16 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)

July 14, 2018 at 9:13 am

#1997591
RE: Need Help to convert DATETIME result into DATE on SQL Server

Eirikur Eiriksson - Saturday, July 14, 2018 1:30 AM
Just a quick note, DATE data type is stored as 3 byte little-endian, which...
--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)

July 14, 2018 at 7:23 am

#1997589
RE: Importing XML Files into a flat table

Jeff Moden - Friday, July 13, 2018 8:55 PM
Luke L - Friday, July 13, 2018 12:08 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)

July 14, 2018 at 7:16 am

#1997588
RE: TSQL queries for handling Merge statements

vsamantha35 - Friday, July 13, 2018 9:41 PM
Even I heard some issues with MERGE when dealing with large sets of data w.r.t...
--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)

July 13, 2018 at 10:20 pm

#1997582
RE: Need Help to convert DATETIME result into DATE on SQL Server

Nexana - Monday, July 9, 2018 8:37 PM
How can I convert the result into a DATE datatype as '0001-01-01' isn't supported with...
--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)

July 13, 2018 at 10:00 pm

#1997581
RE: Need Help to convert DATETIME result into DATE on SQL Server

sgmunson - Tuesday, July 10, 2018 6:17 AM
SQL Server simply will NOT work with any date value prior to January 1st,...
--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)

July 13, 2018 at 9:45 pm

#1997580
RE: how do i find a specific status, and only that status

saravanatn - Tuesday, July 10, 2018 9:18 AM
jeffshelix - Tuesday, July 10, 2018 8:52 AM
We...
--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)

July 13, 2018 at 9:37 pm

#1997578
RE: Generating Completely Random Sample Output from a Dataset

Chuck Bevitt - Thursday, July 12, 2018 12:03 PM
Interesting, because I had thought that any function that took no parameters or 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)

July 13, 2018 at 9:26 pm

#1997577
RE: TSQL queries for handling Merge statements

With all the problems functional and performance they previously had with MERGE, I'm still skeptical about MERGE and I wouldn't use MERGE if it where the last bit of T-SQL left 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)

July 13, 2018 at 9:00 pm

#1997576
RE: Importing XML Files into a flat table

Luke L - Friday, July 13, 2018 12:08 PM
It's next on my list as a POC, but since the XML Datatype is...
--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)

July 13, 2018 at 8:55 pm

#1997575
RE: Who Likes NULL?

Matt Miller (4) - Friday, July 13, 2018 2:27 PM
Jeff Moden - Friday, July 13, 2018 1:57...
--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)

July 13, 2018 at 6:27 pm

#1997573
RE: DBCC FREEPROCCACHE

Steve Jones - SSC Editor - Friday, July 13, 2018 3:24 PM
Looking for a basic article on how to use this, especially...
--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)

July 13, 2018 at 6:26 pm

#1997572

Viewing 15 posts - 11,866 through 11,880 (of 59,099 total)