Viewing 15 posts - 10,186 through 10,200 (of 22,224 total)
That is not behavior I've run into before. Is there something special about your domain setup? I use domain specific logins for all my installations and haven't seen this type...
"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 11, 2013 at 4:08 am
I'd go with 2012. I still haven't finished upgrading to it here, but it offers opportunities that don't exist in 2008R2. But, you do have to deal with the crap...
"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 10, 2013 at 7:13 am
I'm not comfortable with any of those answers. A is somewhat true, but so is B. I'd have to choose E if pushed, but I'd want to have a long...
"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 10, 2013 at 7:12 am
None of the above.
Use the source control system that has all the database objects in it to run an automated build for the new people. But not to create 10...
"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 10, 2013 at 7:08 am
You can also create extended events to capture all logins.
"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 10, 2013 at 7:05 am
Was it always one word? Back in the day? Where's Jeff. He remembers the dawn of time. If it used to be Data Base, then DBA makes sense.
"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 10, 2013 at 7:01 am
So when the load is complete, you need to send an email? Couldn't you just add that to the end of the load process? A trigger will work, although I...
"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 10, 2013 at 6:17 am
anil.janu143 (1/9/2013)
can anyone provide code for solution please.. because i am not able to understand the theory part..thanx in advance....
Since no one is sitting at your desk with a full...
"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 9, 2013 at 8:44 am
I'm still back to hard to say, but, in general, I would avoid holding open a query, on purpose, for 15 minutes under any circumstances. The fundamental concepts of transactions...
"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 9, 2013 at 5:12 am
jitendra.padhiyar (1/8/2013)
You explain me what exactly statisc is and what the sql server doing during update statics. Can you pls clear my more doubts?
1. Is it...
"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 9, 2013 at 4:55 am
Kishore-132325 (1/7/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
January 9, 2013 at 4:50 am
It's hard to know if it will create a deadlock or not without being able to compare other code to understand where locks might occur. Will it create a blocking...
"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 9, 2013 at 4:48 am
Sort operations also hit tempdb. If you have read committed snapshot enabled on any of the databases, they're going to use tempdb. There are just lots and lots of uses...
"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 9, 2013 at 4:43 am
If the column has statistics on it, those represent the data distribution as SQL Server understands it. You can use DBCC SHOW_STATISTICS to see the density, also known as selectivity,...
"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 9, 2013 at 4:41 am
You'll need to monitor the size of your logs and possible the tempdb. Make sure you have enough disk space for all the additional information.
"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 9, 2013 at 4:38 am
Viewing 15 posts - 10,186 through 10,200 (of 22,224 total)