Thanks, I'll check the disk and see what the diagnosis says.

That's for the I/O error but what about the DBCC CHECKDB not creating the snapshot ? Also related to disk...

Hi,

Thanks for the comments. I agree with the suggestion about db names and i´ll add it to the next version.

Pavle

I found a workaround if we are partitioning on a clustered index which is a not the PK (i don't remember it working with the PK)

create clustered index IX_P_Tab_col on...

Michael Earl (7/2/2008)

---

SELECT *

FROM TableA a

JOIN TableB b ON a.col1 = b.col1

WHERE colID = 123

If both tables have a ColID column, your query will give you an error....

I thought the topic was dead but I guess people still like it 🙂

To answer your questions:

- data will be accessed through a single web app which will offer the...

ehm stupid question: 1mb is the max file size I presume? If so does it mean the total size of all files doesn't matter (1mb or 1TB same stuff?).

Also,...

Thank you all for your interesting comments I think I will follow the advice and put the BLOBs on a separate filegroup. Regarding the indexes bit I read somewhere (I...

thank you all for your input! It helped!

ok thanks a lot.

I was thinking that as long as we don't perform any searches based on the varchar(max) column, there shouldn't be a problem because we only read...

Yep thanks,

a friend of mine suggested solving the 'customer isolation' problem by making one filegroup per user (and ending up with one DB split across hundreds of filegroups).

This could...

Thanks for replying.

-> so I suppose that having hundreds of DB's with the same exact DB structure but different data could kill the server...

Thank you very much for your replies.

Vidhya: I will have a look at the articles you sent me

Mark: I hoped that putting a "GO" after each statement would make it...

I tried testing with a JDBC connection and the things seem to run faster.

Jeff, if I understood well you generate scripts with bits that are stored in a working table....

Well I don't know if 16Mb is huge but the problem is that I cannot use QA because it is an automated task which runs in command line. As far...

I took the exam last week and I used the following guidelines:

- first thing first learn how to identify the sections of the case study that refer to your question....