Viewing 15 posts - 8,086 through 8,100 (of 22,224 total)
I'd also suggest going with the schema.
Or, if you have to name the tables, I'd go with naming them MyTableStaging or something like that instead of using old school Hungarian...
"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 23, 2014 at 7:52 am
That would be a job, if you have one, that is scheduled, by you the DBAs, to rebuild indexes to remove their fragmentation.
"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 23, 2014 at 7:50 am
BWFC (5/23/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 23, 2014 at 7:31 am
srikantmeister (5/21/2014)
also try tuning adviser recommendation for whatever query...
"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 22, 2014 at 6:58 am
Maybe there's been a recent data removal. That would shrink the size of the backups.
"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:08 pm
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
Viewing 15 posts - 8,086 through 8,100 (of 22,224 total)