Grant Fritchey (9/29/2008)

IF NOT (@brand_id IS NULL)

BEGIN

SELECT p.pk_product_id

FROM tbl_products AS p

JOIN tbl_brands AS b

ON p.fk_brand_id = b.pk_brand_id

WHERE b.fk_brand_map_id = @brand_id

OR b.pk_brand_id = @brand_id

END

But that second OR is still going to...

Glen (10/1/2008)

---

It is more of question of what advantages/disadvantages AREAS you are looking for? (i.e. Speed, Maintainability, Architecture and Design etc.)

The discussion "Is dynamic SQL better than Stored Procedures"...

Are there any situations (resultset or performance) where using IN is preferred over JOIN?

Matt Miller (9/26/2008)

---

Your script looks a little strange. The Variables you're using in the CATCH aren't declared anywhere. If you want to raise the error you got, then...

Ninja's_RGR'us (9/26/2008)

---

In that case you don't really have a choice to do it the way you're doing it (or similar).

For the db fragmentation. Check the current DB size on...

The source database is a linked server residing on another server. Additionally, the "linked" server is not a MS SQL Server.

PW (9/25/2008)

---

As always, the answer is "it depends".

Depends on volume of Insert/Update/Delete activity on the table versus Select.

Depends on how the data is typically accessed ie, always looking at the...

Here's my solution based on the following inputs:

1. rbarryyoung's replial @ 3:23PM

2. http://www.sqlservercentral.com/articles/Security/sqlserversecuritythedb_executorrole/988/

Thanks again for everyone's help.

CREATE TRIGGER [Create_SP_Trigger]

ON DATABASE

FOR CREATE_PROCEDURE

AS

...

Cliff Jones (8/28/2008)

---

We have found on our 64 bit servers (especially our Itanium) that if we leave Maxdop at 0, the server spends a lot of CPU time transferring the...

Cliff Jones (8/28/2008)

---

On our 64 bit servers we set the memory to allow 1.5 - 2 GB for the OS as Gail recommended and set Maxdop at 1 or 2....

Steve,

Thanks for the suggestion about using @@scope_identity.

How would I use a trigger to acquire the id before insertion? Won't there be problems because I need to use the to-be-inserted id...

GilaMonster (8/27/2008)

---

jlp3630 (8/27/2008)

---

I'm running RAID-0 on my c: drive (contains Windows, SQL server, master, model and msdb databases and log files).

I'm running RAID-50 on my f: drive (tempdb, user databases...

Is this the website that you were referring to regarding performance counters:

http://sqlserver-qa.net/blogs/perftune/archive/2007/06/19/memory-issues.aspx

Thanks again for all your input.

sam (8/27/2008)

---

I logged into the server this morning, and everything seems to be running ok. In other words, SQL server queries are running fast, and RDC is running at normal...

DavidB (8/27/2008)

---

Very sorry about that. The link I was referring to was http://support.microsoft.com/kb/918483.

Not so sure that applies based on the errors that you provided.

Have you installed...