Viewing 15 posts - 20,686 through 20,700 (of 21,975 total)
Oh great, I'm not schizophrenic enough. Now I have to figure out the order in which to read posts.
:w00t::w00t::w00t::crazy::sick:
March 6, 2008 at 9:15 am
It's behaving pretty strangely over all. I'm seeing multiple alerts for discussions that don't appear to have any new posts at all.
March 6, 2008 at 9:09 am
First, NOT IN usually doesn't perform as well as an OUTER JOIN, so I'd change that right away. Second, you can check to see that values are a number by...
March 6, 2008 at 9:06 am
Only because he wanted to return the values and lock them down from other users. So I did the SELECT with the update lock first, then udpate the table to...
March 6, 2008 at 6:22 am
Also, on the SELECT...INTO vs. CREATE TABLE & SELECT question. That one depends too. It depends on whether or not you are going to create indexes or in any other...
March 6, 2008 at 6:11 am
Matt Miller (3/5/2008)
Jack Corbett (3/5/2008)
Matt Miller (3/5/2008)
It looked something like:
Matthew Miller
Senior Software Architect, O.D.A.A.
After I had been using it...
March 5, 2008 at 11:31 am
Or in this case, six months experience repeated 16 times.
Sorry, I'm frustrated. I've got stacks & stacks of interview sheets with little x's next to questions that people with more...
March 5, 2008 at 9:38 am
If it's one more, then you've got extra stuff in there. Try using DATALENGTH in the query instead & see how that works.
March 5, 2008 at 9:30 am
Jeff Moden (3/5/2008)
Grant Fritchey (3/5/2008)
March 5, 2008 at 9:23 am
Yeah, I was thinking about posting the same thing. Accurate statistics are way too important for getting good execution plans.
March 5, 2008 at 9:13 am
Hmmm, maybe non-printing characters.
See if this returns different values than the LEN statement.
SELECT DATALENGTH('testfolder/test.aspx')
That might be the issue.
March 5, 2008 at 9:11 am
Matt Miller (3/5/2008)
Grant Fritchey (3/5/2008)
March 5, 2008 at 9:03 am
Nope. Can't do it.
There are a lot of third party tools for this, free, cheap & expensive. Personally, I use Red Gate SQL Prompt & SQL Refactor. Between the two,...
March 5, 2008 at 8:29 am
If the emailaddress is the primary means of accessing this table, then yeah, I'd make it the clustered index. If you have it as a unique non-clustered index, you'll have...
March 5, 2008 at 8:24 am
Viewing 15 posts - 20,686 through 20,700 (of 21,975 total)