allan.madriaga (11/3/2011)

---

Hi Jared. The sum of NULLs actually do appear if I take out the following where clause:

WHERE ... AND (TimeTracking.UserName = 'someguy')

But when I insert that where clause...

allan.madriaga (11/3/2011)

---

Yes, you are correct. There will be rows in the Left Table but none on the right.

Basically, what I have is an auxiliary table called Calendar which contains rows...

EDIT:

Sorry... Losing it... Don't look...

Ok, so I'll go back to looking at expensive queries, looking at waits, and possibly running a server-side traace if need be.

Jared

Also, if you had 32gb of memory it would not seem so bad? I'm not sure that % to total is the way to look at this. My assumption is...

I really don't find it that unusual, depending on the queries of course. tempdb can be accessed by all queries on all databases if needed, so of course it will...

Again, I would look at recent expensive queries to try to track down the culprit. Have you looked at wait stats? Also, (not being an expert here) why are we...

Stubby Bunny (11/3/2011)

---

Hi,

ok tried with D drive and still same issue, I did login in from my client to the server witht he SA account and i was successful in...

Do you mean running "against"...

Sean Lange (11/3/2011)

---

allan.madriaga (11/3/2011)

---

Hi Guys,

So here's a question: When I add an extra WHERE clause in my query, the result set excludes rows with NULLS. Why does that happen and...

Can't sum a NULL... SUM(ISNULL(columnName,0)) nevertheless I assume that TimeTracking.UserName = 'someguy' filter contains no nulls in that column.

Jared

The problem is that that shared drive disappears when you are no longer logged into the server. It has to be mapped to a drive letter and set up to...

Just so I have all of my ducks in a row: The file is local to the SQL Server, you are logging in using SSMS from your client machine, executing...

Are you executing a stored procedure for this or simply querying? Also, can you query other linked servers? Maybe it is your user's permissions. If you log...

Here:

-- Isolate top waits for server instance since last restart or statistics clear

WITH Waits AS

(SELECT wait_type, wait_time_ms / 1000. AS wait_time_s,

100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,

ROW_NUMBER() OVER(ORDER BY...