Viewing 15 posts - 181 through 195 (of 211 total)
If you're getting a *lot* of timeouts there's another reason to be wary of using read committed snapshot: your tempdb could get rather large (a lot of timeouts might mean...
June 7, 2011 at 3:03 am
There's also information_schema.routines if you're an ANSI fan, but watch out for long definitions.
June 7, 2011 at 2:57 am
colin.Leversuch-Roberts (6/3/2011)
Yeah,...
June 7, 2011 at 2:41 am
TheSQLGuru (6/3/2011)
allmhuran (6/2/2011)
Ooh, I like number 4 (but I doubt I can get away with it 😉 )
Does that mean you are afraid it will harm performance of server (it...
June 7, 2011 at 2:34 am
Ooh, I like number 4 (but I doubt I can get away with it 😉 )
June 2, 2011 at 10:12 am
Yes, and maintenance plans run every night (reorg and update stats)
June 1, 2011 at 8:36 pm
The server is (almost but not quite exclusively) for the hosting of an ERP system (third party). The upgrade was an in-place upgrade of the cluster. So yep, all objects...
June 1, 2011 at 2:54 am
Indeed Mr Moden, I've just talked to the dev who has told me that blank, null AND as it turns out zero all mean the same thing in the domain...
May 29, 2011 at 5:13 pm
Yep, same server, same instance, just different databases (the demonstration code in the first post covers it: 3 part name only, no linked servers involved, just switching database contexts).
I'll get...
May 29, 2011 at 8:24 am
"You mean an 8% increase in performance with 44% less typing? Don't you wish you could do that everywhere?"
SOLD!
January 20, 2011 at 5:59 am
Cheers, it's 90% mojoportal's doing though. My work is only the banner and content!
I tried DotNetNuke as well but it was slower and bulkier.
January 19, 2011 at 5:42 am
I have created the website and made the addin and source code available:
January 19, 2011 at 3:59 am
Your DDL isn't very descriptive. Did you create the database? Column names like IDn, Fieldn are very hard to work with as a developer. You also haven't shown any keys...
January 15, 2011 at 11:33 pm
Thanks for your feedback all. After sleeping on it I have decided to release the addin and code under the GNU GPL and set some recommended donations for different types...
January 15, 2011 at 11:26 pm
I agree that it may be detrimental but I will not delete it, because I believe it to be an unfortunate truth (as I wrote: in general. Not necessarily for...
January 15, 2011 at 9:06 am
Viewing 15 posts - 181 through 195 (of 211 total)