Viewing 15 posts - 121 through 135 (of 217 total)
I found how to do it with the Enterprise Manager, but can't find any reference in BOLS to do it through T-SQL
THANKS
Magy
September 12, 2005 at 1:38 pm
I guess I should have asked...what statement in the code you provided, instructs the server to automate the updates on that particular column?
September 9, 2005 at 2:17 pm
I think SEEK would be faster...just a hunch.
So in short, the index is in place to speed up the query?
What performs the automated...
September 9, 2005 at 2:05 pm
What is the difference between a seek and a scan?
I don't see why I can't just do this:
ALTER TABLE dbo.dmvrequest ADD
claimraw AS ltrim(rtrim(replace(DRclaimNumber, ' ', '')))
That gives me the new...
September 9, 2005 at 1:57 pm
But why do I need an index on this new column? I thought the LIKE function doesn't work on Indexes.
Thanks!
September 9, 2005 at 1:50 pm
wait...how does the computed column update itself?
and, what is an index scan and why is that bad?
September 9, 2005 at 1:14 pm
If I'm using the replace function when creating this new column, how come I can't just use the replace function when doing the original query? That way I wouldn't have...
September 9, 2005 at 1:07 pm
Oh I see...
I ran the query and got this error:
Warning! The maximum key length is 900 bytes. The index 'IX_serialnumbers_serialsnospaces' has maximum length of 8000 bytes. For some combination of...
September 9, 2005 at 12:52 pm
Oh I see....
What does EPNOM mean? I googled it and couldn't find much of anything.
September 9, 2005 at 12:40 pm
Ok, I understand creating an index...but what is dbo.Temps? Is that a table that I first need to create? And I assume the demo table is the table I'm using...
September 9, 2005 at 12:35 pm
Forgive my ignornace, but how does one create an indexed calculated column that strips out the spaces?
Thanks!
September 9, 2005 at 12:14 pm
Is REMI a computer? "his" answers seem so quick and concise, it's like it's coming from a computer. If he really is human, I hope he makes $$$.
August 23, 2005 at 9:13 am
Thanks for the link, I'll print that out and read it over lunch.
Here are my current tables:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FG_school_Info]') and OBJECTPROPERTY(id, N'IsUserTable')...
August 23, 2005 at 8:30 am
Thanks guys...
So should I just redesign using only one table? I can't change the form, because that is the info the people at school want and need.
I just thought...
August 22, 2005 at 3:13 pm
Viewing 15 posts - 121 through 135 (of 217 total)