Viewing 15 posts - 6,331 through 6,345 (of 8,416 total)
BrainDonor (1/26/2010)
http://www.sqlservercentral.com/Forums/FindPost853470.aspx
The same message three times in a row - he's determined someone will write it for...
January 26, 2010 at 3:31 am
cmoloto-996602 (1/26/2010)
pls use my table example
Your table example eh? Why didn't you say so!!!
Your table name, no alias (as such)...not easy...not pretty...but:
USE tempdb;
GO
CREATE TABLE dbo.Emp_Details (emp_id INTEGER PRIMARY KEY,...
January 26, 2010 at 3:30 am
Not only is it important to name columns (as opposed to using '*') - it is important to name them and return them in the same order!
Nothing in the 'MAV'...
January 26, 2010 at 2:58 am
Tom.Thomson (1/22/2010)
January 22, 2010 at 6:20 pm
CirquedeSQLeil (1/19/2010)
If you need anybody to review...
Thanks very much, that's very kind of you! 🙂
I hoping to have it finished tomorrow and would appreciate reviews from anyone interested.
Without giving too...
January 19, 2010 at 10:53 pm
Alvin Ramard (1/19/2010)
Paul White (1/19/2010)
Roy Ernest (1/19/2010)
Not much action in THE THREAD this year.... hmmm I wonder what is happening..Trying to finish my first SSC article.
Not a fast reader, eh?
😛
I...
January 19, 2010 at 11:55 am
Roy Ernest (1/19/2010)
Not much action in THE THREAD this year.... hmmm I wonder what is happening..
Trying to finish my first SSC article.
January 19, 2010 at 11:51 am
SQL Learner-684602 (1/14/2010)
(PARTITION BY ACCT_NO ORDER BY ACCT_NO)
That's broadly equivalent to:
(ORDER BY (SELECT NULL))
January 14, 2010 at 5:47 pm
Thank you snu155 for helping out there! I hope Vivek is still reading this and the message has now sunk in.
January 14, 2010 at 5:44 pm
GilaMonster (1/14/2010)I think this is worthy of a blog post, it's complex.
In the meantime, anyone interested in how TOP and OPTION (FAST n) affect the choice of plan made by...
January 14, 2010 at 5:41 pm
Vivek29 (1/14/2010)
Options 1 & 2 are sometimes not possible to do on Production environment.
Why?
Vivek29 (1/14/2010)
If option 3 is true,then its fine.
No, it's a bit silly really. Surely you're not...
January 14, 2010 at 9:41 am
Vivek29 (1/14/2010)
January 14, 2010 at 5:18 am
CirquedeSQLeil (1/13/2010)
Paul is giving away homework answers tonight.http://www.sqlservercentral.com/Forums/Topic846696-338-1.aspx
I don't know what came over me. I have no excuse to offer. :blush:
January 14, 2010 at 1:02 am
January 13, 2010 at 7:24 pm
MVP Adam Machanic has done the work for you:
January 13, 2010 at 7:21 pm
Viewing 15 posts - 6,331 through 6,345 (of 8,416 total)