Viewing 15 posts - 3,016 through 3,030 (of 7,636 total)
Duplicate post. Please do not cross-post, it's really annoyng.
Please driect all replies here: http://www.sqlservercentral.com/Forums/Topic693657-149-1.aspx
April 8, 2009 at 9:52 pm
Provide the SQL being executed, the Actual Query Plan in sqlplan form (XML), attached as a txt file, and the CREATE TABLE statements scripted from the tables including keys &...
April 8, 2009 at 9:22 pm
Pile On!
And here's another one! This ones a View based on SQL Server 2005 System catalogs:
/*
vwTableInfo - Table Information View
This view display space and storage information for every...
April 8, 2009 at 9:16 pm
Duplicate post. Please do not cross-post, it's really annoying to us.
Please direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic693693-146-1.aspx
April 8, 2009 at 9:05 pm
As long as there are no Table metadata changes, script everything except tables (DROP & CREATE) form QA, and then execute the script on DEV.
April 8, 2009 at 8:57 pm
john.arnott (4/8/2009)
April 8, 2009 at 8:12 pm
Peso (4/8/2009)
April 8, 2009 at 2:35 pm
john.arnott (4/8/2009)
RBarryYoung (4/8/2009)
1) When the rows are "in order", values will monotonically increase left to right and top to bottom.
2) This places implicit restrictions on...
April 8, 2009 at 2:34 pm
First, I think that it is important to understand that this is actually a SQL puzzle or theoretical problem. It is not a real-world problem. As such, the...
April 8, 2009 at 1:23 pm
Peso, the key to my understanding of the problem is the OPs third post back on the first page. Take a look at that and see what you think.
April 8, 2009 at 12:29 pm
Peso (4/8/2009)
But isn't the CorrectSequence based on your understanding of OP's intention?
Yes. I am contending that I have a correct understanding of the OPs intentions.
April 8, 2009 at 12:27 pm
The thing is that the "Left To Right Ascending" property of the columns is just a distraction. It has nothing to do with the actual problem, plus you cannot...
April 8, 2009 at 12:26 pm
Peso, et al:
You could also look at the data from the dataset generator that I supplied. Sort it on [CorrectSequence], if you can understand why that is...
April 8, 2009 at 12:23 pm
Peso (4/8/2009)
I don't get it?
Don't worry Peso, we spent the first three pages trying to figure this out.
Why is that invalid sample data? Columns are ascending from left to right.
Which...
April 8, 2009 at 12:19 pm
Manie Verster (4/8/2009)
April 8, 2009 at 11:48 am
Viewing 15 posts - 3,016 through 3,030 (of 7,636 total)