Lynn Pettis (5/28/2010)

---

Thank you, now I just have to see if...

Here is a good blog post (if I do say so myself) regarding performance between inline code, inline TVF's, and scalar functions:

Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

You are. Direct from Microsoft:

MULTIPLEXING: USE OF MIDDLEWARE, TRANSACTION SERVERS, AND MULTITIERED ARCHITECTURES

Sometimes organizations develop network scenarios that use various forms of hardware and/or software that reduce the number...

Thank you, now I just have to see if he follows...

Jeff Self (5/28/2010)

---

SSIS package has connection to server A, server A has linked server to Server B

I can open connection to server A in management studio and run query with...

Bring this from the other thread:

TravisDBA (5/28/2010)

---

You know, I don't know that this needs any kind of legislation. The middle ground is horrible for everyone involved except the companies who...

I would love to explain my code snippet to you, but first I'd like you to try and explain it to me. To do this you first need to...

elutin (5/28/2010)

---

If you can, give this task to DBA.

DBA can switch server into Bulk-logged or Simple Recovery model (if it's currently set to a Full Recovery ) and then use...

You can also check out this article[/url] and the discussion that followed.

Are you using Windows Authentication or Mixed mode (SQL Server and Windows Authentication)?

Definately not the way it should be done. They should have taken a backup of the database and sent you that. Depending on how the mdf was copied,...

Anyone with knowledge of Operations Manager, please see if you can help here.

david.ostrander (5/28/2010)

---

Actually I'll be needing to install Reporting Services then. This is for Operations Manager from MS. So when I install Reporting Services I then from within there would config...

Is the table you are insert data into initially empty?

You may want something like this:

declare @rows int;

set @rows = 10000;

while @rows <> 0

begin

insert into dbo.JBMTestA

...

We should also...