Viewing 15 posts - 21,286 through 21,300 (of 22,195 total)
Oh yeah, code reviews... and beatings... I forgot about the reviews.
One other option that occurred to me (besides more beatings) was that you could set up the security in the...
January 8, 2008 at 10:47 am
January 8, 2008 at 6:23 am
I think inflicting a severe beating prior to requiring him to rewrite his code is the correct response. But assuming you don't want to risk prison time, you could use...
January 8, 2008 at 6:20 am
You really shouldn't cross-post questions.
I gave a possible answer over here: http://www.sqlservercentral.com/Forums/Topic439862-360-1.aspx
January 8, 2008 at 6:12 am
By "respond in XML" do you mean that your output from the query should be in XML?
If so, look up FOR XML in BOL. That'll get you started.
January 8, 2008 at 6:08 am
You have nesting occuring in triggers on your database. You need to examine the code that is being called and examine the data structure to see what triggers you might...
January 8, 2008 at 5:47 am
Excellent.
But that doesn't explain why a couple of gb file fills up 20gb of tempdb... I still think something else must have been going on.
January 8, 2008 at 5:30 am
Good gosh no, I'm not upset. I just realized that simply saying over and over again "Service Account" wasn't being very clear. So I decided to be clear as crystal....
January 8, 2008 at 5:27 am
I had never heard of that before. Extremely useful information. Thanks for putting it up. Makes the decision to keep hyperthreading off production even better.
January 8, 2008 at 5:19 am
What's the context that the "index group" is mentioned? The only thing I can find referencing is in the dynamic management views for looking at missing indexes. According to Kalen...
January 7, 2008 at 12:13 pm
Are those two seperate fields? If not, ORDER BY with a TOP will get what you want. If what you're trying to do is find all the records for a...
January 7, 2008 at 12:03 pm
I did some tests. For good or for ill, I found that the XML & Table of Numbers worked better than anything else when dealing with large tables and complex...
January 7, 2008 at 10:42 am
You just have to keep the tests honest. I wasn't counting icons and going "Oooh, it's faster." In the simple tests, both processes had a table scan. The one that...
January 7, 2008 at 9:55 am
Very good points. I was just going to start looking up similar solutions in Itzik's books when I saw your post. I figured there was a way to bring a...
January 7, 2008 at 9:15 am
I just tested it on some larger procs. It really is better. Hmmm I'll have to document this one in our best practices doc.
January 7, 2008 at 8:30 am
Viewing 15 posts - 21,286 through 21,300 (of 22,195 total)