Viewing 15 posts - 18,676 through 18,690 (of 22,202 total)
Ninja's_RGR'us (1/17/2009)
Since when reading the full question a requirement of posting an answer?
😀
Maybe it's time to...
January 17, 2009 at 5:11 am
GilaMonster (1/17/2009)
http://www.sqlservercentral.com/Forums/FindPost638650.aspx
Question was "I didn't start an explicit transaction, I don't have a backup, how do...
January 17, 2009 at 5:09 am
Jean-François Bergeron (1/16/2009)
Why? Is it quicker to do a coalesce over a IsNull?And why not in a where clause?
Cheers,
J-F
It's just because I find COALESCE easier to read. I don't think...
January 16, 2009 at 1:08 pm
gyessql (1/16/2009)
Ya, you are right Grant. I was thinking in terms of Course_desc (considering it being unique) and AccountId, totally forgot about CourseID. My bad!!
But if he did go with...
January 16, 2009 at 1:06 pm
Can you post the execution plan for the original query?
January 16, 2009 at 12:55 pm
When you're not using it in a WHERE clause or a JOIN, COALESCE
January 16, 2009 at 12:54 pm
gyessql (1/16/2009)
Grant Fritchey (1/16/2009)
January 16, 2009 at 12:35 pm
You could make the Course and Unit pk into a compound PK that includes AccountId. Then the UnitCourse table will have an added column used as a constraint against each...
January 16, 2009 at 10:43 am
mike.sortino (1/16/2009)
January 16, 2009 at 7:12 am
Paresh Prajapati (1/16/2009)
But page lock is lock all other rows which is not required to be lock, so other process which has require those rows then it is not geninune..
Yes,...
January 16, 2009 at 7:03 am
For all those people who want employees treated "fairly" you'll need to define "fair." Does it mean identical, in that, all DBA's are paid 30K? Does it work of seniority,...
January 16, 2009 at 6:42 am
If you're getting this sophisticated with dynamic SQL, then you really need to look into sp_executesql instead of simply using the exec statement. sp_executesql will allow you to define parameters...
January 16, 2009 at 6:35 am
I wish it was available online, but if you can track down the final copy of the SQL Standard, I wrote an article comparing TOP, MAX and ROW_NUMBER as a...
January 16, 2009 at 6:23 am
Regarding Performance: It depends, but yes, CROSS APPLY can be used in place of an INNER JOIN in some situations to realize a performance benefit. It's only going to work...
January 16, 2009 at 6:15 am
I'm hoping we can get it to 100 pages. Then it should die. Horribly. Suffering.
January 16, 2009 at 6:05 am
Viewing 15 posts - 18,676 through 18,690 (of 22,202 total)