SQLKnowItAll (1/18/2013)

---

The developer mentioned that since this is a declarative language, the space had to be reserved no matter where it was. That seems correct, but I don't know...

You could also consider switching to use a Linked Server to connect to a remote SQL Server instead of using the OLE Automation routines.

Are there any Script Tasks with non-trivial programs in them? Look for code that produces a message box. Sometimes developers will leave one in there by accident and it will...

You've been around long enough to know "it depends" 😀

If HyperThreading is left on then I agree with keeping Max Degree of Parallelism below 32 in any conceivable scenario. If...

M_E_K (1/18/2013)

---

Looking for some ideas on a performance scenario we are seeing in production. I can't make any changes to production for a while, and I haven't found a way...

When you say "output parameter" I am assuming you are capturing that using an Execute SQL Task. Are you using OLE DB or ADO.NET? Can you show some screenshots of...

That is bizarre. Anything in...

Which version of SSIS?

PowerShell would be great for this. Using the SQL Server Provider you can iterate over the Linked Servers of your Central Server and issue a query to each. Then you...

Duplicate post:

http://www.sqlservercentral.com/Forums/Topic1407742-392-1.aspx

I agree things like this are best left to a presentation layer but the appetite for features like this is obviously present as Microsoft added FORMAT() to T-SQL in SQL...

If you can use SQLCLR you could use GROUP_CONCAT for SQL Server[/url] and write your SQL like this:

SELECT t1.OtherVisaID,

t1.Name,

...

Yes it is a good idea to change the compat level to the current level, after your apps have been tested against it of course to ensure the SQL they...

What is different about a connection to the instance with the intent to use the legacy group versus the intent to use the production group? A different set of logins...

From Understanding the VAS Reservation (aka MemToLeave) in SQL Server by Jonathan Kehayias this shows you the clerks using VAS in detail:

SELECT type, virtual_memory_committed_kb, multi_pages_kb

FROM sys.dm_os_memory_clerks

WHERE virtual_memory_committed_kb >...