Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,926 through 38,940 (of 59,072 total)

RE: more than 250 indexes on a table

CirquedeSQLeil (4/10/2010)
After re-reading the OP, it seems that the best plan of attack to me would be to migrate to SQL 2008 first and then add the new indexes. ...
--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)

April 10, 2010 at 8:13 pm

#1149663
RE: How to build 7 day slots based on start and end dates?

Oh... and just to be sure... this code also removes dupes if they occur on the same date. Only the earliest dupe according to the RowID will be kept....
--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)

April 10, 2010 at 8:11 pm

#1149662
RE: How to build 7 day slots based on start and end dates?

BIMind (4/10/2010)
Hmmm Jeff..thanks for the input...
i am surprised by the results with your code...i am wondering why...because it works perfectly with the same data i posted above
It's because there 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)

April 10, 2010 at 7:57 pm

#1149661
RE: How to build 7 day slots based on start and end dates?

Here's one very high speed method that also has the advantage of being able to stop the code just prior to the final delete to verify what's actually going 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)

April 10, 2010 at 7:53 pm

#1149660
RE: How to build 7 day slots based on start and end dates?

BIMind (4/10/2010)
sorry for the late reply guys
berry...this worked perfect..i cant believe how simple this is...
if anyone is interested, here's the sample script
create table sample_7day (call_id int identity(1,1), UserID int, Post_date...
--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)

April 10, 2010 at 7:04 pm

#1149658
RE: How to build 7 day slots based on start and end dates?

bteraberry (4/8/2010)
Are you wanting to delete any user record if that user has another record within 7 actual days or are you only wanting to do this if it's in...
--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)

April 10, 2010 at 7:03 pm

#1149657
RE: Create a Temp table or have different join for each aggregation

kjain (4/9/2010)
I have stored procedure that returns aggregated values. I need to different aggregation but there are about 5 table joins for the first aggregation, and one additional...
--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)

April 10, 2010 at 9:31 am

#1149572
RE: more than 250 indexes on a table

hennie7863 (4/6/2010)
For a customer i have to investigate a table [font="Arial Black"]wich has more than 250 indexes on it[/font]. The company who built the software recommends adding more indexes. 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)

April 10, 2010 at 8:58 am

#1149564
RE: sort order

pmadhavapeddi22 (4/9/2010)
Hi Sasidhar,
It really helped me. Thanks
Padmaja[font="Arial"][/font]
Cool... can you post the function you ended up with, please? I'd like to see what you did. Thanks.
--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)

April 9, 2010 at 10:31 pm

#1149490
RE: query help - is there a good solution to this?

SQL_NuB (4/9/2010)
Ok, here is what I'm running into
I have 2 tables that I have to use.
table 1 has 2 columns that I need
refDate, closedDate (taskName needs to be joined on...
--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)

April 9, 2010 at 10:21 pm

#1149488
RE: Archiving Millions of Image records

GSquared (4/9/2010)
Another option would be to copy the images you need into a parallel table, then swap the table names and drop the old table. Use a backup of...
--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)

April 9, 2010 at 10:09 pm

#1149482
RE: Tempdb log full situation

rames.net (4/9/2010)
Seems to be a silly question but really the answer requires for me.
I have a small doubt, Generally when I got alert on tempdb log file size 75 %...
--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)

April 9, 2010 at 10:04 pm

#1149477
RE: Update query - need suggestion

Baskar B.V (4/9/2010)
Forgot to mention in the previous post.
The total records which would get updated would be around 10 million records.
My recommendation is that you split that up into batches...
--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)

April 9, 2010 at 10:02 pm

#1149474
RE: data manipulation by row

NEAL-464478 (4/9/2010)
hi - how can i restructure date based ProcessDataID. data show now like this in DB -
IdnoProcessDataIDNameColor
1-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)

April 9, 2010 at 9:57 pm

#1149471
RE: Index suggestion for VERY large table

Hey folks... as a sidebar to all of this, since the Integer date is in the yyyymmdd ISO format, the formula to convert the Integer date to the DATETIME datatype...
--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)

April 9, 2010 at 5:20 pm

#1149431

Viewing 15 posts - 38,926 through 38,940 (of 59,072 total)