Viewing 15 posts - 10,081 through 10,095 (of 22,224 total)
The individual logins under the server folder are all about access to the server itself. Then, under the database are the individual database users. These can be mapped back 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
February 5, 2013 at 3:43 am
GilaMonster (2/4/2013)
Grant Fritchey (2/4/2013)
And to directly answer your question, at least a little, check out the Extended Events gui. That's pretty slick.
I could live without the GUI, the enhanced windowing...
"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
February 4, 2013 at 8:04 am
I'm with Gail, look the stuff over and see what you think about it. If I'm interviewing you, I don't want to hear my opinion, I want yours. And 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
February 4, 2013 at 7:37 am
I'm not familiar with that particular part of Sharepoint. Sorry. It does sound like you're largely on the right track.
"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
February 1, 2013 at 9:48 am
Clustered indexes is slightly more important than primary keys, but yeah, I'd want both. You're right there.
But, you said this was a Sharepoint database? You can't really modify the structure...
"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
February 1, 2013 at 8:36 am
Honestly, the best advice I can give you on running the tuning advisor is: Don't.
But, it sounds like you're capturing the load, but that you're not restoring the database 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
February 1, 2013 at 8:17 am
Basically, a hash builds a table with a key and then uses a probe function to join together two streams of data. Then, if the key in that table is...
"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
February 1, 2013 at 4:39 am
I think SqlVogel has primarily nailed the technical part of the answer. I'd add one more reason for using a primary key over just using unique constraints. Clarity. By defining...
"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
February 1, 2013 at 4:33 am
And backup is an operation that lets you see what percentage complete it is if you look at the running process in sys.dm_exec_requests.
"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
February 1, 2013 at 4:26 am
SQLSACT (1/31/2013)
I understand the workspace memory area (Well, I hope I do). A query will request required memory and once the query has been granted that, if it needs 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
January 31, 2013 at 8:06 am
If you have a query that is taking a long time, the first thing I'd suggest is taking a look at the execution plan to understand what it's doing 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
January 31, 2013 at 7:51 am
Welcome to the Thread! And SQL Server Central.
By and large, we try to keep this place as a water cooler, a place to discuss things other than technology, although technical...
"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
January 31, 2013 at 7:43 am
Well what's the major issue. You're asking about very low level behavior. It's not immediately applicable to most tuning situations. I mean, there is a specific area called workspace 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
January 31, 2013 at 7:35 am
Great catch Lynn. Good point. But, once again, back to clarity.
"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
January 31, 2013 at 6:50 am
Get a copy of SQL Server 2008 Internals by Kalen Delaney. Then read it 100 times. You'll still be confused (as I am) but less so.
"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
January 31, 2013 at 6:44 am
Viewing 15 posts - 10,081 through 10,095 (of 22,224 total)