Viewing 15 posts - 13,771 through 13,785 (of 22,227 total)
I'd take a look at sys.dm_exec_requests and see what that process is doing. What's it waiting on? Is it blocked? All that stuff.
In general, yes, I'd break this down into...
"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
December 28, 2010 at 9:38 am
You can use the Dynamic Management Object sys.dm_sql_referenced_entities to gather the tables & views referenced by a procedure. That assumes that the procedure is not dynamic SQL though.
"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
December 28, 2010 at 9:32 am
sawantpl@gmail.com (12/28/2010)
Thanks Grant Fritchey.Can you please complete my example & give solution for 3NF.
Honestly? I don't think so. I don't have enough understanding what that data represents to give you...
"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
December 28, 2010 at 9:09 am
Short answer, right at the beginning.
Just be careful with the nomenclature. Schema can mean the database design and it can mean the owners of the objects within 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
December 28, 2010 at 8:45 am
We did this 18 months ago. We were able to schedule downtime, so we went with the simple process of a backup, copy & restore to move the databases 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
December 28, 2010 at 8:31 am
Only as you implement more and more functionality, Reporting Services, Analysis Services, otherwise, by and large, running the SQL Server service is about the same. However, we have hundreds of...
"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
December 28, 2010 at 8:17 am
I've seen errors like this and they've always been a security issue. I'd double check that the job is running under the account you think it is and that that...
"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
December 28, 2010 at 8:13 am
Export the stored procedures out to a script or set of alter scripts. Make the changes in the scripts. Run the scripts against the server.
For a mechanism to automate...
"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
December 28, 2010 at 8:04 am
1. Normalization is a part of design, as Paul says. The amount of weight that goes behind it? A lot. You really should normalize the database design properly or you...
"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
December 28, 2010 at 7:52 am
I've been working for a large company and I set up, what we used to call in the Navy, a "Tiger Team." It was meant not as a leadership team...
"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
December 28, 2010 at 7:17 am
homebrew01 (12/23/2010)
Would the default trace files be of use to at least get some information about what heppened between 12:00 and 4:00 ?
Nope. The default trace does not capture DML...
"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
December 23, 2010 at 10:49 am
You've got a "very important" production database and no log backups and an untested recovery process? It's either not actually "very important" or you guys have a long and painful...
"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
December 23, 2010 at 7:07 am
I might be missing something, but couldn't you just do a GROUP BY on the date with a count? Seems like that would be a lot easier than loading temporary...
"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
December 22, 2010 at 1:20 pm
dajonx (12/22/2010)
"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
December 22, 2010 at 1:15 pm
dajonx (12/22/2010)
Unfortunately, we do not have a SAN. However, we 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
December 22, 2010 at 12:04 pm
Viewing 15 posts - 13,771 through 13,785 (of 22,227 total)