Viewing 15 posts - 8,026 through 8,040 (of 49,571 total)
mishrakanchan86 (8/22/2014)
So is there a way i could run this transaction in a way that the read on table B remains unlocked
Snapshot or read committed snapshot isolation levels should work....
August 22, 2014 at 12:35 pm
TomThomson (8/22/2014)
Haven't noticed him recently on SQLServerCentral, though :cool:.
He dropped in recently to state that indexes were only needed in badly designed databases.... 🙁
August 22, 2014 at 12:26 pm
Robert Frasca (8/22/2014)
That must be the Database Name that is filtered on by Profiler rather than the fully qualified database name referenced in the query.
That's exactly what it's doing. The...
August 22, 2014 at 12:24 pm
Robert Frasca (8/22/2014)
I have one filter to include my specific database name, i.e. LIKE 'DatabaseName'
There's the problem.
Take that filter out, the event will then show up and you can...
August 22, 2014 at 7:56 am
shahtisaipur (8/21/2014)
the error is myfile.mdf is not a primary database file. (SQL server , error 5171)
With that error, restore from your last good backup. That error suggests that the file...
August 22, 2014 at 6:59 am
mario17 (8/21/2014)
Dealing with some sp code where I have left join without predicate and it still works !!!!! Comments says : Optimization (?).
I surely thing...
August 22, 2014 at 5:25 am
Maybe related.
At the same time that problem started, some threads started getting things like <!-- 864 --> in their title.
August 21, 2014 at 9:53 am
mlueke (8/21/2014)
This table is deleted and refilled by a job which runs at night, so there are no other queries which will be blocked during this Table hint.
Then truncate it...
August 21, 2014 at 5:27 am
mlueke (8/21/2014)
Alter Table dbo.test REBUILD whicht did the job just like a clustered index would... August 21, 2014 at 4:16 am
No to all
Timeout is not a SQL concept, so it wouldn't store that anyway. Timeout occurs when the application decides it's waited too long and signals SQL to stop processing....
August 21, 2014 at 3:19 am
Same way you'd shrink a log in a non-relicated database. DBCC ShrinkFile.
Same comments as always when shrinking a log. Don't unless the log has grown due to some unusual operation...
August 21, 2014 at 2:34 am
ReamerXXVI (8/21/2014)
Is there some literature I can read up on that explains why it doesn't matter?
Order doesn't matter because they're independent operations, they don't interfere or interact with each other,...
August 21, 2014 at 2:31 am
Doesn't matter at all (providing you aren't using SQL 2000)
August 21, 2014 at 1:18 am
anoosha.konaparthi (8/20/2014)
Again getting the same error after executing the above
Please run just the following, post the full and complete, unedited output and I'll be able to give you useful advice....
August 21, 2014 at 12:51 am
copper_sunflower (8/20/2014)
If you don't, then you may use REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS parameters in DBCC CHeckdb to try to fix the corruption.
No, please no. We don't yet know exactly what's...
August 21, 2014 at 12:49 am
Viewing 15 posts - 8,026 through 8,040 (of 49,571 total)