Bear in mind that was a very simple 2 table database that I played with there. Don't assume that the 0% will apply to more complex DBs with more...

A time table - Physics 101, Lecture room 2B, 9am every monday.

Movie schedules. Movie X shows every day this week at 17:00, 20:30 and 23:00

A store list with their opening...

Michael Earl (7/11/2008)

---

You can do an outer join with your join information in the where clause.

However, use the JOIN keyword. The old syntax with tables spearated by commas and...

Freeproccache clears out all cached plans, for both stored procs and adhoc queries.

You can either drop the foreign keys, truncate the table and then recreate the foreign keys, or you can use DELETE FROM instead of TRUNCATE TABLE

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

No replies to this thread please, direct replies to:

http://www.sqlservercentral.com/Forums/Topic532206-147-1.aspx

Could you post the query that you are using?

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic532181-323-1.aspx

SQL 2000 has no built in encryption/decryption mechanisms.

p.s. SQL 2000 posts should go in the SQL 2000 forums

John Rowan (7/10/2008)

---

This sounds like a disk bottleneck to me. You've got your OS, paging file, and DB files all on one physical disk. Regarless of how you...

Apologies. I misread.

However, if the...

How are you checking the memory used?

I've noticed a large number or issues reported on this update.

Not just failures to install, but problems with the SQL instances after the install.

There are some interesting...

Select into just creates a new table matching the number and types of the columns in the select statement.

It does not create constraints, indexes, defaults or anything else other...

Jeff Moden (7/10/2008)

---

I, too, can't wait until the split of Date and Time... leaves much opportunity to easily get to 15,000 posts in a hurry explaining to people how to...