Viewing 15 posts - 16,966 through 16,980 (of 49,552 total)
CptCrusty1 (8/24/2012)
--Advanced stuff that is rather obscure.
Just one point here... Unless your aim is to see if the person will make up garbage or admit they don't know, this probably...
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 24, 2012 at 9:16 am
Have you read those three indexing articles yet? If not, please read them, especially the third one.
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 24, 2012 at 5:36 am
Yes, it's used to find the data row.
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 24, 2012 at 4:54 am
That is the output from traceflag 1204. Hard to interpret, missing information.
Please turn traceflag 1204 off (and why is 3226 on? do you know what it does?) and post 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 24, 2012 at 4:46 am
Data row = that which is found in a table (heap or clustered index)
Index row = that which is found in nonclustered indexes.
There are some differences in their details, 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
August 24, 2012 at 4:40 am
No, what would it need to go to the base table for?
The only column you're referencing in your query in Col3, and that's in the index row at the leaf...
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 24, 2012 at 4:28 am
dev.tridib (8/24/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
August 24, 2012 at 4:20 am
If the index satisfies the query completely, why would SQL need to go to the base table?
Please read the articles I referenced.
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 24, 2012 at 4:09 am
SQLSACT (8/24/2012)
Am I missing anything here?
Mainly that the pointer to the rest of the row is the clustered index key (if the base table is a clustered index). Not two...
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 24, 2012 at 3:41 am
Please turn traceflag 1204 off. Why is 3226 on? Do you know what it does?
Once done if you get a deadlock graph from with the output from 1222, please post...
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 24, 2012 at 3:30 am
No contradiction there. What's confusing 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
August 24, 2012 at 3:28 am
Nullified (8/23/2012)
CREATE FUNCTION [dbo].[functionname](
@inputvraiables Datatype
)
RETURNS @tablevariablename table
(
Table columns
)
AS
BEGIN
whatever result data set you want the table variable to hold(Basically select stmts)
RETURN
END
With that form (which...
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 24, 2012 at 1:50 am
Jeff Moden (8/23/2012)
GilaMonster (8/23/2012)
Data archiving. Can't use partition swaps because it's standard edition.Have you considered partitioned views?
Create a new table every month, alter the view to include that and exclude...
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 24, 2012 at 1:47 am
Honestly, if you're a beginner maybe stay away from table-valued functions. They can be performance nightmares used wrong.
They can be used anywhere a table can be used, whether it's a...
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 23, 2012 at 4:33 pm
Not a limitation of SQL Server. Usually caused by inadequate indexing, inefficient code, poor design, mixture of them. That's not a deadlock, what you're describing is simply 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 23, 2012 at 3:36 pm
Viewing 15 posts - 16,966 through 16,980 (of 49,552 total)