Viewing 15 posts - 12,751 through 12,765 (of 49,552 total)
When the connection that ran the SET closes.
June 14, 2013 at 8:34 am
If you are running under serialisable isolation, all locks are held until the end of the transaction (and there will be a lot of locks). Hints go on queries, not...
June 14, 2013 at 8:20 am
dwilliscp (6/14/2013)
1) the example shows a set... begin.. comit. So once the commit is done the set command ends?
No, it's a session-level setting. It persists til you set otherwise or...
June 14, 2013 at 8:14 am
m.rajesh.uk (6/14/2013)
Gail you are talking about SQL 2014 .. does it released or what...
Google not working?
June 14, 2013 at 7:38 am
PaulB-TheOneAndOnly (6/14/2013)
No SQL Server 4.2? 6.0? 6.5? 7? on the poll? that's discrimination! 😛
No SQL Server 2014 either. 🙁
June 14, 2013 at 7:19 am
SET TRANSACTION ISOLATION LEVEL is used to set one of the 5 isolation levels:
READ UNCOMMITTED
READ COMMITTED
REPEATABLE READ
SERIALIZABLE
SNAPSHOT
The syntax is described at http://msdn.microsoft.com/en-us/library/ms173763.aspx
What you listed there are locking hints which go...
June 14, 2013 at 7:12 am
Please post table definitions, view definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 14, 2013 at 7:12 am
sqldkay (6/14/2013)
But then my next Q; What is considered normal and abnormal?
Normal = normal for your system
Abnormal = not normal for your system.
If a query runs normally 2 minutes and...
June 14, 2013 at 6:30 am
SQLSACT (6/14/2013)
A bit off topic but I stay away from using BCHR as a performance metric - It's extremely unreliable.
It's not that it's unreliable, it's that it can have...
June 14, 2013 at 6:24 am
Service pack, no, probably not. Is this a 32-bit instance?
June 14, 2013 at 6:21 am
There's no magic threshold where below that it's fine and above that it's bad. There's only normal for your system and abnormal for your system.
June 14, 2013 at 6:14 am
Above post edited heavily, take another read through it.
One more thing, as I mentioned I enabled AWE, how much time it took to take in effect ? According to my...
June 14, 2013 at 6:01 am
Investigate the queries running against the instance. Identify why they're reading so much data
Edit: Sorry, originally read that as plan cache hit ratio, ignore what was here before...
Low buffer...
June 14, 2013 at 5:40 am
The statistics are associated with the index (they have the same name). The only way you can drop those is to drop the index, to recreate the stats, you would...
June 14, 2013 at 2:48 am
Viewing 15 posts - 12,751 through 12,765 (of 49,552 total)