Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,956 through 38,970 (of 59,098 total)

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
RE: Index suggestion for VERY large table

Welsh Corgi (4/8/2010)
Jeff,
I just read your response and I appreciate you input.
Regards,
Welsh
Thanks, Welsh.
--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:17 pm

#1149428
RE: MCJ - The Missing Link

CirquedeSQLeil (4/9/2010)
Yes Odd number of Board members. I don't think it should take more than three people though.
Heh... just odd bored members? 😀
--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 3:50 pm

#1149405
RE: Slipstreaming SP1 and Enterprise edition

Kathi Kellenberger (4/9/2010)
Take a look at the links I posted. Slipstreaming is combining the service pack with the RTM media. If all goes well, you don't have to apply 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 9, 2010 at 3:28 pm

#1149395
RE: MCJ - The Missing Link

I don't know if I missed it somewhere, but I believe there needs to be an "MCJ T-SQL" somewhere in the mix.
--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 8, 2010 at 10:23 pm

#1148797

Viewing 15 posts - 38,956 through 38,970 (of 59,098 total)