Jeff Moden

Forum Replies Created

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

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
RE: Who Likes NULL?

Heh... always fun to watch discussions concerning NULL. 😀
--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 1:57 pm

#1997549
RE: Table design considerations help

vsamantha35 - Thursday, July 12, 2018 4:33 AM
Hi All,
This is a general question regarding database design. I am not a db...
--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 1:53 pm

#1997548
RE: Are the posted questions getting worse?

JaybeeSQL - Thursday, July 12, 2018 8:14 AM
I have met NOBODY in the last 2 years who was a Brexit voter,...
--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 12, 2018 at 8:52 am

#1997312
RE: The SQL Joke Thread

below86 - Wednesday, July 11, 2018 2:59 PM
sgmunson - Wednesday, July 11, 2018 1:54 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 11, 2018 at 4:08 pm

#1997236

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