Viewing 15 posts - 7,456 through 7,470 (of 22,219 total)
nam.lenhat (9/16/2014)
I see !, but I means, when the query finished, it doesn't release ram memory while I don't do anything after that 🙁
Yes. Exactly. It won't release that memory,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 16, 2014 at 8:16 am
Eirikur Eiriksson (9/15/2014)
Grant Fritchey (9/15/2014)
But, that could cause errors in the code if...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 2:05 pm
Jack Corbett (9/15/2014)
GilaMonster (9/15/2014)
Out of line? (Me, I mean) http://www.sqlservercentral.com/Forums/FindPost1613791.aspx
I can see teh frustration coming out a bit, but I wouldn't say out of line. I'd be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 1:36 pm
freddyism00 (9/15/2014)
it would be too easy to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 1:35 pm
Steve Jones - SSC Editor (9/15/2014)
My view is this:
100 -...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 12:45 pm
dax.latchford (9/15/2014)
Hi - Many thanks for the reply. Does this give me the number of user connections per DB or device connections?Kind Regards
Dax
Any of the methods listed can. But if...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 8:41 am
Sean Lange (9/15/2014)
Ed Wagner (9/14/2014)
Sean Lange (9/13/2014)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 7:31 am
I'd think the easiest way to do this would be to cheat. Rename it. Then name it back.
But, that could cause errors in the code if it tries to call...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 7:24 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 7:20 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 7:17 am
First five chapters of my book.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 7:15 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 7:12 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2014 at 6:58 am
SQL DJ (9/13/2014)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 13, 2014 at 9:19 am
Well done! Just keep coming back and slogging away. You'll get to the next level too. Congratulations!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 13, 2014 at 6:17 am
Viewing 15 posts - 7,456 through 7,470 (of 22,219 total)