Viewing 15 posts - 9,571 through 9,585 (of 22,224 total)
What should it be? A unique password for each server across the entire enterprise.
What is it usually? One 'sa' password across the entire enterprise.
What compromise I have I used? Disable...
"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 11, 2013 at 12:43 pm
Jack Corbett (9/11/2013)
jasona.work (9/11/2013)
If I create an XE session on SQL2012 (for the...
"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 11, 2013 at 7:16 am
TheSQLGuru (9/11/2013)
OH NO YOU DIDN'T!! Microsoft can turn off Profiler when they pry it from my cold, dead hands!! :hehe:
Step into the light. Extended Events are better in...
"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 11, 2013 at 7:15 am
If you have maintenance on the servers, that will show up when looking at the index usage stats.
I'm with Jack, set up extended events to track connections to the database....
"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 11, 2013 at 4:36 am
The first two are pretty much the same and can probably be used interchangebly, depending on the actual complexity of the query involved. The last two are very different. COUNT...
"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 11, 2013 at 4:35 am
While I was never crazy about the Mac OS, VMWare on the Mac was magnificent. It worked wonders. I loved how tightly it was coupled with the OS. I'm back...
"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 11, 2013 at 4:30 am
If you did hit a situation where this might help, I'd be sure to use FREEPROCCACHE with the parameter for the specific plans you want to remove rather than blasting...
"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 11, 2013 at 4:28 am
Erland Sommarskog (9/10/2013)
Grant Fritchey (9/10/2013)
The only way to get run-time information is to capture the plan while executing using SSMS or extended events.
You can also capture them with SQL Trace....
"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 11, 2013 at 4:15 am
The plans stored in the cache do not carry run-time values with them. They only have the compile time values. This is perfectly normal behavior. The only way to get...
"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 10, 2013 at 3:24 pm
I don't know MySQL at all, but on a SQL Server instance it sounds like you're talking about extended properties. The ability to add additional, meta-data, about the columns or...
"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 10, 2013 at 3:43 am
If these are completely different functional applications with no shared data between them, then no, I would not put them into the same database. The sizes you're talking about are...
"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 10, 2013 at 3:40 am
Yep. Exactly. Nothing hidden there. They are different constructs doing different things.
"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 10, 2013 at 3:36 am
L' Eomot Inversé (9/9/2013)
Grant Fritchey (9/9/2013)
"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 10, 2013 at 3:33 am
Also, if the data is that volatile you might be looking at statistics issues on the indexes. How are you doing maintaining those?
"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 9, 2013 at 4:12 pm
Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread... is a toddler now.
"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 9, 2013 at 4:06 pm
Viewing 15 posts - 9,571 through 9,585 (of 22,224 total)