Just call it right within the procedure as stated. Here's the documentation.

Have you looked at the execution plan for the query? That will tell you why it's running slow.

You can include this information in the connection strings from the application and then it will be available in SQL Server. But, if it's not a part of the connection...

Service Broker is a messaging and queuing engine within SQL Server. You can read more about it in the Books Online. It appears that this error was addressed by a...

In that case I'd just pull them directly from source and publish them that way. PowerShell will be fully automatable, you can connect to multiple servers, and with threading you...

I'd suggest writing a PowerShell script to run the export and import of the procedures. That should be fully automated and ought to work well.

Another approach would be to put...

I think your logic is sound. I'm just a big fan of testing things to be sure.

Stephanie Giovannini (4/24/2015)

---

I'm working on a table design and I think the table will have a non-clustered primary key, but I'm wondering how that's implemented behind-the-scenes.

Suppose my table looks like...

Why 100K rows? Is it an export? If it's not an export of data, 100K is not a reasonable number of standard evaluations.

Then you might be running into resource issues, not enough memory, possibly contention in tempdb, the log file was growing over and over? Something along those lines.

You could set up a trigger to capture inserts. That might cause some performance hits though. You could capture queries using extended events and sort out the INSERT statements. It...

200 million rows isn't really that big and that's a long time for an index to run. I suspect you may have been experiencing blocking. The thing to do would...

For an insert query, those are the full results. You're seeing exactly what you should. You inserted a row. It was completed successfully. An insert doesn't return data.

The thing to do might be to hire a consultant to do the job description and the interviews for you. As Jeff says, you've split the difference between a BI...

I've seen a 5 minute compile time on queries, so they can run for a very long time indeed. If you're looking at the plan, you can see the compile...