Wow - NASA hired Lt. Cmdr. Data? Quite a coup!

(The actor Brent Spiner played both Data in the Star Trek: The Next Generation TV series/movies and the character in...

Lynn Pettis (8/9/2012)

---

And it gets worse if the views your are joining together are based on views joined together.

You can imaging how this can expand to views joining views, joining...

NJ-DBA (8/1/2012)

---

Testing revealed that the primary factor influencing the duration of the “if exists” query is lack of an index with th filename column in the key. Particularly, this column...

Have no doubt - joining views to views can be very problematic when the view definitions include JOINs. Typically, joining views that SELECT from only one table (as you might...

If I read your requirements correctly, you want an XML structure with an <Asset-Details> element that may have many child elements, some of them with child elements of their own....

Lowell (3/1/2012)

---

another possibility could be that the linked servers on DEV and LIVE have the same names, but different definitions.

it's not obvious, but you can create a linked server with...

mic.con87 (2/29/2012)

---

Hi I have a column (Driver) that has dirty data but there is info in the column which is usable.

What I would like is to create two adjacent...

Lowell (2/29/2012)

---

how many objects are being accessed via the linked server?

you might consider creating synonyms for the objects. if there is a zillion of them, or dynamic SQL is being...

aaron.reese (2/29/2012)

---

Hi guys,

I have a 2005 instance with both a DEV and LIVE database with a stored procedure which references a Linked server.

Because the linked server resides at instance level...

saghbash (1/24/2012)

---

I am trying to import data from one table to another in SQL 2005 database. I imported the data into a new table from an Excel file. I also...

newbieuser (5/10/2011)

---

Hi all,

We get the below error when using order by clause in the select query using the linked server to Oracle table (LS..USER2.UNIT3)

SELECT U.ABO,U.LED_ID, U.PROJECT_NO, T.WORDC,...

newbieuser (5/10/2011)

---

Hi all,

We get the below error when using order by clause in the select query using the linked server to Oracle table (LS..USER2.UNIT3)

SELECT U.ABO,U.LED_ID, U.PROJECT_NO, T.WORDC,...

mphilippopoulos (1/23/2012)

---

I have a table-valued UDF on database db_1 that selects data from a table in another database - db_2 - on the same instance.

Permissions are configured explicitly for users...

Oh, and by the way, I tested the function you posted earlier. It definitely works properly on...

Here is a function that splits VARCHAR delimited strings up to 8,000 characters in length - as...