'Twas the week before launch, when all through the cubes,
Not a geek was sleeping, not even the slouch;
The servers were stacked in the rack with care,
In hopes this project's end soon would be there.
Community
Community
Puzzled by T-SQL: A Tip Regarding Forcing Join Algorithms
Itzik describes a tip he learned from Umachandar Jayachandran regarding forcing join algorithms.
www.sqlmag.com/Article/ArticleID/97844/97844.html
Why would SELECT @@SERVERNAME return different values than SELECT SERVERPROPERTY('ServerName')?
For answers, go to
sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=88287&enterthread=y
How can BikuMahatre determine which isolation level a transaction is running in?
For answers, go to :
sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=82&threadid=88535&enterthread=y