Hi Gail,

Thanks for the quick reply, I think your probably right as it is one of them 'jack of all trades' procedure which has some parameters which are optional.

I'll dig...

I think I've answered my own question, from all the reading I'm doing, the dmv sys.dm_os_memory_clerks does provide me with the amount of memory currently being used by the instance.

Nic

Assuming it's addressing all the resources correctly, is there any difference in the plans? I.e perhaps an index is missing from the server?

Hi Marcia Q,

As mentioned before, your probably best only working on the indexes you need to.

I have a script (would be happy to pass it over to you) that checks...

Excellent article Tim, and as Jeff noted, "truer words never spoke".

I think it provides an important reminder (certainly to myself) that we are all part of the cycle - albeit...

Thanks for the reply Steve.

3 it is, just thought it best to check, sometimes you cant see the forest...

For anyone who is interested I came across this;

As my decision was being influenced by the volume of NULL values, it helped to clear a few things up. 😉

Thanks.

Thanks for the reply.

Thats how I would typically do it, it's just the fact that some employee's may have attributes (columns) that others may not that makes me thing option...

deepak.sahu (12/16/2009)

---

Hi All

I am seeing this error being logged in my SQL 2005 Ent machine

A read operation on a large object failed while sending data to the client. A common...

Hi,

Dont know if you resolved this, but I've had a similar issue, I resolved mine by ensuring the port that the browser is listening on it open. This seemed...

As far as i'm aware on the WHERE clause you cant apply a collation to all, it has to be on each one.

However, you can set the collation for a...

yeah it is going to get a little messy. :w00t:

I'm just wondering is there any other solution, the issue is that your needing to compare different collations!

so can the collations...

No, to my knowledge your going to need to set the COLLATE for each of your statements, I'm not aware of a COLLATE command that would cover all of them.

Sorry.

mark.veitch (11/25/2009)

---

DECLARE @sql AS VARCHAR(MAX)

SET @sql = 'SELECT SRequest.SRequestId FROM dbo.vw_SRequest SRequest

LEFT JOIN vw_LinkSRequestNameAddress LinkSRequestNameAddress

.

.

.

+ @Whereclause

+ ' GROUP BY SRequest.SRequestId'

The WHERE clause is passed in as a parameter after being...

Garadin (11/23/2009)

---

OP, correct me if I'm wrong here, but let me attempt to explain this better:

He's not just trying to round up every time. Here's a couple examples:

--His Original...