Viewing 15 posts - 886 through 900 (of 8,416 total)
jcb (1/30/2012)
I disagree with Kiwi about SET TRANSACTION ISOLATION LEVEL is prefearable since you can put the table hint just at the table needing it...
As I said (in the same...
January 30, 2012 at 7:29 pm
Rob-350472 (1/30/2012)
January 30, 2012 at 7:26 pm
Gianluca Sartori (1/30/2012)
Somebody would say so: http://connect.microsoft.com/SQLServer/feedback/details/714743/copy-table-column-headers-from-ssms-2008The real question is: worth fixing?
I think so. It's not a major thing, but it shouldn't be a very difficult fix, or require...
January 30, 2012 at 7:19 pm
Jack Corbett (1/30/2012)
First, Paul, why an INSTEAD OF TRIGGER? I'm assuming that will have some performance benefit over an AFTER trigger.
That's one of the reasons, yes.
Secondly, since...
January 30, 2012 at 7:16 pm
b5535084 (1/30/2012)
January 30, 2012 at 7:14 pm
patrickmcginnis59 (1/30/2012)
oh c'mon I like the previous version of this post better.
Yes but the humour might not have translated too well, so I thought better of it.
January 30, 2012 at 8:59 am
Try TOP (1) ... ORDER BY inside the APPLY instead of the MAX...HAVING. Happy to explain the performance difference if you can attach the actual execution plans for both...
January 30, 2012 at 8:57 am
Gianluca Sartori (1/30/2012)
Interesting neologism...
I had to look that word up. It's not that new though, been around at least 10 years...http://www.davegorman.com/projects_googlewhack_adventure.html
January 30, 2012 at 8:51 am
Gianluca Sartori (1/30/2012)
I guess we just found a bug! I just tried this and I get an exception...
Same in the latest SQL Server 2012...
January 30, 2012 at 8:45 am
What problem are you trying to solve here?
January 30, 2012 at 8:27 am
Gianluca Sartori (1/30/2012)
BTW, Google indexes scarily useless things: 😉
Wow. It's a Googlewhack too.
January 30, 2012 at 8:26 am
Fal (1/30/2012)
January 30, 2012 at 8:24 am
elogen (1/30/2012)
Thanks for the suggestion, but I think that my problem doesn't actually have anything to do with how I've defined my function.
It really does, but the reasons are interesting....
January 30, 2012 at 8:19 am
Maxer (1/30/2012)
I know I could query the system tables to return all the columns in a table, but what I want to do is effectively:
SELECT TOP (0) * FROM TableName
January 30, 2012 at 7:44 am
GilaMonster (1/30/2012)
No, using nolock on every single query 'just because' is not good practice. There are places it's fine and...
January 30, 2012 at 5:26 am
Viewing 15 posts - 886 through 900 (of 8,416 total)