Partitioned tables don't need any specific scolumn types in them. The common example is to partition on a datetime column (ann rows between 1 jan 2005 to 31 dec 2005...

I have a client with SQL 2000 SP4 on his Small Business Server 2003.

From what I read, the real server is full SQL. MSDE was used as a test by...

Can I run the DBCC DBREINDEX commands on a database that's in use?  I found an article on the web that says go ahead, and another that warns NEVER to...

There is no object 0. If a page is allocated to object 0, it means that it is an unowned (empty) page. It sounds like there may be some chain...

At the archery range

Lounging in bed reading a good book

Playing computer games (I'm replaying starcraft in anticipation of starcraft 2)

Dinner with friends.

To find out what a proc is waiting on, open another query analyser/management studio window and run

SELECT spid, waittime, lastwaittype from master..sysprocesses

You'll have to look through the processes to find...

I would highly recomend that you get the following removed from the mainenance plans.

Remove unused space from database files (shrink db when it grows beyond 50MB, free space after shrink:...

Ah. In that case, I would suggest remove all schemas other than dbo and make sure that all users have the dbo default schema. That should remove any possibility for...

Are you using SQL 2000 or SQL 2005? If you are using 2000, post in the 2000 forums. If you are using 2005, please post in the 2005 forums.

Most of...

Could you pos the proc please?

Things to check - how much space is free in the DB? If it has to grow to accomodate the data, you will get slow...

Dunno about the problem changing the default schema, try using T-SQL rather than the GUI. ALTER USER ...

It is recomended practive to always specify the schema name when refering to...

Indexes can be used for range scans.

If, say, you're always looking for the latest 10 records in the table, an index on the date field is very useful.

This is...

It might be an idea to normalise the table so that you can do equalities, rather than having to use like across a comma delimited list.

I did a comparison a while back, comparing the cast as varchar with the dateadd method for removing a time from a datetime, and the dateadd came in much cheaper...

It seems splitting up the current proc into numerous different queries defeats my original purpose of writing one generic proc in the first place and still no-one has answered the...