It's a somewhat common practice (not as common as it needs to be) to disable or reduce the permissions of builtin\admin post-installation. Is it possible someone did this? ...

If you want to experiment with it and see it a bit more directly, try creating a clustered index with included columns, and another view (different name, same definition) with...

Lynn Pettis (8/28/2012)

---

And this is the ANSI standard way of doing the same update as above:

UPDATE Orders SET

some_col = (select

...

What you need to do is Full Outer Joins instead of Left Outer Joins. Join on Doc ID and Row Number.

SELECT COALESCE(dbo.GR.DocNum, dbo.GE.DocNum, dbo.Ref.DocNum) AS DocNum,

...

Is this in response to something? Or just felt the need to vent? (That happens.)

We can compete on some of that, generally by total quality and cost of...

Do you have a bunch of SQL Agent jobs that run extremely frequently? That's likely what's causing it.

The only way I see to possibly avoid tempdb on this one would be to build permanent tables, do the work in them that tempdb is doing in worktables, and...

Robert.Sterbal (8/27/2012)

---

It seems like gene sequences often go in the thousands in lengths, and any change could be a mutation. 90% of all are genes are um... not used in...

Yeah, it's kind of unpredictable what will work and what won't, when it comes to cross-server queries.

When you return a date (or datetime, etc.) datatype in a query in Management Studio, the format you get is YYYY-MM-DD. Has nothing to do with how the data...

Ah the joys of the Distributed Transaction Coordinator! That's the most likely culprit. My usual solution is pull the remote data over into a table variable (avoids log...

Rod at work (8/27/2012)

---

GSquared (8/27/2012)

---

UPDATE/DELETE FROM work in all versions of SQL Server that I've worked with, including SQL 2000, 2005, 2008, and 2012. MS isn't planning on removing...

One potential difference is that the tables in the From clause do not include their schema names. Thus, if his login has a different credential than yours, it might...

Can't you just hard-code the string in the Select?

select 'Linked Server Name' as LinkedServerName

from [LinkedServer].database.schema.object;

I don't think you can do so. Per http://msdn.microsoft.com/en-us/library/aa258841(v=SQL.80).aspx:

DROP TABLE permissions default to the table owner, and are not transferable. However, members of the sysadmin fixed server role or...