scb (12/2/2008)

---

Say for instance that you have one particular table that is huge and filling that drive. Say it's referenced by 5 stored procedures. Assuming there are minimal...

I have no idea...

I just have him as my cell phone ring tone...

No. 3gb and AWE are for 32 bit only.

A separate one. Backups onto the same array as data is firstly an eggs...

The query I posted runs fine on 2005 SP2 and 2008 RTM.

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...