Viewing 15 posts - 8,026 through 8,040 (of 49,552 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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.... 🙁
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2014 at 2:31 am
Doesn't matter at all (providing you aren't using SQL 2000)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2014 at 12:49 am
Viewing 15 posts - 8,026 through 8,040 (of 49,552 total)