Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,626 through 17,640 (of 59,069 total)

RE: Can eliminating blocking / deadlocking ever be BAD for performance?

Alan.B (5/19/2016)
Throughout my career as a DBA, SQL Developer and BI Developer I think I've received almost as much bad advice as good advice; actually I'd say it's been like...
--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)

May 20, 2016 at 4:23 pm

#1880616
RE: How to get output from a select to a file ?

ben.brugman (5/19/2016)
And allthough I have NO say in the configuration of xp_cmdshell, I do agree not allowing xp_cmdshell makes security tighter.
Not allowing it does two things...
1. It disallows 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)

May 20, 2016 at 9:29 am

#1880528
RE: split data into two columns

PJ_SQL (5/18/2016)
Thanks for the prompt reply.
Actually my data is as below in one column:
SLVER CREEK DR
3RD ST
OAK GATE LN
ABCSDGFDG LN
WnhhkjT ST
I need to split the above data into two columns
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)

May 19, 2016 at 11:23 pm

#1880425
RE: Can we reduce the spam?

Lynn Pettis (5/19/2016)
Steve Jones - SSC Editor (5/19/2016)
drew.allen (5/19/2016)
Would it be possible to limit posts based on the number of visits? I noticed that most of the spam comes...
--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)

May 19, 2016 at 11:09 pm

#1880424
RE: Can we reduce the spam?

TheRedneckDBA (5/19/2016)
What about charging a one-time small fee to be a user of SQLServerCentral.com? Something like $2? (Or whatever the minimum charge would have to be to break...
--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)

May 19, 2016 at 11:05 pm

#1880423
RE: Can we reduce the spam?

Steve Jones - SSC Editor (11/23/2015)
This works well, and we continually feed through posts and patterns.
Actually, it doesn't. I've been hiding a lot of the obvious SPAM/reported spam whenever...
--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)

May 19, 2016 at 11:02 pm

#1880422
RE: Bad Scalar Functions (or other UDF)

Steve Jones - SSC Editor (5/19/2016)
I need someone that wants to document and describe an issue.
I've recently fixed a monster that was necessarily (used in a Persisted Computed Column) 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)

May 19, 2016 at 9:12 pm

#1880417
RE: Time card Hours calculation

There is no way that I'd auto-correct anything having to do with payroll. There's something wrong with a payroll system that allows "double punching" and there's something wrong 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)

May 19, 2016 at 8:56 pm

#1880415
RE: How do I enforce a begin date is before an end date?

I guess that I'd never make the assumption that the user made a reversal of the dates even by accident. What if they phat phingered something and they don'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)

May 19, 2016 at 8:34 pm

#1880414
RE: Can eliminating blocking / deadlocking ever be BAD for performance?

simon.friling (5/19/2016)
Look, a lot of people say a lot of things.
As the person who said this particular thing, I thought I might elaborate on my thought process a bit:
Lets...
--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)

May 19, 2016 at 8:09 pm

#1880410
RE: Preview your Article/Script

Steve Jones - SSC Editor (5/17/2016)
Send me something you're trying to paste in email. I'll see what happens for me.
Done. You have mail titled "Article Contribution Woes".
It'll work 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)

May 18, 2016 at 8:21 pm

#1880075
RE: Can't restore a DB

monterorf (5/18/2016)
I really appreciate your answer, i decided to rollback the restore and keep the old backup i was working with, but i'll try to restore again tonight...
--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)

May 18, 2016 at 8:10 pm

#1880072
RE: Executing Exe in C# using SSIS Execute Process Task

adhikari707 (5/18/2016)
I have a exe that i am calling from SSIS execute Process Task.
Inside exe there is logic that i want to control by passing 2 parameters "DaysFrom" and "DaysTo".
Curious......
--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)

May 18, 2016 at 6:38 pm

#1880069
RE: take some data from excel through sql

sestell1 (5/18/2016)
Darn, it looks like that uses the MS Office API to connect to the workbook and do the conversion. I was hoping for a command-line utility that does...
--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)

May 18, 2016 at 5:26 pm

#1880064
RE: Are the posted questions getting worse?

Lynn Pettis (5/18/2016)
Tell me, is this (third post) just fixing the symptom, not the problem?
Yes... fixing the problem. And, yes, not grasping the symptom.
A table being 100% replaced like...
--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)

May 18, 2016 at 5:21 pm

#1880063

Viewing 15 posts - 17,626 through 17,640 (of 59,069 total)