Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

skcadavre (6/8/2010)
Anyone understand what is being asked here? I've spent as long as I want to trying to figure out what he actually wants. We now have sample 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)

June 8, 2010 at 6:24 pm

#1177747
RE: Selecting the earliest month wrapping January to December

Unless I'm missing something, this problem is impossible to solve because there's simply nothing to guarantee the order of the data. There has to be a date entered column...
--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:19 pm

#1177746
RE: Obtain the date of datetime field

Oleg Netchaev (6/7/2010)
There is no way I can possible dislike when my post is commented by you Jeff. When I wrote that I liked that you picked on my post,...
--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:07 pm

#1177744
RE: Obtain the date of datetime field

Mike Mullen (6/8/2010)
Jeff: Thanks for the test harness and profiler results. Just out of curiosity, I tested a CONVERT/DATEDIFF variation in your test harness and it appears to be 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)

June 8, 2010 at 6:02 pm

#1177741

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