Viewing 15 posts - 12,616 through 12,630 (of 18,923 total)
What part of it is actually normalised??? That's gonna be the real performance killer.
October 7, 2005 at 12:34 pm
"Last, Your manager has the ability to fire your ass, so you may want to let him "Win"."
Now that's something I don't like to do... I'd try calling it a...
October 7, 2005 at 12:32 pm
That still doesn't give us the schema, sample data and needed output. Plus execution plans could really be a big help here.
October 7, 2005 at 12:25 pm
Ok, so you can't run the query once/how or whatever and insert the data in reporting table for fast access.
We'll need more info to suggest improvements on the query. ...
October 7, 2005 at 12:06 pm
UPDATE dbo.YourTableName SET FieldName = REPLACE (FieldName, '-', '-3')
October 7, 2005 at 12:03 pm
That's how I'd do it... but maybe there's another way in RS (never worked with that product).
October 7, 2005 at 12:02 pm
Ya it makes sens, I think
.
How is that gonna be used in the application?
October 7, 2005 at 11:50 am
Even simpler than that.
Table Images
ImageID
ImagePath (or the image itself)
...
Table
Classification
ClassificationID
ImageID (foreign key to the images table)
...
Then
Select Columns, List, from dbo.Classifications S inner join dbo.Images I on S.ImageID = I.imageID
October 7, 2005 at 11:47 am
Well maybe you can post a short version
.
Is it for reporting?
October 7, 2005 at 11:38 am
I'll go with the doesn't matter part (assuming sql server 2k +... and maybe even 7 but I never worked with them).
It's the server that takes the fastest possible way...
October 7, 2005 at 11:37 am
Shouldn't the image be in a separate table.
That allows you to join to that table using a case expression and it follows the normalization rules.
October 7, 2005 at 11:34 am
Are you using a stored proc/function for this operation??
October 7, 2005 at 11:33 am
Nope either... the list of constraints is REALLLLLLLY lllllllllong
.
Why do you want to do an indexed view for this task... and what is...
October 7, 2005 at 11:31 am
Declare @Date datetime
declare @Time datetime
set @Date = DATEADD(D, 0, DATEDIFF(D, 0, GetDate()))
set @Time = DATEADD(D, - DateDiff(D, 0, GetDate()), GetDate())
Select @Date, @Time, @Date + @Time, DATEADD(MS, DATEDIFF(MS, 0, @Time), @Date)
October 7, 2005 at 11:28 am
Viewing 15 posts - 12,616 through 12,630 (of 18,923 total)