Viewing 15 posts - 53,551 through 53,565 (of 59,068 total)
Heh... dunno... must be a new "feature" than MS built in... 😉
December 15, 2007 at 12:39 pm
Heh... yeah... it's a shame that MS can't figure out the best of both worlds. Having just seen 2k5 for the first time and the apparent mess they made...
December 15, 2007 at 12:10 pm
...the app devs don't need to know anything about the database.
Heh... from where I sit, most of them never did, so no real change. 😉
December 15, 2007 at 12:01 pm
Actually, it's a common problem... take a look at what you have for a "default catalog" when you login... credits to Navy beans says it's "Master".
December 15, 2007 at 11:38 am
Thanks, Matt... I was afraid you were going to say that... yet another highly useful tool shot into the bit-bucket by the idiots that designed the interface for 2k5. ...
December 15, 2007 at 7:34 am
reply me my id bhadirinath@yahoo.com
Heh... that's a bit selfish and we're not your personal consultants... if an answer is determined, it should be posted here for all to see.
There're...
December 15, 2007 at 7:20 am
Any code that needs the word DISTINCT in it, should be highly suspect as the source of a lot of reads... hidden RBAR...
December 14, 2007 at 7:06 pm
Just trying to make sure...
1. Are the 2/3 detail rows in a different table than the "combined" table?
2. If so, are there rows already in the "combined" table...
December 14, 2007 at 6:36 pm
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE Specific_Name = 'Award_Category_Insert'
December 14, 2007 at 6:30 pm
Um... why not just replace all INT with BIGINT in the table declaration? After all, you're already violating the 8060 rule for row size... what's a little more going...
December 14, 2007 at 6:10 pm
1) SQL collations are marked for deprecation
What should you use instead?
December 14, 2007 at 6:06 pm
Or, use BCP with the -m (Max errors) parameter set to some ridiculously high number and the -e (err_file) set to a file name in the same directory. This...
December 14, 2007 at 6:04 pm
Um... be careful... ISDATE() lies almost as bad as ISNUMERIC() is when you try to use it as an ISALLDIGITS function. Sure, the following will allow a conversion, but...
December 14, 2007 at 5:58 pm
Viewing 15 posts - 53,551 through 53,565 (of 59,068 total)