Viewing 15 posts - 4,081 through 4,095 (of 22,227 total)
It's a bool. It should simply turn off page locking. In fact, when it's turned off, you'll get an error when you try to reorganize the index. Check the "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 17, 2017 at 7:25 am
"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
February 17, 2017 at 7:13 am
Everything Bill has said is 100% correct. I just want to reinforce it.
Proper normalization improves performance. You store smaller amounts of data. This means fewer reads and writes...
"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
February 17, 2017 at 6:36 am
If you're going to do this, use sp_executesql and build out the query and WHERE clause using parameters. As was already mentioned, otherwise you are absolutely opening yourself to 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
February 17, 2017 at 6:24 am
So you 're getting page locks because the engine has determined that there will be too many rows to use row locking. Trying to improve performance by forcing the locking...
"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
February 17, 2017 at 6:21 am
Another mechanism would be to capture logins using Extended Events. Also, you can capture calls against the database using Extended Events.
"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
February 17, 2017 at 6:15 am
Reading back through this set of comments is interesting. It does seem to boil down to the belief, by those who have degrees in CS, that the only true path...
"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
February 16, 2017 at 6:09 am
"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
February 15, 2017 at 8:44 am
Just piling on.
It'll be faster if you use natively compiled. It won't be orders of magnitude faster, but it'll run faster. The question I have, if you have 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
February 15, 2017 at 6:52 am
The thing is, a backup file doesn't have to have any particular extension. You can run a command to backup to a .DOC file or .TXT or any other thing...
"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
February 15, 2017 at 6:48 am
Disco?
But I survived the seventies. Why on earth would I want to go back?
Ah well, I'll start polishing my Hustle skills. I can probably remember the Bus Stop...
"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
February 13, 2017 at 7:48 am
"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
February 13, 2017 at 6:00 am
"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
February 9, 2017 at 11:05 am
"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
February 9, 2017 at 6:03 am
"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
February 9, 2017 at 6:02 am
Viewing 15 posts - 4,081 through 4,095 (of 22,227 total)