Viewing 15 posts - 20,911 through 20,925 (of 22,196 total)
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 for...
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
FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could describe the...
March 5, 2008 at 7:49 am
select right('testfolder/test.aspx',len('testfolder/test.aspx') - charindex('/','testfolder/test.aspx'))
March 5, 2008 at 7:44 am
It's not hard & fast or black & white. In general terms, using a temp table is not bad. It depends on what you're doing with it and how it's...
March 5, 2008 at 7:12 am
allenrlewis (3/4/2008)
Could you give me a little example that would work on like a Northwind or something.Likethe tsql statement so I can test the theroy.
I'd have to experiment a bit...
March 5, 2008 at 6:25 am
I'm not questioning you, per se, but surely there's a DBA "it depends" on the end of a statement that says maintaining extra indexes makes no difference at all. It...
March 5, 2008 at 6:09 am
Viewing 15 posts - 20,911 through 20,925 (of 22,196 total)