Viewing 15 posts - 17,836 through 17,850 (of 49,552 total)
coronaride (7/3/2012)
So, I can go and create the non-clustered unique index leaving the table online, then just add the constraint QUICKLY afterwards.
Err... No.
When you create a constraint, SQL creates 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
July 3, 2012 at 11:51 am
I give up.
p.s. You've got missing indexes. Don't know how much one would help because I'm really not in the mood for figuring out the text version of a plan.
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
July 3, 2012 at 11:48 am
No, what they're saying is that when you create a constraint (unique or primary key), SQL creates an index associated with that constraint to enforce the uniqueness requirement.
The only way...
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
July 3, 2012 at 11:15 am
Charles Kincaid (7/3/2012)
The first time that you JOIN it won't matter anyway.
Any time at all that you query the index's order is irrelevant. Join or no join.
I'm just sick 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
July 3, 2012 at 11:02 am
Then honestly you should take that requirement back to the person who gave it to you and get some clarity on why exactly they find it essential to send 35...
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
July 3, 2012 at 11:00 am
hindle.steve (7/3/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
July 3, 2012 at 8:32 am
n00bDBA (7/3/2012)
From what i read if a app runs Truncate table, then it would break the the secondary version of the database as it wouldn't be in transaction log.
Truncate...
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
July 3, 2012 at 7:18 am
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
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
July 3, 2012 at 6:28 am
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
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
July 3, 2012 at 6:27 am
ashokeie (7/3/2012)
Index name ...
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
July 3, 2012 at 6:25 am
It's not even guaranteed after a create or rebuild. Try rebuilding an index and checking the fragmentation. If it's not exactly 0 then that freshly built/rebuilt index is still not...
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
July 3, 2012 at 6:25 am
Brandie Tarvin (7/3/2012)
Anyone got a fresh brain I could borrow? I promise to return it with only a slight bit of wear.
Sure. Will you finish off my article and config...
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
July 3, 2012 at 6:14 am
e-ghetto (7/3/2012)
Clustered indexes define the logical order of the table
I would say: Clustered indexes define the physical order of the table. Am I right?
No. They define the logical order only.
If...
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
July 3, 2012 at 6:13 am
Execution plan as a .sqlplan file. Please.
Also why are you returning 35 million rows to the client? No one will ever read that volume of data
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
July 3, 2012 at 6:12 am
I can reproduce eager spools in a hundred ways, but that's not the point. I want to see what the OP is doing so I can advise on exactly his...
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
July 2, 2012 at 11:51 am
Viewing 15 posts - 17,836 through 17,850 (of 49,552 total)