Steve Jones - SSC Editor (5/24/2016)

---

I typically wouldn't expect more than one file in the primary filegroup, but there are certainly reasons to do this. Not sure you get benefits...

Thank you - this was very helpful.

I ran your query and I can see that all the indexes are on the Primary filegroup.

I can also see that all the files...

Sorry it was not my intention to hijack this thread.

Thank you for your help anyway.

I have 56 Gb of Memory and I had assigned 50 to SQL Server, leaving 6 GB (ish) for OS and everything else.

Now that I've read this post I think...

What does this mean then, if you are running SSIS and SSRS on the same 2012 machine, should we reduce the max memory further, in order to allow more memory...

Great question 🙂

And thanks to Hugo for his explanation.

Hi Ben

Did you ever get that working? I have a similar requirement and would be interested to know what you tried. After googling this for a while I'm considering...

I would never have had the opportunities that I have today. I guess based on my own family history I would have been a seamstress, but I like to think...

Definately Notepad ++ and Firefox 🙂

Thank you for your reply.

I decided that I was not comfortable taking the risk and used this as an opportunity to try using SSIS.

I found the learning curve with SSIS...

Thank you

I may not have explained very well.

my sp has a parameter passed in containg the value '£PP' or '£P' this is then evaluated in the sp:

IF @params =...

I have changed my print statements to select and that has stopped the error showing up before the debugging statement.

Yes, but this is the first time that the cursor is declared.