No unfortunatly only on OLTP.

But on OLTP you can even use a so called distributed partitioned views where you can distribute your data betwenn several servers completly transparently to the...

For shure!

I'm running several SAP systems for over 2 years now!

My database size is over 150 GB and I have 1300 user connected to. The average transaction response time is...

Shure.

Have a look in the BOL under "Creating a Partitioned View"

It's easy if you have SQL2K Ent. Edition

It would be very useful.

I personally would put an extension to the insert command like "WITH UPDATEEXISTING"

Same for the BCP or DTS and bulk insert.

I think the biggest help could...

The optimal environment is if you have plenty of disks to put the system, tempdb, logs, data and indexes on different physical disk arrays. you could even partition your data...

I've got the same type of problem.

To solve this problemI had to put into the PATH environment variable the path of the SQLServer binaries C:\Program Files\Microsoft SQL Server\MSSQL\Binn

As of today I would definitly not recommend storing image files on the DB.

Storing those files will be much faster and you will use much less ressources then storing them...

Why not to use simply the sp_spaceused system stored procedure eventually together with the sp_MSforeachdb proc?

Why not to use a partinioned view?

If you are putting new records once per month a new table/month could be good candidate. So you could keep the insert and update...

Tomiz,

Just to speed up your queries you could considere to put the text column on a different filegroup which is on a separate physical disk with the TEXTIMAGE_ON filegroup clause...

Of course you could think about splitting table horizontally and vertically.

If you have tables with too many columns you could try too split them b yfrequently used and less frequently...

I will put my 2 cents here too:

I'm supporting actually my customers running SQLServer and DB2, in the past I was running Oracly and Sybase too.

My opinion:

System: SS was made...

Just some words of clarification:

quote:

---

mromm wrote:

A constraint is added to the column definition like this:

CREATE TABLE table_name (

abc int NOT NULL...

Yes I did mention the xp so 13 thread ahead .

I've just called it a DLL because an xp is in fact a dll which has to...

Brandon,

I still belive that this is the wrong way you go by doing as you have written (remove comments, table, sp names...) (bonjour la maintenance! )

The same...