Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,791 through 11,805 (of 59,095 total)

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

sgmunson - Tuesday, July 17, 2018 7:34 AM
Jeff Moden - Monday, July 16, 2018 3:58 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 18, 2018 at 12:11 pm

#1998079
RE: Converting Excel Formula into TSQL

Ronnie Rahman - Wednesday, July 18, 2018 11:39 AM
Phil Parkin - Wednesday, July 18, 2018 11:36 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 18, 2018 at 12:03 pm

#1998074
RE: weird issue? green arrow disappear

Dunno then. I've not had nor have been able to duplicate that problem if running as administrator.
--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 18, 2018 at 12:01 pm

#1998071
RE: Database query performance is very poor

saptek9 - Wednesday, July 18, 2018 1:33 AM
Sue_H - Tuesday, July 17, 2018 6:44 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 18, 2018 at 11:55 am

#1998069
RE: Converting Excel Formula into TSQL

Ronnie Rahman - Wednesday, July 18, 2018 10:40 AM
Lynn Pettis - Wednesday, July 18, 2018 10:34 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 18, 2018 at 11:32 am

#1998057
RE: weird issue? green arrow disappear

bissagars - Wednesday, July 18, 2018 11:15 AM
Jeff Moden - Wednesday, July 18, 2018 11:07 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 18, 2018 at 11:25 am

#1998055
RE: Storage that Expires

Sergiy - Wednesday, July 18, 2018 2:25 AM
Think of those #metoo activists - do the even have a case?According to the new...
--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 18, 2018 at 11:22 am

#1998054
RE: sproc question

Yes there is. Done correctly, there's no chance of SQL Injection, either. Please see the article at the following link, which I consider to be the definitive article on 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)

July 18, 2018 at 11:16 am

#1998052
RE: weird issue? green arrow disappear

bissagars - Wednesday, July 18, 2018 11:04 AM
I have been using SQL Server 2008 SP2 for 2 years and didn't face that,...
--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 18, 2018 at 11:07 am

#1998049
RE: The Age of Multiple Databases

xsevensinzx - Monday, July 16, 2018 8:33 PM
Yeah, it's not that big in comparison to what's out there obviously, but it's many...
--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 18, 2018 at 8:46 am

#1998014
RE: Flat File csv with double quotes

gothaimviii - Wednesday, July 18, 2018 8:01 AM
sestell1 - Wednesday, July 18, 2018 6:55 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 18, 2018 at 8:40 am

#1998013
RE: Loading more than 1 billion records from CSV File

I'm not saying
xsevensinzx - Wednesday, July 18, 2018 5:54 AM
Sounds like there may be some bottlenecks when the data lands such...
--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 18, 2018 at 7:04 am

#1997982
RE: Loading more than 1 billion records from CSV File

See the following article. Even though it's a slightly bastardized version (missing some information and some very helpful graphics, which is another proof that change isn't always for the better)...
--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 17, 2018 at 10:00 pm

#1997938
RE: Storage that Expires

Sounds like a great place to store audit data.
--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 17, 2018 at 9:31 pm

#1997937
RE: Database query performance is very poor

saptek9 - Tuesday, July 17, 2018 5:52 PM
database performance is getting better after restart the server and slowing down after a while...
--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 17, 2018 at 9:23 pm

#1997936

Viewing 15 posts - 11,791 through 11,805 (of 59,095 total)