Viewing 15 posts - 30,751 through 30,765 (of 49,552 total)
Dung Dinh (9/13/2010)
You mean that the key in Clusterd Index will be added implicitly into Non-Clustered Index(s),right?
Yes
How does orderly columns in the Non-Clustered Index impact to WHERE statement?
Did you read...
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
September 13, 2010 at 2:50 am
Please post new questions in a new thread. Thank 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
September 13, 2010 at 2:49 am
Try NOT EXISTS. That'll let you join on your 5 columns.
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
September 12, 2010 at 11:36 pm
Please read through this - Managing Transaction Logs[/url]
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
September 12, 2010 at 11:29 pm
Yes, it'll be a key column if the index is not unique and an include column if the index is unique.
Difference is in column order. If the clustering key is...
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
September 12, 2010 at 11:29 pm
shiv-356842 (9/12/2010)
In simple recovery model does't support point of failure why ?
Because that's the way it's designed
In Full recovery model point of failure is supporting why ?
Because that's the 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
September 12, 2010 at 11:25 pm
Patience, yes, but that poster needs an attitude adjustment. Go back through their older posts.
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
September 12, 2010 at 5:02 pm
Alvin Ramard (9/12/2010)
Alvin Ramard (9/12/2010)
Gail, you might want to bring a certain piece of steel with you if you go revisit that BIT datatype thread.
That OP is now on my...
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
September 12, 2010 at 4:09 pm
WayneS (9/12/2010)
CirquedeSQLeil (9/11/2010)
Anybody else want to try this one?Well, it looks like Gail made a new friend out of it. http://www.sqlservercentral.com/Forums/FindPost984310.aspx.
The phrase "With friends like that who needs enemies" comes...
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
September 12, 2010 at 2:31 pm
CirquedeSQLeil (9/12/2010)
Alvin Ramard (9/12/2010)
Grant Fritchey (9/12/2010)
GilaMonster (9/12/2010)
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
September 12, 2010 at 11:24 am
Can you post the table definitions please? The data types of the columns are going to be important here.
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
September 12, 2010 at 9:06 am
XML? Why oh why?
What's wrong with a properly normalised database design?
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
September 12, 2010 at 5:16 am
Anyone want to take this one up? http://www.sqlservercentral.com/Forums/Topic984249-9-1.aspx I've so far been shouted at and told how I should be helping, and I'm about out of patience and running out...
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
September 12, 2010 at 5:15 am
I don't understand what you want me to give you.
When you create a BIT column in a table, you must decide what the 1 and 0 mean, if they mean...
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
September 12, 2010 at 5:14 am
There's no need to shout at me, and doing so is not going to get you the response that you apparently want! Yelling at someone because you don't like or...
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
September 12, 2010 at 4:07 am
Viewing 15 posts - 30,751 through 30,765 (of 49,552 total)