Carla Wilson (12/2/2008)

---

So I was wondering what the general consensus is on using varchar versus nvarchar, especially for longer strings. Is it considered best practice to always use nvarchar,...

Are the data files all in the same filegroup or are they in different filegroups?

Basically, yes. So your proc that calls other procs would be something like

CREATE Procedure blah (@blah)

AS

EXEC MyPRoc1

EXEC MyPRoc2

EXEC MyPRoc3

EXEC MyPRoc4

...

If the procs can fail and throw errors, you need to...

Setting the degree of parallelism to 8...

Probably. But the number and size of servers...

You mean like this, or something else?

select title, FirstName...

Honestly, it would...

leonvr (12/2/2008)

---

For BI I want read-only permissions on all sqlserver databases on a server. We will get this done. The problem is however that I have right to (accidentelly) shut...

Up to you. There's only a difference of 1 exam (and, of course, all the studying needed).

2 exams to get ITP (2005) and then 1 to get both TS...

You've got two options to get the 2008 exams.

Finish your 2005 ITP (2 exams) and then write an upgrade exam to get both the MCTS (Implementing and Maintaining) and the...

I don't think I'd use 50. It'll have the same problem as 5 - poor write performance due to the parity stripe. Each write may incur up to ((no of...

You say partitioned. How many physical drives are we talking here? Raid? SAN?

If you want perfect...

Log file on RAID 10 dedicated array

Data file on RAID 10 (preferably) RAID 5 (acceptable)...

Tran log growth is hard to predict. As well as the data, there are log headers, internal allocation pages that need logging, etc. Plus, if there was other stuff also...

Linked servers and remote queries are an excellent way to slow things down.

Why do you want to split the DB up? If the hardware is correct, the design is good...

sal527 (12/2/2008)

---

i have written a trigger which auto generates the proj_pjid when project is created ex: new project number will be '664', it generates the id with respect to...