Viewing 15 posts - 9,571 through 9,585 (of 22,226 total)
The key, the whole key, and nothing but the key, so help me Codd.
When you define a key, that's what you have to use.
Now, if the two columns that you're...
"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 12, 2013 at 8:12 am
Interesting question. I did a couple of simple tests where I did a TOP, without an ORDER BY since you didn't say there was one. The estimated costs were roughly...
"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:54 pm
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
Viewing 15 posts - 9,571 through 9,585 (of 22,226 total)