Viewing 15 posts - 406 through 420 (of 717 total)
tsikma (11/4/2010)
Newbie question alert! I was surprised to see datetime still defining the time, given that style 101 was named. Shouldn't this display only the mm/dd/yyyy?
The CONVERT/101 was...
November 4, 2010 at 11:51 am
Christian Buettner-167247 (11/2/2010)
According to it, there will be a "type conversion". But instead there is only a "type conversion error". Two different things...
I swear I had error in there, sorry...
November 2, 2010 at 9:43 am
Nice question, thanks!
Though I think the explanation left a little to be desired. It isn't just that the decimal type was used, it was that the decimal type was...
November 2, 2010 at 12:16 am
ebaya (11/1/2010)
UMG Developer (11/1/2010)
You might as well make the query an INNER join so that it is more readable, you get the same results:
Actually, that doesn't give the same results...
November 1, 2010 at 12:36 pm
I agree with the previous comments, your second query is no longer a real LEFT JOIN and won't always return the same results as the first query. Maybe in your...
November 1, 2010 at 11:13 am
Thanks for the comments. This was my first QotD and I was worried that my explanation might not have been clear enough. (The formatting is certainly an issue, but I...
November 1, 2010 at 10:16 am
A couple questions:
* Have you re-built all your indexes and statistics since you upgraded the database?
* Are you running SQL Server 2008 R2 CU4? (And have you turned on trace...
October 29, 2010 at 5:23 pm
I too wonder if the intent was to make you think it was the compound "+=" operator that was added in SQL Server 2008. Then the results would be 0,...
October 29, 2010 at 10:05 am
Good information, thanks. But I'm not sure I want to install Excel on the SSIS servers...
October 28, 2010 at 10:04 am
Thanks for the question, though I agree with the other comments about the date string not working for all languages/settings.
October 28, 2010 at 9:55 am
There is no reason that a properly configured DAS (direct attached storage) system like the MSAs can't perform as well or better than a SAN. In my experience with MSAs...
October 25, 2010 at 11:25 pm
Nice question on something most people probably don't know anything about. Thanks!
October 25, 2010 at 11:13 pm
Pam Brisjar (10/25/2010)
INSERT INTO CFARCH01.ArchDB.cf.table (col1, col2, col3)
SELECT DISTINCT col1, col2, col3
FROM ProdDB.cf.table2 as chp
INNER JOIN...
October 25, 2010 at 11:11 pm
Viewing 15 posts - 406 through 420 (of 717 total)