Please abstain from using Isdate function.It wont be of any help.For ex

select Isdate(201101) Returns 1

My best bet would be that first you check the length of the column and then...

Sorry.Didnt notice it.Seems like there is no fix for this.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144747&whichpage=2

You need to specify the logical name and not the physical name of the file.

I am not to sure.

Set up the database in single user mode and then take backup and then set up to multi user.

I always believed that maximum memory used for the cache will be 25% of the Non-Awe memory(if enabled).Also remember perform monitor wont give proper memory status if you have AWE...

@Gail

Do you think table variables might also face "Allocation Page Contention" the way temp tables do ?

Just now I found this on MSDN

Hey Gail thanks for the reply.

Now it is getting a bit...

Ok I will do that and wait.:-) Hopefully someone comes up with an answer.

No replies...:crying:

Just realised Soundex wont work if data is entered like this '9015 Canon' as soundex function does not works well on numeric identifiers

select SOUNDEX('Canon IXUS 90 IS'),SOUNDEX('Canon 9015'),SOUNDEX('9015 Canon'),SOUNDEX('Cannon')

Or else you can try the Soundex function.

select SOUNDEX('Canon IXUS 90 IS'),SOUNDEX('Canon 9015'),SOUNDEX('Cannon')

Sure... and sorry... I get a little touchy about people not following all the rules because of the huge amount of heat I've taken about it. Here's the link:

I realize the intentions are good here and thank you for that but there are a couple of problems with the code there. For one, it breaks several of the...

GilaMonster (1/16/2011)

---

Probably because your data file had to grow, and it won't grow by just 2 pages, it grows by whatever the autogrow size is. Other than the 2 pages...