Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,006 through 43,020 (of 59,098 total)

RE: Is This The Best Way to Remove Duplicate Records ?

I tried your code with the test data you previously posted. All seems well with the code. DECLARE @Table TABLE (id3 int, resume varchar(256), email1 varchar(256))
INSERT INTO...
--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)

July 16, 2009 at 7:18 am

#1025612
RE: Is This The Best Way to Remove Duplicate Records ?

ifila (7/16/2009)
To be more specific, the records with the same email, since the whole record is not an exact duplicate. Each record key is still unique.
I am trying to generate...
--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)

July 16, 2009 at 7:12 am

#1025605
RE: Date functions causing queries to take longer

Heh... I have that very same problem when the caffeine levels are low.
--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)

July 16, 2009 at 7:02 am

#1025592
RE: Date functions causing queries to take longer

Grant Fritchey (7/16/2009)
Jeff Moden (7/15/2009)
Grant Fritchey (7/15/2009)
J.D. Gonzalez (7/15/2009)
Execution plans attached.
I'm sorry, but can you zip those up & reattach them. I'm having a hard time getting them to open...
--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)

July 16, 2009 at 6:53 am

#1025585
RE: How to reseed identities in all tables

ahmad.ghazi (7/16/2009)
ok Jeff what i have is a peer to peer transactional replication on sql server 2005
and i need to adjust identity ranges for this because i have set 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)

July 16, 2009 at 6:44 am

#1025579
RE: Help us tune a query

Hey Mel,
I don't know if anyone else is having the same problem but all I can see of Avatar's today is a little red x. And, yeah, I'm using...
--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)

July 16, 2009 at 6:31 am

#1025569
RE: Help us tune a query

RBarryYoung (7/16/2009)
Jeff Moden (7/15/2009)
...
Survey says, do the calc once a day and store it in a table (which I think is being done now, anyway). Use a synonym 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)

July 16, 2009 at 6:30 am

#1025566
RE: Tricky SQL Query Question

tnocella (7/15/2009)
I want my result to order by the lowest, but group them if a name occurs more than once, giving precedence to the lower number a name has. 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)

July 15, 2009 at 10:06 pm

#1025463
RE: View performance problems

Don't touch a thing. Get that 3rd party vendor on the bloody phone and have them fix it now!
--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)

July 15, 2009 at 10:03 pm

#1025461
RE: Is This The Best Way to Remove Duplicate Records ?

I always wonder at the words "Remove Duplicate Records"... from what? The original data as in a "Delete" or just from the output of a Select?
People really 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)

July 15, 2009 at 9:58 pm

#1025460
RE: Date functions causing queries to take longer

Grant Fritchey (7/15/2009)
J.D. Gonzalez (7/15/2009)
Execution plans attached.
I'm sorry, but can you zip those up & reattach them. I'm having a hard time getting them to open as is.
They're a new...
--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)

July 15, 2009 at 9:51 pm

#1025458
RE: Temp DB Best Practice

aravind_0404 (7/15/2009)
@free_mascot
Thanks for the reply...The size of log file should be 20-25% of the whole Datafile or the striped ndf's.
For TempDB, I'd say "neither". If you're migrating databases...
--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)

July 15, 2009 at 9:46 pm

#1025457
RE: Temp DB Best Practice

free_mascot (7/15/2009)
Usually Log file is 20-25% of your datafile. But still it depends on the application you are running, frequency of T-log backup, using logspace at the time of maintenance...
--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)

July 15, 2009 at 9:43 pm

#1025454
RE: How to reseed identities in all tables

ahmad.ghazi (7/15/2009)
Hi guys,
I want to create a script to loop in all tables to reseed the identities in a specific database
using:
DBCC CHECKIDENT(‘TableName’, RESEED, current_table_ident + 1)
How can i make...
--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)

July 15, 2009 at 9:39 pm

#1025453
RE: Over-Engineering

With the shrinkwrapped software and inhouse/3rd party code I've seen coming out lately, I'm pretty sure that over-engineering isn't a wide-spread 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)

July 15, 2009 at 9:36 pm

#1025452

Viewing 15 posts - 43,006 through 43,020 (of 59,098 total)