Viewing 15 posts - 17,116 through 17,130 (of 49,552 total)
The execution plan if you run that query is an index seek with the predicate "Seek Keys[1]: Prefix: [tempdb].[dbo].[Indexing2].Col4 = Scalar Operator(CONVERT_IMPLICIT(int,[@1],0))"
So there is a conversion, but it's the literal...
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 16, 2012 at 8:41 am
ChrisM@Work (8/16/2012)
but for a CI, there is so much activity associated with a value change that I'm surprised there's no check.
I suspect it's because of the level and point at...
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 16, 2012 at 7:31 am
Sergiy (8/16/2012)
Here we go!"update still occurs" - thank you!
So you agree that the page is written to.
Nope. Two different things.
But as you just agreed - UPDATE with the same...
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 16, 2012 at 7:24 am
Isolation levels, data distribution, execution plans for the select. No direct settings.
If it's a deadlock, it will be detected as such, so the question is why is it just blocking...
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 16, 2012 at 7:07 am
Paul showed that for a heap (the only case in discussion here), the page is not dirtied and the update log record not written when an update occurs that does...
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 16, 2012 at 7:03 am
SQLSACT (8/16/2012)
Shouldn't the usecount for the parameterised plan be 3 because there are 3 queries?
Probably. Why don't you investigate and figure out why it's not 3?
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 16, 2012 at 6:34 am
Sergiy (8/16/2012)
GilaMonster (8/16/2012)
Yes it does.Every time?
I'm not going to be stupid enough to claim each and every case.
The optimisation is going to be looking at the binary value of...
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 16, 2012 at 6:19 am
Please note: 3 year old thread.
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 16, 2012 at 6:01 am
Sleeping connections are not the problem. Ignore them
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 16, 2012 at 5:42 am
What have you done so far, where are you stuck?
For homework and interviews we're happy to guide people, but not to give out answers. You learn nothing if we...
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 16, 2012 at 5:22 am
Because it's blatantly obvious that it's a set question. We don't just give out answers to interview questions, it doesn't help you learn and I don't need the job.
Seriously, create...
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 16, 2012 at 5:21 am
Nothing. Sleeping connections are not a generally problem.
If you have high CPU usage, then investigate high CPU usage.
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 16, 2012 at 5:17 am
Yes.
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 16, 2012 at 5:13 am
Sergiy (8/16/2012)
You miss the point.Once again:
UPDATE testSET name = 'Tom'
WHERE NAME = 'Tom'
Does this one writes into the page?
Yes it does. The optimisation is going to be looking at...
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 16, 2012 at 5:12 am
That still won't work, you're specifying the same ldf for two log files. Each file must have a different file name.
MOVE N'TELE_Log' TO N'D:\Program Files\Microsoft SQL ServerMSSQL10_50.MSSQLSERVER\MSSQL\DATA\TELE_log.ldf',
MOVE N'TELE_1_Log' TO
N'D:\Program Files\Microsoft...
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 16, 2012 at 4:28 am
Viewing 15 posts - 17,116 through 17,130 (of 49,552 total)