Not to cast stones or aspersions especially since I do not know any details about this situation, but:

At a keynote address back in February, at a Linux conference, the (paraphrased)...

1.  You need to check with the server guys, and ask whether they noticed that the patches they implemented included the SQL Server instead of windows patches.  They may have...

It sounds to me like you may be approaching this question from not precisely the correct angle.

Assumptions:  1.  The database is a live production database.  2.   The user may or...

So many places to go on this, and so little time...  Some thoughts:

1.  Assuming that the ID will be unique, and you don't want to lose data, there are outstanding...

OK. this correlates to the archiving plan issue... the web site has been redesigned since the article was written, and the quote with the associated link is gone. ...

The original question boils down to:

Whereas, if I connect to my local machine using machinename\SQLEXPRESS, then the above mentioned query runs fine.

when you add '\SQLEXPRESS' as part of your connection...

Forgive me if I'm stating the obvious here, but I suspect that, in order to get numeric results, you're going to have to rethink the entire query.  Why?  Because in...

I'm glad this question is worth only 1 point. That's all it deserves. While I agree that every jot and tittle matter as technicians, there's a fundamental question...

Congrats indeed! What was the first story, and where can it be found?

Well, doubly shame on me. I had recently read a discussion on this very topic and still indulged in wistful thinking. However, there is a bit of perverse...

Rob - quick thought... rather than use notepad, highlight your entire post and copy (cntl-c) before previewing.  that way, if it's lost all you have to do is reopen and...

The 'perfect' answer is missing.  Grab a thumb drive and copy the cube to his machine, so that both of you can work independently.  Who travels with a crossover cable,...

Maybe your DBA wanted to know if you'd notice?

As written you should get an error message, because your closing WHERE has an ambiguous reference?  The interior select appears to be using only one table and is idempotent.  If...

try this: datediff(minute, date1, date2) as mins, datediff(second, date1,date2) as secs as the function calls for calculating the difference between dates, in SQL. Place it in the select...