Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,056 through 38,070 (of 59,102 total)

RE: High Transactions per second

TheSQLGuru (6/9/2010)
BTW, are you at TechEd this week?
No... I've got one of those major project thingies going on at work.
--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)

June 9, 2010 at 8:21 pm

#1178392
RE: SQL Server Ranking Functions

I'm a little late on the feedback after the formatting fix and I apologize for that. VERY nicely done, Wayne. This will help a lot of folks just...
--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)

June 9, 2010 at 8:12 pm

#1178390
RE: Changing dates to Integers

Patrick Seegers (6/9/2010)
[font="Courier New"]Are there any opposing views on this usage?
Thank you
[/font]
Sure... read the rest of the posts on this thread.
Hmmmm.... "unknown date".... sounds 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)

June 9, 2010 at 5:40 pm

#1178375
RE: Why this Convert has a small quirk?

Hi Roy,
Heh... I had to laugh a bit because I'm right there with you. Seems the phrase "legacy code" usually means "problem code"... even if it was us 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)

June 9, 2010 at 6:49 am

#1177942
RE: ProperCase again

Paul_Harvey (6/9/2010)
Hi Lowell,
Thanks for your reply. Yes, my columns are collated as Latin1_General_CI_AS.
Do you think that is the reason? Pity, because it looked like a useful function 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)

June 9, 2010 at 5:35 am

#1177916
RE: Please help me with the Performance and Locking Issues....

Just to emphasise what Gail has stated, I've actually seen duplicated data appear thanks to WITH(NOLOCK). I recommend NOT using it most of the time. The proper way...
--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)

June 9, 2010 at 5:29 am

#1177915
RE: Help with bulk random code insert

Ok... you can't spell most swear words without vowels and I really don't want someone to get sued because they didn't filter correctly. Here's an 8 character generator 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)

June 8, 2010 at 8:31 pm

#1177769
RE: Collapsing a Table

paul_ramster (6/7/2010)
Thanks Jeff, I'll fix that in the production code too!
darn flies!
Ah... my apologies for being the messenger. There's more than one fly... here are the results...
--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)

June 8, 2010 at 7:55 pm

#1177764
RE: Duplicate Record

Yes... I've not been able to force a dupe on a real PK constraint so that's probably not it.
Have you determined that there are actually dupes? If...
--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)

June 8, 2010 at 7:40 pm

#1177763
RE: High Transactions per second

Sandy2704 (6/8/2010)
On further investigating the High transacttions/sec i noticed it is due to high number of SQL Compilations/sec......It seems some of the statements don't have the Actual Plan and so...
--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)

June 8, 2010 at 7:06 pm

#1177761
RE: SQL updates on table with over 7 million rows throws out of memory exception

ek-822869 (6/8/2010)
You are right. the only issue is it updates the empty rows (with blank spaces )with 00 and i have to write another statement to update them to blank....
--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)

June 8, 2010 at 6:55 pm

#1177758
RE: A Design Question - To Use an Identity column or not

Steve Jones - Editor (6/8/2010)
think widely. I have had cases where we do store data in a table that is relevent to that entity, but is rarely queried. Keeping 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)

June 8, 2010 at 6:53 pm

#1177756
RE: Are the posted questions getting worse?

Gianluca Sartori (6/4/2010)
rjohal-500813 (6/4/2010)
Likewise Oracle people probably have similar feelings to MSSQL if they have to move to it.
Maybe. What I heard of MSSQL from Oracle DBAs 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)

June 8, 2010 at 6:33 pm

#1177754
RE: Are the posted questions getting worse?

jcrawf02 (6/8/2010)
Gianluca Sartori (6/8/2010)
Can anyone take a look at this one?
I'm sure my solution sucks and I'm pretty sure the OP is lost and clueless.
Well after that ringing endorsement, let...
--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)

June 8, 2010 at 6:31 pm

#1177752
RE: Splitting One Row Data into Two Rows

Gopi Muluka (6/4/2010)
Another assumption .. 🙂
I think he need this
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_PADDING ON
GO
DECLARE@Sample TABLE
(
Code VARCHAR(20) NOT NULL
)
INSERT INTO @Sample
SELECT '22G' UNION
SELECT '10A' UNION
SELECT '45B'
SELECT LEFT(Code,PATINDEX('%[a-z]%',Code)-1)...
--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)

June 8, 2010 at 6:29 pm

#1177750

Viewing 15 posts - 38,056 through 38,070 (of 59,102 total)