Viewing 15 posts - 706 through 720 (of 8,416 total)
Jeff Moden (4/18/2012)
He's done some awesome testing against some of the new LEAD functionality of SQL Server 2012.
An efficient algorithm out-performs an inefficient one? Who knew! Seriously, the...
April 18, 2012 at 10:57 pm
I quite like the fact the answer wasn't 'maybe' (a.k.a "it depends").
April 12, 2012 at 2:39 am
Hugo Kornelis (4/6/2012)
...Yes, a foreign key constraint can be enforced across databases using triggers. If you refer to the actual meaning of the constraint in a logical model...
This was my...
April 10, 2012 at 8:56 am
Jeff Moden (4/9/2012)
April 10, 2012 at 6:28 am
In fairness, http://msdn.microsoft.com/en-us/library/cc645993.aspx for 2012 does show that "Direct query of indexed views (using NOEXPAND hint)" (in the RDBMS Manageability section) is not available in Express editions (though it certainly...
April 10, 2012 at 5:58 am
Greg Edwards-268690 (3/29/2012)
On my SQL server, they are pretty much the same.But on DB2 on an AS400, not so much.
There though, UPPER('a') = 'A'.
The same, but different.
The same, but different...
March 29, 2012 at 9:57 am
L' Eomot Inversé (3/17/2012)
SQL Kiwi (3/17/2012)
L' Eomot Inversé (3/15/2012)
Maybe you're right Jack. I've picked up some distinctly anti-Paul attitudes from my wife...:blink:
I didn't realise you were that old, Paul. ...
March 17, 2012 at 7:31 am
L' Eomot Inversé (3/16/2012)
BoLSET ANSI_WARNINGS must be...
March 17, 2012 at 12:44 am
L' Eomot Inversé (3/15/2012)
Maybe you're right Jack. I've picked up some distinctly anti-Paul attitudes from my wife...
:blink:
March 17, 2012 at 12:40 am
L' Eomot Inversé (3/16/2012)
March 16, 2012 at 1:33 pm
L' Eomot Inversé (3/15/2012)
March 15, 2012 at 10:14 pm
manub22 (3/14/2012)
The following blog post will give you differences and performance difference b/w ISNULL() and COALESCE()Check link: http://sqlwithmanoj.wordpress.com/2010/12/23/isnull-vs-coalesce/
It's a reasonable summary of what's already in BOL, but again leads the...
March 14, 2012 at 11:57 pm
L' Eomot Inversé (3/13/2012)
If I've understood it correctly, the bug can't happen if isolation level is serializable or...
March 13, 2012 at 11:10 pm
L' Eomot Inversé (3/13/2012)
March 13, 2012 at 8:40 pm
Added a Connect bug report for the documentation error:
https://connect.microsoft.com/SQLServer/feedback/details/731028/coalesce-documentation-bug
March 13, 2012 at 8:37 pm
Viewing 15 posts - 706 through 720 (of 8,416 total)