Viewing 15 posts - 106 through 120 (of 148 total)
While we're being pedantic...
I would have thought the answer depends on your permissions. If you can't run dbcc showfilestats then both will fail.
February 20, 2012 at 2:03 am
Who was the first person to come up with this (Jeff's) idea in the context of SQL Server? Was it Itzik Ben-Gan?
February 20, 2012 at 1:09 am
@Paul White
-- Seek
SELECT * FROM @Example AS e WHERE ISNULL(col1, 1000) = 5;
I'm just learning this stuff, I don't pretend to know what I'm talking about, and maybe this is...
February 2, 2012 at 3:17 pm
it is tempting to assume that data integrity should always be enforced by the database
Pretty sure that's not the argument. I wouldn't use the word "always". Merely "where possible". If...
January 4, 2012 at 1:41 pm
Thank you, thank you, thank you, Phil.
The question isn't so much about whether constraints are a good idea, it's more about understanding the psychology of developers who don't want to...
December 31, 2011 at 7:01 pm
Under what circumstances would you use one of these on-the-fly solutions as opposed to a permanent calendar table? I'm probably missing something here - it's not unusual - but the...
December 14, 2011 at 12:43 am
The only correct code to return everything for november, nothing less, nothing more, is to use seperate >= and < tests:
WHERE MyDate >= '20111101' AND MyDate < '20111201'
Massive thanks Hugo...
November 17, 2011 at 6:43 pm
If I were to write the query (which was )
SELECT *
FROM #DateTest
WHERE SampleDate BETWEEN @DATE1 AND @DATE2
I would have written it
SELECT *
FROM #DateTest
WHERE SampleDate >= @DATE1
...
November 17, 2011 at 6:21 pm
There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the various symbols for GREATER THAN and...
November 17, 2011 at 10:56 am
Turns out you were totally right. The trace files did hold enough clues to sort out the problem. The problem itself turned out to be a type conversion problem. Ep_id...
October 3, 2011 at 1:51 pm
Great article.
Did anyone else miss snap-to-grid when they took it away?
I have to say, the shared datasets for consistency when using parameters sounds like a great idea.
How about...
September 6, 2011 at 5:55 am
Great article. I'd give it 10/10.
Cheers
September 5, 2011 at 5:47 am
Viewing 15 posts - 106 through 120 (of 148 total)