The only real option built in to Reporting Services would be using a report parameter that is passed to a stored procedure that returns the report results as well as...

Oh... and my bad for forgetting to mention in the first place...

When you create a subscription, a matching SQL Agent Job is created, named with the GUID of the subscription. I do not have access to SQL Server 2000 Reporting...

You will need to use a data-driven subscription. If the query for the instructions for the data-drive subscription does not return a row, no report will be sent. ...

If you are referring to "memory leaks" in a SQL Server instance, SQL Server will acquire system memory over time, but it will not release the memory unless requested by...

Ray K (6/3/2010)

---

nabidavid (6/3/2010)

---

Am I misunderstanding you, or would this not work:

select * from #NameList

where (ISNULL(@ByID, '') <> '' AND ISNULL(@BySpecID, '') <> '' AND ISNULL(@ByOfficeID, '') <> ''...

Am I misunderstanding you, or would this not work:

select * from #NameList

where (ISNULL(@ByID, '') <> '' AND ISNULL(@BySpecID, '') <> '' AND ISNULL(@ByOfficeID, '') <> '' AND Name like...

Jeff Moden (5/25/2010)

---

sunny.tjk (5/25/2010)

---

I read an article on the difference between delete and truncate operation.

(1) It said "DELETE is a logged operation on a per row basis. This...

I was worried the title of the article would get me fired. 😉 It needs some explaining for the boss...

I looked at the Advisor download page, but it doesn't go into details about how it gathers data. Is it a static inspection of the DB and the code stored...

Yes, you are correct. I meant Non-Ansi style joins. 😉

In the recent upgrade at our organization, we actually had a few of these JOINs. A few years ago,...

Is it possible that the statement retrieving the value from the table does not actually return a row..? This would make the variable NULL.

As the other posts have said,...

As many have said, I think the real answer to that question is based highly on the level of integrity of whomever gives the interview. As the employee being...

Actually, the amount of T-SQL to update will depend greatly on how close the development team followed best practices. My organization recently upgraded from SQL 2000 to SQL 2008...

Great article, Paul. I look forward to Part II. 😀

If you are not already covering it in a future article, I am curious if you have any advice...