Viewing 15 posts - 7,261 through 7,275 (of 49,571 total)
mario17 (11/18/2014)
Thanks, DeWayneThis works !!!!
Mario
It's also potentially left the database transactionally inconsistent and maybe even structurally inconsistent.
November 19, 2014 at 4:40 am
DBA_AUS (11/18/2014)
sys.databases ->log_reuse_wait_desc LOG_BACKUP
The log is not getting cleared because there's a log backup needed.
DBCC SQLPERF(LOGSPACE) 0.017 % used
However the log is almost entirely empty and is available...
November 19, 2014 at 4:37 am
Can you post the query, execution plan and statistics IO/TIME output?
How many rows is the query returning?
November 19, 2014 at 4:33 am
Innerise (11/18/2014)
So, my question is: Why is SERIALIZABLE being used for these transactions? What other factors would cause a transaction to run SERIALIZABLE?
A SET TRANSACTION ISOLATION LEVEL statement or a...
November 18, 2014 at 12:10 pm
Stefan Krzywicki (11/18/2014)
Why run a credit check on a DBA?
Sysadmin access to a server that processes millions of dollars of transactions a day... (what I had when I worked at...
November 18, 2014 at 7:31 am
SQL Galaxy (11/18/2014)
What witness type do you intend to use for your Windows Server failover Cluster?It means FULL RECOVERY MODE. For data synchronize both database, but I am not sure.
Witness...
November 18, 2014 at 5:59 am
I causally track countries visited (not something which changes fast), and books read per year (well behind on updating that). Not much else.
Countries visited so far: 12 (including one I...
November 18, 2014 at 5:37 am
Urgh.
No, I don't think the trace flag would help. Both automatic and user stats updates run implicitly in read uncommitted, they don't take any locks other than schema stability.
Gut feel,...
November 18, 2014 at 5:29 am
ksatpute123 (11/18/2014)
Here is the MSDN reference:
That's not an MSDN reference, that's a forum, it's no more or less reliable than any other forum. MSDN reference would be one to...
November 18, 2014 at 5:22 am
Update stats doesn't normally take any locks at all. It runs read uncommitted. It could be that something earlier in that session started a transaction and took the lock and...
November 18, 2014 at 4:50 am
Database server. Web servers typically aren't very CPU intensive, and if they become a bottleneck you can add more web servers and a load balancer. SQL however doesn't scale out...
November 18, 2014 at 2:22 am
and the table definition please.
November 18, 2014 at 1:43 am
Lynn Pettis (11/17/2014)
Even in single table queries I recommend using table aliases in the FROM clause and using that alias on the columns in the select list.
I would go...
November 18, 2014 at 1:36 am
Horizontal partitioning is just having multiple tables each storing part of the data with a view 'merging' them.
November 18, 2014 at 1:26 am
Viewing 15 posts - 7,261 through 7,275 (of 49,571 total)