PKs are not the only factor for bad plans caused by bad stats. Did you rebuild all indexes? All column statistics?

If you can manage it, port the scalar functions into...

You can do this if you switch to implementing Proc2 as a SQLCLR Stored Procedure instead of a T-SQL Stored Procedure. In a SQLCLR proc you can capture all resultsets...

subhashkmsbi (11/29/2015)

---

Hi,

Please suggest me how to load such huge XML into SQL Server which is of greater than 2gb in size.

Here my requirement is my XML file is huge in...

There is no way to close a topic on this Forum. Thanks for posting back that you found the issue.

I simply won't try doing anything production-related without SQL Prompt Pro installed. It is by no means free but it's worth every penny. My snippet library is extensive and my...

Delivering 650K+ rows to a client consuming it as a rowset is going to prove to be quite the difficult challenge if your SLA is 1 second or less, no...

You said proc1 delivers three different resultsets. Different is a disqualifier. INSERT...EXEC supports capturing multiple resultsets into one temp table however only when all resultsets have the same shape. Even...

Good deal. Happy you got something working. For others that might run across this thread, could you share the link to the installer you found that eventually let you run...

SSMS Express does contain the Import/Export Wizard. Try right-clicking on a Database, then Tasks, then Import Data...

The only limitation with SSMS Express is you cannot save the resulting SSIS Package...

You can use SSIS or the Import/Export Wizard (based on SSIS) from within SSMS.

PowerShell might not make sense if you'll only ever need to worry about one instance. If it's just peak usage you want then PerfMon is a good choice. With a...

Monitoring multiple instances implies you need something that can reach out over a network and compile and display results from multiple servers. PowerShell is a good choice for something like...

Use PowerShell and WMI.

what is your use case?

sqlsurfing (9/18/2015)

---

Hi I wanted to ask what do 'other' organizations do from an infrastructure and workstation setup look like for staff

that develop Java code in IDE on Linux but...