Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,656 through 17,670 (of 59,102 total)

RE: Enormous Transaction Log!

Brandie Tarvin (5/19/2016)
Ken McKelvey (5/18/2016)
tcalloway (5/17/2016)
I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, in a table...
--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 5:25 pm

#1880625
RE: Split Delimited String Across Fixed Number Of Columns

LoosinMaMind (5/20/2016)
I have the following in a table and need to transfer the single delimited string out into 99 Columns.
I'm afraid that the 99 Columns is a fixed template...
--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:40 pm

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

GilaMonster (5/20/2016)
It is possible to eliminate deadlocks in such a way that it degrades overall performance, I'm fixing a system which did just that.
In order to eliminate deadlocks on ImportantTableA,...
--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:26 pm

#1880617
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

Viewing 15 posts - 17,656 through 17,670 (of 59,102 total)