Reputation
Top tag
Next privilege 75 Rep.
Set bounties
Badges
1 7
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Oct
29
awarded  Popular Question
Jun
1
awarded  Notable Question
Nov
5
accepted Partition : understanding files and file groups
Jan
27
comment Partition : understanding files and file groups
So this should mean that third option will have more locking issues for highly concurrent systems. Thus not recommended for a table handling concurrent queries. Will there be issue during maintenance (backup, drop/delete a partition) as queries will be on the only available file group ?
Jan
27
asked Partition : understanding files and file groups
Nov
29
awarded  Popular Question
Apr
30
awarded  Commentator
Feb
18
accepted Execution of sequential delete and uncommitted read
Feb
17
comment Execution of sequential delete and uncommitted read
@MartinSmith So.. SELECT (NOLOCK) will not ignore the locks caused by DELETE and will begin execution only after DELETE is committed ? Then probably error is because of some other query as we are not running more than one instance of DELETE ... SELECT parallely acting on same rows.
Feb
17
awarded  Supporter
Feb
17
asked Execution of sequential delete and uncommitted read
Jun
22
accepted Cannot fetch the rowset from OLE DB provider “SQLNCLI” for linked server X
Jun
22
awarded  Editor
Jun
22
revised Cannot fetch the rowset from OLE DB provider “SQLNCLI” for linked server X
added 247 characters in body
Jun
22
comment Cannot fetch the rowset from OLE DB provider “SQLNCLI” for linked server X
The query fetches rows from linked servers to another server. There are many reads which are happening on the linked at the same time. My concern is that could concurrent reads be an on linked server ?
Jun
22
comment Cannot fetch the rowset from OLE DB provider “SQLNCLI” for linked server X
I understand that there is a deadlocked resource. However, this deadlock problem happens only after I get the linked server error.
Jun
22
asked Cannot fetch the rowset from OLE DB provider “SQLNCLI” for linked server X
Feb
14
awarded  Student
Feb
14
awarded  Scholar
Feb
13
asked Effect on performance on retrieval of image column from a table with half a billion records on remote server