From your description it never made sense to me that it would be the Pool size setting alone causing the issue. Thanks for posting back and you're welcome. Happy you...

@bpowers, sounds like you already got something going in SSIS. The interleaving requirement is much more interesting but if the data recipient will take all header data followed by all...

I know SSIS can do either all header then all footer or all interleaved. I do not know if bcp can do it natively but am sure I could get...

OK, so order is a requirement. There are several ways you can do it but since you have the data and the ETL tool to consider one data-oppption may pair...

Can you simply return two resultsets and then join those resultsets in your application for display? For example:

Resultset 1: 0..n header rows

Resultset 2: 0..n details rows where the ID relates...

Check for dialog boxes that do not have the focus. I have seen where the installer is asking for info or confirmation from you but the dialog is not presented...

Some additional reading for you: Has tempdb grown since the last restart?[/url]

Eirikur Eiriksson (1/2/2016)

---

Orlando Colamatteo (1/1/2016)

---

Eirikur Eiriksson (12/21/2015)

---

That's correct, neither optional parameters nor default values...

Harshana-455711 (1/1/2016)

---

Hi

We have migrated our db server from SQL Server 2008 Enterprise edition to SQL Server 2014 Standard edition. One of our web site connecting to this SQL Server...

MotivateMan1394 (12/15/2015)

---

Hi

we have about 1.000.000 pics related to our products in our web site.

Now these Pics are maintained in a file server.

we have some problems to control...

Eric M Russell (12/23/2015)

---

With the exception of secure document storage, I don't see the point in containing BLOBs in a relational database. With what you're suggesting, the website would hit...

Sean Lange (12/21/2015)

---

Ed Wagner (12/21/2015)

---

If your goal is to pass a list of values to your function and then treat it as a table to perform a query, you could...

Eirikur Eiriksson (12/21/2015)

---

That's correct, neither optional parameters nor default values can be defined for...

titsiros (12/30/2015)

---

Yes its true that the -1 solution would do for this thread although I am a bit hesitant to use it in case the application or reports on this...

Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my comment...