Hi Greg,

1: You can only partition by a single column, and you cannot have subpartitions

2: indexes can be tpartitioned in different ways. You can align them with your table, but...

If you are connecting to 2000, and the database you are trying to connect to is online, as mentioned you will not be able to access the mdf file.

In the...

Two solutions come to my mind:

in one you would use a helper table to keep track of the existing empid, StateNo, CityNo, CallType combinations, with an identity column for...

You cannot connect to the server this way. The mdf file is locked explicitly by the SQL Server.

When you connect to the database, specify the server name, log on...

Hi Luis,

it is not an easy task to do, but possible. The question is more along the lines "is it really worth?". It took me over 9 months for...

Pivots perform a group by, so they must use an aggregate. If the data is the same though, or there is only one item, using max or min solves the...

Is this a Microsoft SQL Server database? SQL Server does not support database encryption, so are you using a third party tool? If so, what is this tool?

Enc extensions are...

The documentation that comes with SQL Server (Books Online, or BOL) is an excellent resource for learning about indexes. Its contents are also available on the web. For indexes a...

Unfortunately SQL Server does not ignore errors in insert statements, and you cannot really force it to do so. At the end of the day it is a transaction, and...

Hi Andri,

have you tried updating your statistics?

exec sp_updatestats

(this will run UPDATE STATISTICS for all the system and user tables)

You have rebuilt the nonclustered indexes, but just in case run DBCC...

FerasGer83 (10/1/2007)

---

thank you .

what i got is that the downside of FULL Backup is the time it consumes from the server, so that we can't take a FULL backup...

winnri (10/1/2007)

---

Thanks Andras. I am OK with the 80 databases. It's the 90 databases I cannot restore to my 80 instance. What I want to do is...

The size of the decimals will be in both cases 5 bytes (because the precision is between 1 and 9), so the total is 25. I.e. your row will take...

I assume you are trying to migrate your 80 databases? When you say you cannot restore them, do you mean you are getting an error message? If so, what is...

You could use a temporary table with identity:

SELECT IDENTITY( INT, 1,1...