Viewing 15 posts - 12,031 through 12,045 (of 22,224 total)
I'd try uninstalling and then reinstalling.
"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
August 20, 2011 at 1:24 pm
Sounds like some kind of hardware issue. Was the restore run across the network? Might have glitched there. You're using a third party product? Might have been something in there...
"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
August 20, 2011 at 1:23 pm
ajaysanhotra (8/20/2011)
Hi i am curious to know what is the difference betweenCREATE INDEX PIndex ON Persons (LastName) ,
CREATE INDEX PIndex ON Persons (DOB)
AND
CREATE INDEX PIndex ON Persons (LastName,DOB)
You can't...
"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
August 20, 2011 at 1:19 pm
1. What ever process you're using would need to keep track of which index has been done. There's nothing automatic around that.
2. CHECKDB outputs it's results, and yes, you can...
"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
August 20, 2011 at 1:12 pm
I'm pretty sure that FILESTREAM stores individual files, not a single file like a database file. Each time you write a file out to the FILESTREAM, it gets stored out...
"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
August 19, 2011 at 7:44 am
Hold a second. TableB has an identity column. You can't make that a foreign key to another table, it will cause errors because, in theory, you're creating values automatically 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
August 19, 2011 at 7:02 am
skrilla99 (8/19/2011)
Grant Fritchey (8/19/2011)
skrilla99 (8/19/2011)
SELECT dtat.transaction_begin_time,
dtat.transaction_status,
dtat.transaction_state,
...
"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
August 19, 2011 at 6:27 am
skrilla99 (8/19/2011)
SELECT dtat.transaction_begin_time,
dtat.transaction_status,
dtat.transaction_state,
der.blocking_session_id,
...
"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
August 19, 2011 at 6:12 am
This will get you started[/url].
"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
August 19, 2011 at 5:42 am
Here's an introduction to the topic[/url].
"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
August 19, 2011 at 5:41 am
Jeff Moden (8/18/2011)
"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
August 19, 2011 at 5:03 am
Eugene Elutin (8/19/2011)
Jeff Moden (8/18/2011)
"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
August 19, 2011 at 5:00 am
I would focus on the query, the code, not the ANSI settings. That is, unless you have an identical query with a different set of ANSI settings and you're getting...
"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
August 19, 2011 at 4:58 am
EjSQLme (8/18/2011)
Grant Fritchey (8/17/2011)
"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
August 18, 2011 at 4:12 pm
GilaMonster (8/18/2011)
Jim Murphy (8/18/2011)
"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
August 18, 2011 at 5:46 am
Viewing 15 posts - 12,031 through 12,045 (of 22,224 total)