You have been around long enough to know what to expect from a post with this little detail...

In order to help we will need a few things:

1. Sample DDL in...

amenjonathan (9/30/2013)

---

Sometimes I find the reason behind a poorly performing stored procedure lies in passing the external parameters to internal variables and then using those internal variables instead of referencing...

dba_track (9/30/2013)

---

What i mean is is to find some sort of stats on how many times all the tables within any given database is read from and written to -...

Guras (9/30/2013)

---

I have a stored procedure which runs in database DB1

This stored procedure will have other stored procedures inside it which should run in parallel.

Create procedure db1.proc1

AS

use db2

call proc2

use...

What are you looking for? Not sure what...

nikonlens50 (9/30/2013)

---

two tables

table1 table2

StudentId ...

mrea-605474 (9/27/2013)

---

Yes, perhaps at some point I will dig into the web pages & DB structure and start changing it. I know why it was written that way, once...

polkadot (9/27/2013)

---

Very nice of you Sean.

Aliased the table variable, and referenced the values in the table variable with column name.

worked:

DECLARE @benches TABLE (Bench varchar(20));

INSERT @benches

values

('LabC1'),

('LabC2'),

('LabC3'),

('LabC4');

INSERT INTO RunsByBench

SELECT

Bench...

SQLRNNR (9/27/2013)

---

Sean Lange (9/27/2013)

---

Luis Cazares (9/27/2013)

---

Sean Lange (9/27/2013)

---

Luis Cazares (9/27/2013)

---

Today, I'm really pissed off with the database and network administrators. Because of the lack of good planning and best practices,...

polkadot (9/27/2013)

---

before I go there, I want to clarify. The parameter @benches is called out in the left query as well as the right.

I tried this:

created tvf

CREATE...

Sure. I assume...

Glad you enjoyed...

Hard coded connection strings are for this guy.

Is this dev actually trying to say that MS says it is best practice...

Jon Higgins (9/27/2013)

---

I tried the hosts file approach early on and it didn't seem to work. I also tried the Client Configuration utility to see if that works. ...