Viewing 15 posts - 2,461 through 2,475 (of 6,036 total)
Jeff Moden (7/2/2009) Andrew already did exactly what I would do...
I would not.
There was a member of Led Zeppelin, John Paul Jones.
Would not be happy seeing his name after...
July 5, 2009 at 9:29 pm
Try this:
insert into T1
select 'Sam' -----<<<<<Not a dupe
insert into T1
select 'Ammy' -----<<<<<Not a dupe
July 1, 2009 at 10:26 pm
Wow, never used it in 2000 ages. Considered it as 2k5 introduction.
Did not even try.
[_] always worked without any problem.
June 17, 2009 at 3:09 pm
GilaMonster (6/17/2009)
If you want the underscores to be treated as literals rather than wildcards, you need to escape them.
SELECT class_code FROM tbl_class WHERE class_code LIKE 'ep/_f/_%' ESCAPE '/'
You should be...
June 17, 2009 at 2:38 am
Here it is:
SET STATISTICS IO ON
SET STATISTICS TIME ON
DBCC FREEPROCCACHE
SELECT IsEven,SomeValue FROM InequalityTest
WHERE IsEven=1 AND SomeValue Between 10000 and 20000
DBCC FREEPROCCACHE
SELECT IsEven,SomeValue FROM InequalityTest WITH (index(idx_1))
WHERE IsEven=1...
June 16, 2009 at 7:46 am
Add SET ARITHABORT ON to the query you call from Excel.
June 16, 2009 at 5:28 am
To add to the picture.
I decided to force using index idx_1:
SET STATISTICS PROFILE ON
DBCC FREEPROCCACHE
SELECT * FROM InequalityTest
WHERE IsEven=1 AND SomeValue Between 10000 and 20000
DBCC FREEPROCCACHE
SELECT *...
June 16, 2009 at 5:13 am
Gail,
I'm not sure how bad is SQL2005, but my experience is built on SQL2000 real life scenarios and it quite contradicts your statement.
Because it's actually SQL2000 forum, I allowed myself...
June 16, 2009 at 5:01 am
GilaMonster (6/12/2009)
Sergiy (6/11/2009)
Christopher Stobbs (6/11/2009)
Index should be: (BitField, DateField).If BitField is really a BIT field then it cannot be included into an index.
Sure it can. It's only the LOB data...
June 13, 2009 at 7:28 am
Jamie Batiste (6/12/2009)
the largest data size of any row is 1800 bytes.
Change column definitions then.
June 12, 2009 at 7:10 am
You must hve a row (rows) where those 2 fields indeed exceed the limit.
That's why index creation fails.
June 12, 2009 at 6:48 am
Christopher Stobbs (6/11/2009)
Index should be: (BitField, DateField).
If BitField is really a BIT field then it cannot be included into an index.
And if it's not it should not really be used...
June 11, 2009 at 3:09 pm
Lynn Pettis (6/10/2009)
Double check for me, but I think the code in the original post is missing a group by. I didn't catch that as I reformatted the code....
June 10, 2009 at 10:11 pm
Viewing 15 posts - 2,461 through 2,475 (of 6,036 total)