Steve Jones - Editor (4/2/2010)

---

There's a bunch of WP/JS/DIV code in there that seems to be making things wide. I shrank the KeyDiscovery one a bit, but some of the...

Please post your actual execution plans.

Paul White NZ (4/2/2010)

---

Gianluca Sartori (4/1/2010)

---

At this point I wonder why case-sensitive servers allow creating linked servers with non-uppercase names.

It would be a great time saver if only uppercase names...

If the file is missing, you could locate it on the install media and copy it to the hard drive and register it.

lmu92 (4/2/2010)

---

You could use Row_Number() to find the dupes...

Something like this:

DECLARE @tbl TABLE

(

CustNumber INT, FirstName VARCHAR(30), LastName VARCHAR(30), City VARCHAR(30)

)

INSERT INTO @tbl

SELECT 345321 ,'John','Doe','Kellogg' UNION ALL

SELECT...

WayneS (4/2/2010)

---

Paul White NZ (4/2/2010)

---

Steve Jones - Editor (4/2/2010)

---

You are very...

Pranav Shah-410191 (4/2/2010)

---

Hi,

Thanks for the response, I have never used multiple databases in this scenario, not 100. I am coming from Oracle experience for the last few...

Answering a...

Steve,

Will you take a look at http://www.sqlservercentral.com/Forums/Topic896017-433-1.aspx

Probably - just...

Thanks Steve

Happy Easter to you and enjoy the weekend.

Nice article Ian. Thanks.

Knowing that a majority are MS employees may have a little to do with it. With some of the nonMS people attending, I am surprised that the pass rate...

I would look for some long running transactions or other jobs.

An alternative could be related to a heavily fragmented file system (unrelated to indexes or database fragmentation).

To reiterate what Ron has said, please remove the double quotes, and format the code using the code link.

Even though the double quotes will work around column alias' like that,...