The way SQL Server works, it will take all the memory in a server that it needs unless you tell it not to. That's just the way it functions. Here's...

You can see live connections by querying sys.dm_exec_requests. But to really audit connections, I'd suggest using the extended events. You can then capture all connection events to the server.

First five chapters of my book.

True, and while we're on it, there's also the object_id in sys.dm_exec_procedure_stats. So you have a number of ways to get at the plan handle for a given procedure.

If you're looking for a particular procedure name, then those extra spaces in the WHERE criteria are going to mess you up. Remove them and try again.

SQL DJ (9/13/2014)

---

Grant,

I have made the modification as below. It gives me duplicates...how can I remove these ?

isnull((select distinct (SUM(a1.ActualDebit) - SUM(a1.ActualCredit) ) from #MainAccount a1

LEFT OUTER JOIN

#BudgetAccount bb ON...

Well done! Just keep coming back and slogging away. You'll get to the next level too. Congratulations!

freddyism00 (9/12/2014)

---

hm ok, but why is it then said that columnstore indexes are "in-memory" ??that confuses me..

I read part of the whitepaper, it said the data columns are stored...

Gail's answer is good. You can also follow the links in my signature to my books on query tuning and execution...

Really, really, really need the execution plan to understand how things are behaving within your environment. Without that, it's all guesses. But, all these correlated sub-queries:

select (SUM(a1.ActualDebit) - SUM(a1.ActualCredit) )...

Yeah, you pretty much have to use it. Equality and Inequality columns are the columns being used within the queries in the WHERE, JOIN and HAVING clauses. They would make...

You need to look to your execution plan to understand how it's using the indexes you've created.

From the looks of things, you have an index on a bit column, IsActive....

I'm sorry, I'm not quite understanding what you're referring to here. Do you mean a table variable or temporary table?

You can also use DBCC FREEPROCCACHE and pass it the plan handle of the plan you want removed from cache.

NOTE: If you don't pass it a plan handle, you...

There's not much on the detailed internals of the in-memory indexes yet. The non-clustered index is still a b-tree, sort of. They also call it a bw-tree. The bw stands...