Viewing 15 posts - 91 through 105 (of 325 total)
You may be interested in reading one of my posts, which explores the use of EXECUTE...AT clause for executing queries against linked servers: http://beyondrelational.com/blogs/nakul/archive/2011/01/10/executing-queries-against-linked-servers.aspx
February 26, 2012 at 11:21 pm
SQL Kiwi (2/1/2012)
honza.mf (2/1/2012)
I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.:laugh: I like it!
I like it too! 🙂
February 1, 2012 at 1:25 am
I disagree with the answers (2nd time in the same week). Here's why:
3. A hint overrides a SET option
4. A database option overrides an instance option and a SET option...
January 31, 2012 at 10:33 pm
The way I interpreted the question, it was all about whether or not computed column definitions can contain references to columns of other tables. The answer, according to Books On...
January 31, 2012 at 2:59 am
It's pen & paper for me. I carry a notebook/diary that lists the day's tasks and on the adjacent page, I note down my own time log. During meetings, notes...
January 31, 2012 at 2:31 am
Good question (it's often a challenge to achieve both - space & performance), but it looks like the mapping of the options and the answers is incorrect.
The correct answer is...
January 23, 2012 at 2:15 am
Thank-you! Everything seems to be in order based on the screenshots you provided.
I came across this Connect case (http://connect.microsoft.com/SQLServer/feedback/details/351315/books-on-line-succesfully-installed-are-not-accessible), wherein the issue was resolved by uninstalling and reinstalling the client...
January 4, 2012 at 9:44 pm
You may want to go to SSMS -> Tools->Options->Help and verify that you are using the correct settings against a working environment.
January 3, 2012 at 11:32 pm
This was a good one! Thank-you, Paul. Great start to the year.
Have a Happy & Prosperous New Year 2012, everyone!
January 2, 2012 at 10:53 pm
Very well written article. Thank-you very much for the same.
It's difficult to keep cool and look for the root cause when such problems arise. I therefore, appreciate your dedication to...
December 27, 2011 at 5:32 am
SQL Kiwi (12/25/2011)
Interesting - I cheated, obviously, and found there are nine, but it appears eight is also right:
Well, I cheated too! 🙂 I knew about Rudolph, Vixen and Cupid,...
December 26, 2011 at 5:53 am
One of the things that I find missing these days is patience. It seems nobody takes the time out to think and plan out the code that they are going...
September 23, 2011 at 1:22 am
Good article, Craig! Learnt a few new things today with respect to troubleshooting memory pressure on the server.
Thank-you for taking the time out to compile your findings and write the...
September 20, 2011 at 12:22 am
Viewing 15 posts - 91 through 105 (of 325 total)