Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,871 through 48,885 (of 59,099 total)

RE: Importing / Parsing text file with different formatted rows?

It would be helpful if you posted the CREATE statements for the tables you're trying to target... 😉
--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)

August 10, 2008 at 10:46 am

#855771
RE: Get Record Count for each table in a database.

Aye... that's more like it.
The only thing I'd be worried about is... do you need to update usage (DBCC UPDATEUSAGE) as you do in SQL Server 2000 to get accurate...
--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)

August 10, 2008 at 10:32 am

#855769
RE: joining the tables

Not sure a recursive CTE is needed for this simple update problem... it appears that the prototype ID is simply being updated for each occurance in the temp table...
Sainath,
Thank you...
--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)

August 10, 2008 at 10:25 am

#855766
RE: Get duplicate range - How to

Howdy,
Since you're brand new, please take the time to read and follow the suggestions in the link in my signature... it'll help you get very high quality help much faster....
--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)

August 10, 2008 at 10:09 am

#855762
RE: Get Record Count for each table in a database.

toniupstny (8/10/2008)
An alternative without cursor is:
sp_msforeachtable 'select ''?'', count(*) Rows from ?'
Toni
Ummm.... not quite correct, Toni. If you go and look at the code for sp_MSForEachTable, you'll find 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)

August 10, 2008 at 9:37 am

#855759
RE: My 3rd party softwares uses tons of cursors.

CAS - Crappy Application Syndrome - I like it a lot, Paul!
Here's what I would do...
... NOTHING...
At least nothing overt for the time being. You've already informed management...
--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)

August 10, 2008 at 9:25 am

#855758
RE: Find distinct special characters in column

ps. If your yourdistinctlistofcharacters is supposed to contain a single quote, you'll need to include it twice. If yourdistinctlistofcharacters is supposed to contain brackets, then you'll need 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)

August 10, 2008 at 9:07 am

#855756
RE: Find distinct special characters in column

shamshad.ali (8/9/2008)
The problem is I have to "Find DISTINCT SPECIAL characters in column [NTLogin]"
Shamshad Ali.
With a minor modification, Peso's solution will do it...
SELECT * FROM Users
WHERE UserName LIKE '%[yourdistinctlistofcharacters]%'
Change the...
--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)

August 10, 2008 at 9:05 am

#855754
RE: SQL Brain

CREATE TABLE #MyHead....
--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)

August 9, 2008 at 7:15 pm

#855720
RE: hello our Experts where are you????????????

Heh... that's the most blatant "bump" I've ever seen. 😛
Seem like you have a couple of good answers there. I'd continue your post there if I were you.;)
--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)

August 9, 2008 at 7:05 pm

#855718
RE: Beginner Question about CLR

GilaMonster (8/9/2008)
Jeff, do you know if anyone's tested the speed of a CLR proc vs the built in XQuery for shredding xml documents?
No, I sure don't, Gail. Sorry.
--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)

August 9, 2008 at 5:21 pm

#855716
RE: @@IDENTITYin very busy site - if many insert in same time What happend?

Peter, are you, by any chance, going to PASS this year? Sure would like to me you in person, someday.
--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)

August 9, 2008 at 5:19 pm

#855715
RE: Beginner Question about CLR

Just a bit of advice to a beginner... Most of the time where someone thinks they need a CLR, Matt and I have been able to beat the pants off...
--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)

August 9, 2008 at 11:26 am

#855700
RE: Recursive Queries in SQL:1999 and SQL Server 2005

Thanks Paul.
--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)

August 9, 2008 at 10:54 am

#855697
RE: @@IDENTITYin very busy site - if many insert in same time What happend?

Heh... even SCOPE_IDENTITY() doesn't fix that problem. 🙂
--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)

August 9, 2008 at 10:48 am

#855695

Viewing 15 posts - 48,871 through 48,885 (of 59,099 total)