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

have you been granted usage rights of the proxy ?

if your rollback takes abnormaly long (and should have completed according to your workload knoledge) , best is to stop/start the instance :crazy:

Your db will only be back online when...

It is not considered a good practice to have sqlserver and analysis server on the same physical box.

Exactly for the reasons you see.

They are different by nature and will compete...