Rem,

I would leave the affinity default.

Gail,

Thanks for the bol ref.

Yes you can.

We try to avoid it (just in case...)

Books online has the cluster install procedure.

-Keep in mind to prepare your Windows groups to host the instances service accounts

- Keep...

With sql7 and sql2000 you're better off putting your user objects NOT in the primary filegroup, but is your own added filegroup(s).

Reasons ? Think IO parallisme.

- you can place an...

James Horsley (9/3/2008)

---

I don't really agree - surely...

Rem,

Can you post sqlserver version info (sp/cu) ?

Gail,

Do you have a kb ref for the min = max memory config problem ?

Indeed, this guideline to enhance IO still goes for sql2005 and 2008.

However, if you're going for partitioned objects, you should keep in mind there is a huge advantage in keeping...

We just created a "group mailbox" (=classic mailbox) and granted every dba read of the mails. This way every dba can see if a mail has been handled or not.

sanjeev_krs2004 (9/2/2008)

---

Thanks a lot 🙂

I got it; could you please tell me how to use for loop if I need to pick up one of the different lookup (drop-down) values.

for...

did you also have a look at this article ?

http://sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx

You can off course always make a comment to the article, so Frederik can reply himself.

sanjeev_krs2004 (9/1/2008)

---

Hi,

I have two tables namely account and invoice.

I want to update one field in account table when there is A NEW RECORD inserted in invoice table. I want to...

- look for implicit conversions (show xml execution plan)

- how is your sqlservers memory doing (pressure ?)

WayneS (8/31/2008)

---

I just upgraded a sql server 2000 instance to 2005.

One of the databases has some views that use :

select top 100 percent <columns to retrieve)

order by columna, etc.

the view...

one should provide index for FKs by default.

Except when it hurts your databases performance.

Keep in mind the in SQLServer 2005 you can disable an index and only build it if...

Here's an example that can be executed using your sql management studio in SQLCMD mode.

first of all ... from BOL 2005 :

[ @password = ] { encrypt N'password' }

Is the password required to activate the application role. password is sysname, with no default....