Viewing 15 posts - 106 through 120 (of 149 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.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 20, 2012 at 1:09 am
Add the sale string
The SALE string? This confused me! 😛
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 8, 2012 at 11:55 pm
@paul-2 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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 2, 2012 at 3:17 pm
You're both committing unnecessary RBAR.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 11, 2012 at 10:52 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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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
...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
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...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
September 6, 2011 at 5:55 am
Great article. I'd give it 10/10.
Cheers
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
September 5, 2011 at 5:47 am
Viewing 15 posts - 106 through 120 (of 149 total)