Easy enough to say... what formula would you use to return the following...

Jack Corbett (11/18/2008)

---

Now that you mention it I do recall, but I still think it is a foolish requirement and impediment to success. You'd be done by now if...

Must look eye... let the code be the teacher...

SELECT [font="Arial Black"]CASE WHEN N IS NULL THEN 5 ELSE 4 END, N[/font]

FROM

(

SELECT N

from Tally

where N < 11

UNION ALL

SELECT NULL

) X

ORDER...

ALZDBA (11/18/2008)

---

presentation ....... should be handled by the front end application !

(and preferably client side)

Do not bother sqlserver with how you want things actually presented for the human eye.

One...

No... I'm not talking about "growth" rates.... I'm talking about setting the database size correctly so it never has to grow. Database growth should never take you by surprise...

Now that you have a couple of answers, please...

If you set a column as a DATETIME datatype, and the data put into that column is in the YYYYMMDD format, no conversion is necessary... it'll just work because of...

Heh... you guys are missing it... OP wants to know why performance IMPROVED so much after the upgrade so they can go back to the original database and make it...

I agree... do an estimate to figure out what the total size should be with a year of data and add 20 to 25% to that number. Set the...

If they're all like the one you posted with a couple of cursors calling another sproc that probably has another cursor in it, you could be in for some real...

Please post what you tried so we can see things like what you tried to GROUP BY. Thanks.

The data should actually match the table definition... instructions in the atricle everyone has posted would really make this easy.

Msg 515, Level 16, State 2, Line 3

Cannot insert the value...

metro17 (11/18/2008)

---

I have 2 tables . Dept and Names . Now I need to grant access to 1 person in Names table on 1 department row in the Dept table...

Still, thanks for the thought.

I've got a hell of a lot of comments to make about this article... but, let me summarize, instead...

[font="Arial Black"]"Oh... very well done. Should be required reading for everyone...