Viewing 15 posts - 13,756 through 13,770 (of 22,224 total)
I think the error you're getting is "fallback certificate initialization failed"
I've never heard of this error myself, but it seems that it's not uncommon[/url]. It may have something to do...
"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 29, 2010 at 7:37 am
If you want to capture performance counters in TSQL, instead of using extended calls, which can be very problematic, and require different security settings that might not be all 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 29, 2010 at 7:32 am
2005 or above, I'd go to sys.dm_exec_requests to see which processes are running slow, which ones have wait states, which ones are blocked. You can combine it with sys.dm_exec_sessions 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 29, 2010 at 7:28 am
Agreed with Pradeep. However, the best way to be sure the backup is valid is to have tested it against another server in an actual restore. For some of our...
"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 29, 2010 at 6:39 am
You can use Profiler to capture statement starts, but if a statement errors out, Profiler doesn't catch that completion event because it didn't fire. I agree with everyone else. I'd...
"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 29, 2010 at 6:37 am
Sounds like you got past the issue. I strongly recommend the approach you took, rewriting the query to use better mechanisms as a tuning method. I really, really, hate what...
"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 29, 2010 at 6:32 am
GSquared (12/28/2010)
What I recommend, however, is if the data is the same in each database, move it to one database and have 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
December 29, 2010 at 6:28 am
Steve Jones - SSC Editor (12/28/2010)
WayneS (12/28/2010)
(From a higher...
"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 29, 2010 at 6:22 am
WayneS (12/28/2010)
(From a higher level) How to set up...
"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 29, 2010 at 6:19 am
Henry Treftz (12/28/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 28, 2010 at 12:33 pm
wendy elizabeth (12/28/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 28, 2010 at 12:03 pm
It's running then. No other way to be sure what it's doing. You can use the offset to understand which statement is currently being run, assuming that's useful. Otherwise, all...
"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 11:19 am
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
Viewing 15 posts - 13,756 through 13,770 (of 22,224 total)