Viewing 15 posts - 6,151 through 6,165 (of 22,219 total)
It sure sounds like something in the network configuration. There's not exactly a lot of variation in how you can type BACKUP DATABASE TO DISK = that's going to result...
"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 7, 2015 at 5:56 am
goldberg.yoni (5/7/2015)
I'm tasked to develop a gaming web application system with relatively large database - it should hold the data about 300 million players, the orders/payment of each player -...
"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 7, 2015 at 5:47 am
If nothing constrains the data in any way, you can have duplicate rows.
"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 7, 2015 at 5:36 am
AER (5/6/2015)
Thanks Grant,Now I am completely lost. I was asking about the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED statement; not a snapshot isolation.
Can you advice please?
Thank you.
Alex
I completely misread...
"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 7, 2015 at 4:33 am
I think I'd go back to Eirikur's suggestion and make sure everything is patched to the same level. That could absolutely lead to this type of behavior ... if there'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 7, 2015 at 4:31 am
T. C. (5/7/2015)
I've looked at the plan again, and the query is left joining to the table that has the index seek/lookup (not every row on the outer side...
"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 7, 2015 at 4:22 am
Not exactly. Snapshot isolation creates a copy of the row while it's being modified. That copy can be read while the modification is occurring. The lock on the table is...
"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 6, 2015 at 4:11 pm
Jacob Wilkins (5/6/2015)
You could...
"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 6, 2015 at 10:21 am
Don't get too hung up on the "narrow" aspect of what makes a good index key. Instead of "narrow" think "as narrow as practical." Then, suddenly, your key structure is...
"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 6, 2015 at 10:14 am
You're getting an RID lookup because the nonclustered index isn't covering and you don't have a clustered index. The BMK that you're referencing is the storage location within the heap...
"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 6, 2015 at 9:58 am
And rereading, You just won't be able to treat the MDF file the way you treated Access files through the Jet engine. It's utterly different. SQL Server is a service...
"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 6, 2015 at 9:41 am
You can't "Open" an MDF file. You absolutely need to do the ATTACH process. But, instead of fighting with the GUI, let's go to the file.
I'm assuming that the original...
"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 6, 2015 at 9:39 am
Sounds likely.
Just so you know, the causality tracking adds an additional value to the events. If any set of events are linked, they'll all have the same value, so 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 6, 2015 at 6:19 am
Joy Smith San (5/5/2015)
Snapshot of the disks is being done by respective team I believe.
So are you saying, we don't need database backups from sql server instance if 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
May 6, 2015 at 4:06 am
When in doubt, refer back to this book by Denny Cherry. Here's an article talking about it too. Read #7. With an AD account, you can set the minimum possible...
"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 6, 2015 at 3:58 am
Viewing 15 posts - 6,151 through 6,165 (of 22,219 total)