Viewing 15 posts - 391 through 405 (of 454 total)
Joe Celko (3/16/2010)
Excellent piece of work!I wonder how "MAX(sale_date) OVER (PARTITION BY product_nbr)" would do?
It depends.
C'mon, someone had to say it! ; )
Dave62 (3/16/2010)
March 16, 2010 at 9:14 am
wall str33t (3/11/2010)
A better question might be is there a difference between count(*) and count(col).Many people don't know the subtleties between them.
Rather than re-answer that question, I'll provide a...
March 11, 2010 at 9:01 am
From your editorial, I expected Buck Woody's post to be quite different from what it was. His focus is on generic tools that write code (i.e, code written by someone...
March 10, 2010 at 8:30 am
sjimmo (3/9/2010)
March 9, 2010 at 7:35 am
jinlye (3/9/2010)
From the article:
It might take a few more years before all of the existing SQL Server 2000 applications are upgraded to newer versions of SQL Server.
SQL 2000 SP4...
March 9, 2010 at 7:23 am
Rune Bivrin (3/8/2010)
March 8, 2010 at 8:30 am
I've done a lot of SQLXML programming with simple queries in XML files and XSLT files to transform those query results to HTML pages. I used CONVERT a lot to...
March 8, 2010 at 8:22 am
shan plourde (3/2/2010)
Why a surrogate PK in the User/Group table?
Edit: I misread your question as "tables" and explained why I would want ones in the User and Group tables, respectively....
March 2, 2010 at 7:49 am
Dietmar Weickert (2/26/2010)
No info about indices on the table/view to be queried? Who could potentially know about SARGable operators. And even if there were this information, who is able to...
February 26, 2010 at 7:57 am
Elliott W (2/17/2010)
Clive Chinery (2/17/2010)
Steve Jones - Editor (2/17/2010)
I do think it's unfair that we cannot buy an older product that meets our needs.I agree.
Doesn't this exist outside the...
February 17, 2010 at 12:26 pm
john.arnott (2/11/2010)
<rant on> I can't imagine that 85% of respondants actualy knew the result of the SELECTwhere the condition is false would not be assigned to the variable. </rant>
What...
February 12, 2010 at 9:08 am
Samuel Vella (2/10/2010)
Storage is cheap, CPU cycles wastes energy!
I take it you've never compared the power usage of even a small SAN to that of a midsized database server... Storage...
February 10, 2010 at 7:49 am
Martin Vrieze (2/9/2010)
February 9, 2010 at 7:11 am
Very good question. You can find some documentation supporting this behavior here:
http://msdn.microsoft.com/en-us/library/aa933206(SQL.80).aspx
Specifically:
If execute_statement is used with INSERT, each result set (my emphasis) must be compatible with the columns in...
February 4, 2010 at 12:55 pm
To be strict, the source data was a red herring. A where clause shouldn't be based on the data you have, but the data you want.
In this case, for example,...
February 1, 2010 at 7:15 am
Viewing 15 posts - 391 through 405 (of 454 total)