Viewing 15 posts - 8,086 through 8,100 (of 22,219 total)
The same question was posted over on AskSSC. The answer is the same here. There's no filtering of any kind, so you're guaranteed to get scans. If you're running some...
"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
May 21, 2014 at 1:06 pm
You don't need a plugin to implement extended events in 2008, there's just no GUI. You'll have to write queries to start it, stop it, set it up an consume...
"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
May 21, 2014 at 1:04 pm
3gb of RAM for SQL Server and your application? That's an extremely small amount of memory to run SQL Server 2008 within. You must be seeing contention on resources.
"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
May 21, 2014 at 1:01 pm
And NEWSEQUENTIALID doesn't prevent all fragmentation, it just reduces the level of fragmentation to less than what you'll see with NEWID.
"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
May 21, 2014 at 7:50 am
TomThomson (5/20/2014)
Grant Fritchey (5/20/2014)
Lynn Pettis (5/20/2014)
vasugunda (5/20/2014)
in between 200 to 250 usdvasugunda (5/20/2014)
no per monthThat would work out to about 2 hours of assistance each month.
Consultants aren't cheap.
You need 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
May 20, 2014 at 3:41 pm
TheSQLGuru (5/20/2014)
Grant Fritchey (5/20/2014)
"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
May 20, 2014 at 1:21 pm
lkennedy76 (5/20/2014)
nimalatissa (5/19/2014)
"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
May 20, 2014 at 1:20 pm
Lynn Pettis (5/20/2014)
vasugunda (5/20/2014)
in between 200 to 250 usdvasugunda (5/20/2014)
no per monthThat would work out to about 2 hours of assistance each month.
Consultants aren't cheap.
You need to charge more. That's...
"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
May 20, 2014 at 1:18 pm
muthyala_51 (5/20/2014)
As once the database has been migrated to 2014- can i take the backup of 2014 database and restore to 2008?
No. You can never restore a database down 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
May 20, 2014 at 1:15 pm
yuvipoy (5/20/2014)
GilaMonster (5/20/2014)
No, the fragmentation will be the same, both are having NEWID() specified as the value so the default is being overridden.
No Gail
I checked it ...there is less frag...
"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
May 20, 2014 at 4:31 am
Chances are you didn't run the restore with the syntax KEEP_CDC. In this event, even though, as Kevin says, the backup includes the CDC tables and data, they're removed during...
"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
May 20, 2014 at 4:26 am
You'll have to let the identity values be regenerated by the system that you're moving everything into. You can capture the new values using the OUTPUT clause. With that 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
May 20, 2014 at 4:22 am
And do you know that NOLOCK can lead to getting incorrect data as well as extra or missing rows? It's a somewhat dangerous operation unless you're sure you can afford...
"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
May 20, 2014 at 4:18 am
If you have lost the database or it's been corrupted and you don't have a backup available, you'll have to rebuild the database. Microsoft has documentation on how 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
May 20, 2014 at 4:15 am
Why doesn't backup work?
Because my other suggestion is mirroring and that requires a backup and restore as well.
"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
May 19, 2014 at 3:37 pm
Viewing 15 posts - 8,086 through 8,100 (of 22,219 total)