You shouldn't be using Profiler anyway. Instead, use extended events.

The other posters largely have it right. I'm just piling on.

First, you have to identify what is causing stuff to...

It's got to be due to the version.

But, what version is the SSMS tool that you're using on both?

jasona.work (3/4/2016)

---

WayneS (3/4/2016)

---

jasona.work (3/4/2016)

---

I suppose I could toss this question into it's own topic, but meh...

To anyone who has gone on any of the previous SQL Cruises, if you brought...

And then the last statement is usually RESTORE ... WITH RECOVERY so that the process concludes.

RonKyle (3/4/2016)

---

I don't have a Closed column in the simplified design, but a Closed Date. Ideally this would be blank if the order is Open because the date doesn't...

The added cost is only for the SOs cruise. There's no added cost for the SO to be registered with the group and take part in the social aspects of...

pietlinden (3/4/2016)

---

Or you could install Reporting Services and do the reporting there... Kind of depends what kind of reporting you're doing. One thing that Access doesn't do well is...

Orlando Colamatteo (3/4/2016)

---

Igor Micev (3/4/2016)

---

Hi Grant,

Can you put here...

RonKyle (3/4/2016)

---

I have to agree with Sean and Grant. You can get great performance out of a normalized structure and the integrity is there in the design. Moving the integrity...

In addition to the DMVs exposed through sp_whoisactive, you need to be focused on wait statistics[/url]. That tells you what is literally causing the server to run slow.

Instead of messing with a custom script, I'd just use one that is pre-built. Minion Reindex [/url]is my current favorite.

Rereading the original post again, this data should be normalized. It's clearly relational based on the example. It's collected in a series of stages. Some of the data is required,...

Tom Van Harpen (3/3/2016)

---

Ok i had nothing specified for the run as user option on the advanced tab.

There is...

The job owner, but which account owns the step?