Viewing 15 posts - 15,271 through 15,285 (of 22,227 total)
It's down to page splitting as inserts and updates occur, the data may not fit on a given page. At that point the page is split. Half the data remains...
"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
April 29, 2010 at 7:48 am
If this turns out to be gigs, I'm going to cry. I was terribly excited about an 800TB system.
"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
April 29, 2010 at 7:35 am
Stefan_G (4/29/2010)
Paul White NZ (4/28/2010)
kinzent (4/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
April 29, 2010 at 7:18 am
I didn't say it "can't" be 100tb, I said it probably shouldn't be. You can have a tlog hundreds of times the size of your database, but that doesn't make...
"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
April 29, 2010 at 7:15 am
Jeff, or anyone else that knows a heck of a lot more about decimals than I do, please go check this question on Ask.SQLServerCentral. I really don't have a clue,...
"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
April 29, 2010 at 6:59 am
You will need to upgrade that license.
"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
April 29, 2010 at 6:54 am
Guys, go and check this out. Either we have a measuring error or this guy is dealing with the single largest SQL Server installation I've heard about.
He's backing up a...
"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
April 29, 2010 at 6:51 am
You're doing a 100TB log backup in 50 seconds? That's simply amazing right there.
But the question I have is, with an 800TB database (which is about 800 times 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
April 29, 2010 at 6:48 am
Presumably, with an index on the column and the LIKE operator only have a wild card at the end of the string, you have a sargeable (search argument able) 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
April 29, 2010 at 6:43 am
No, waits are not because of inadequate storage. It's because either the network, or the storage system itself, is running slow and causing SQL Server to wait on it. Most...
"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
April 29, 2010 at 6:38 am
First thing I noticed is that you have two table scans, not clustered index scans. Unless you have a very good reason, most tables should have a clustered index. 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
April 29, 2010 at 6:36 am
This is only an issue if SQL Server is sharing that system with other applications. If it is, you're probably going to hit issues because, to put it mildly, SQL...
"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
April 29, 2010 at 6:21 am
david.wright-948385 (4/29/2010)
Another advantage of "create/alter" over "drop/create" is that the latter leaves the database without the object for a (usually short) amount of time.
True, but since it's usually run within...
"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
April 29, 2010 at 6:07 am
Late getting back in, but Paul answered the questions same way I would have, only better.
"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
April 29, 2010 at 6:04 am
It was answered over 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
April 29, 2010 at 6:02 am
Viewing 15 posts - 15,271 through 15,285 (of 22,227 total)