Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,176 through 14,190 (of 59,101 total)

RE: Are the posted questions getting worse?

p.s. Kick the slats off that DBA. (S)he should bloody well know better not to develop in production and that code should be thoroughly tested prior to deployment to production.
--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)

October 5, 2017 at 2:30 pm

#1962561
RE: Are the posted questions getting worse?

Phil Parkin - Thursday, October 5, 2017 8:00 AM
ZZartin - Thursday, October 5, 2017 7:51 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)

October 5, 2017 at 2:28 pm

#1962559
RE: Comparing 2 functions for any differences in the result set.

BTW... please post the 2 functions. I'm always interested in reporting functions and have some old "Black Arts" tricks that might provide additional performance benefits.
--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)

October 5, 2017 at 2:23 pm

#1962558
RE: XP_cmdshell DIR

Jeff Moden - Thursday, April 23, 2015 4:12 PM
SQL-DBA-01 (4/23/2015)
Can you please suggest all the files from one location to another using...
--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)

October 5, 2017 at 2:17 pm

#1962556
RE: Comparing 2 functions for any differences in the result set.

My take on it is that "It Depends". If it was an optimization made by the DBAs, then the DBAs are responsible for proving identical functionality and results. As 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)

October 5, 2017 at 10:26 am

#1962515
RE: Since looping is bad, how should I accomplish what I am trying to do?

TheCTEGuy - Thursday, October 5, 2017 4:33 AM
Here is a better solution i guess

create function dbo.split(@str varchar(100),@delimeter varchar(1)) returns...
--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)

October 5, 2017 at 8:41 am

#1962493
RE: Why SQL Server is Better Than Oracle

kannan_egd - Thursday, October 5, 2017 3:27 AM
Jeff Moden - Wednesday, October 4, 2017 11:24 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)

October 5, 2017 at 8:31 am

#1962489
RE: Since looping is bad, how should I accomplish what I am trying to do?

sgmunson - Wednesday, October 4, 2017 10:46 AM
Excellent demonstration of the FACTS, Jeff !!! It's a shame more people don't have some...
--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)

October 4, 2017 at 7:21 pm

#1962381
RE: Why SQL Server is Better Than Oracle

Eric M Russell - Wednesday, October 4, 2017 9:07 AM
ZZartin - Wednesday, October 4, 2017 8:23 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)

October 4, 2017 at 11:24 am

#1962315
RE: Since looping is bad, how should I accomplish what I am trying to do?

FLOAT is actually VERY powerful if you understand how it works, that you must never do implicit formatting during calculations, that precision is fixed (meaning the scale is subject to...
--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)

October 4, 2017 at 8:47 am

#1962278
RE: Why SQL Server is Better Than Oracle

kannan_egd - Wednesday, October 4, 2017 4:08 AM
Thom A - Wednesday, October 4, 2017 3:53 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)

October 4, 2017 at 8:05 am

#1962258
RE: Since looping is bad, how should I accomplish what I am trying to do?

rmcfaden - Tuesday, October 3, 2017 11:04 AM
Jeff Moden - Tuesday, October 3, 2017 10:41 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)

October 3, 2017 at 3:49 pm

#1962182
RE: Need to Change Compatibility Level of Lots of Databases

I've still not run into a problem with NOT setting the single user mode. Be VERY aware that will kill ALL connections but the current one and, if something goes...
--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)

October 3, 2017 at 3:38 pm

#1962181
RE: Why SQL Server is Better Than Oracle

Heh... such fond memories. I don't know how well it works now but we used to have a running joke about TOAD for Oracle... it was appropriately named because it...
--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)

October 3, 2017 at 3:33 pm

#1962180
RE: Since looping is bad, how should I accomplish what I am trying to do?

rmcfaden - Tuesday, October 3, 2017 8:22 AM

SELECT
t.Job_Prod
,t.Job_No
,TrDate = DATEADD(DAY, sc.ItemNumber -1, t.Act_Start)...
--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)

October 3, 2017 at 10:41 am

#1962106

Viewing 15 posts - 14,176 through 14,190 (of 59,101 total)