I would only split the tables under certain conditions, like one of the following:

1. If there was a row in tblDistributorStats for only some of the rows in tblDistributor.

2. If...

ALZDBA (1/16/2008)

---

well maybe, just maybe, ... since you're on SQL2005 ....

you may want to add a computed_column of the datetime datatype and put an index on it.

check BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8d17ac9c-f3af-4bbb-9cc1-5cf647e994c4.htm

create table...

If you have to defrag a heap (with downtime allowed), and you don't want to add a clustered index, you can:

1. Rename the table to prevent access to it.

2. Create...

Arun T Jayapal (1/15/2008)

---

I hope all temporary tables are session specific. Actually I prefer them to be connection specific...are they?

So will the following statement reveal the connection specific information? If...

You need to run transaction log backups to keep from filling up the transaction log file.

I recommend that you run transaction log backups much more often, like every 15 minutes...

It is not that simple, since you did not include logic to test for NULL columns, even though your table allows...

Ian Yates (1/15/2008)

---

The author of the question never answered (as far as I could see) whether or not they wanted february of a specific year or every year's february instead.

The...

No, I said you can't reorganize it with DBCC REINDEX.

Index 0 indates the table is a heap (no clustered index), so you can't reorganize it with DBCC REINDEX.

Your only choices are to completly reload the table or to create...

You can read about this subject on the link below.

MIN/MAX Across Multiple Columns

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86906

select

a.[PrimaryPayor],

MAX_BAL = max(bb.xx)

from

(

select xx = a.[CURRINSBAL1] where a.[CURRINSBAL1] is not null union all

select xx = a.[CURRINSBAL2] where a.[CURRINSBAL2]...

You should read the "SET IDENTITY_INSERT" topic in SQL Server Books Online.

You might suggest that they test their code under SQL Server 2005 before asking you to upgrade to 2005.

Why no just alway always enclose columns that could contain quotes in double quotes?

select

MyCol,

New_Mycol = '"'+MyCol+'"'

from

(

--Test Data

select MyCol = 'xx''yy'union all

select MyCol = 'xx''''y''y'union all

select MyCol = 'xxyy'

) a

Results:

MyCol ...

I keep them in directories on a file share.

I just looked and had a little more than 2,100 .sql files.

It is best to delete the local proxy account before renaming the server, and add the new one after you rename it. If you don't, you may have to...