Viewing 15 posts - 15,286 through 15,300 (of 49,552 total)
Correlated subqueries are not necessarily executed once per row of the outer query (which I assume is where the 'like loops' came from), the one in this query certainly isn't....
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
December 11, 2012 at 8:59 am
SQL will grow one then the other, that's why you see them both growing. They're still used sequentially, the log reader reads sequentially (by LSN), all writes are sequential. There'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
December 11, 2012 at 8:48 am
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
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
December 11, 2012 at 8:43 am
Luk (12/11/2012)
Yes, that's correct, but the index itselft is composed only of that bigint.
No it's not. If you were talking about a nonclustered index, that would be the case, but...
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
December 11, 2012 at 7:50 am
Luk (12/11/2012)
Now, when I run a fragmentation report that particular PK appears twice because it's allocated to both IN_ROW_DATA and LOB_DATA. Why would it be allocated to LOB_DATA?
The table...
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
December 11, 2012 at 7:34 am
Parametrisation is not required for plan reuse. Parametrisation results in better reuse of cached plans, it's not a requirement for any having any reuse at all.
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
December 11, 2012 at 5:55 am
SQLSACT (12/11/2012)
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
December 11, 2012 at 5:41 am
I strongly recommend you do not go this approach of generic delete procedures.
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
December 11, 2012 at 3:36 am
Lokesh Vij (12/11/2012)
Is there some way Logon Trigger be used to ascertain this information.
No. You're not looking for login information, you're looking for database access information. If you were...
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
December 11, 2012 at 2:51 am
That's the best you can do without custom auditing. The information you want is not kept by SQL by default.
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
December 11, 2012 at 2:36 am
CTP - Community technology preview. A pre-release version of SQL 2012 for testing. You don't want those, they're not full versions and they've all likely expired at this point.
If you...
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
December 11, 2012 at 2:34 am
nidhis (12/10/2012)
The batch is big. Can you let me know how how I can check the performance benefits.
Compare duration, CPU and reads as well as the consistency of the performance.
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
December 11, 2012 at 2:32 am
Firstly, turn traceflag 1204 off. It produces the old-style deadlock graph that's very hard to read. With just 1222 on, wait until another deadlock occurs and post the entire deadlock...
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
December 11, 2012 at 2:32 am
Vedran Kesegic (12/10/2012)
Is it really true that the only test centers for MCM in Europe are in Berlin and London?
No. There's 2 in the UK that I know of, hence,...
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
December 10, 2012 at 2:42 pm
When working with large tables:
Retrieve just the data that you absolutely need.
Understand that no one is going to read several million rows, hence do not query several million...
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
December 10, 2012 at 12:49 pm
Viewing 15 posts - 15,286 through 15,300 (of 49,552 total)