Viewing 15 posts - 7,456 through 7,470 (of 22,226 total)
Jeff Moden (9/18/2014)
Grant Fritchey (9/17/2014)
Jack Corbett (9/17/2014)
Grant Fritchey (9/17/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 18, 2014 at 6:37 am
Happy to help out.
"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 17, 2014 at 8:25 am
Jack Corbett (9/17/2014)
Grant Fritchey (9/17/2014)
So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd be appreciative.
Just saw...
"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 17, 2014 at 7:52 am
The second one is a little more specialized than the first. They both cover some of the same material, but if I had to pick, I'd go with the query...
"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 17, 2014 at 7:46 am
So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd be appreciative.
"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 17, 2014 at 7:17 am
It would be easier to make suggestions on how to address the performance issues if you posted the execution plan and the query.
"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 1:09 pm
SQL Saturday events, SQL in the City events, PASS Summit, SQL Intersection, SQL Connections, Live 360, SQL Bits, SQL Relay.
These are all events with great training. Some are free. Some...
"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 1:08 pm
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
Viewing 15 posts - 7,456 through 7,470 (of 22,226 total)