g.britton (3/13/2015)

---

GilaMonster (3/13/2015)

---

Be careful of using a function in a constraint. The constraint only gets checked when the table that it is on changes. If the table that the function...

Which is utterly irrelevant as the account that's running the sp_create_trace is...

Bear in mind that it's not at all uncommon for sorts to spill. The sort operation requires a lot of memory and, as such, most sorts that affect larger row...

Can we see the query and execution plan please? There's lots of guessing happening, but hard to say what's really happening without seeing details.

You need to grant permission on the share and folder (the ones in Windows) to the account that SQL Server runs under.

If you don't have permissions on the windows server...

The main thing that immediately comes to mind is that you're missing brackets.

AND takes precedence over OR, meaning without brackets, your WHERE clause actually means

(b.field1 LIKE 'ABC' AND b.field2 BETWEEN...

You need to grant the account which SQL Server runs under permission to access the share. If the service account is not a domain account, it first needs to be...

The account that SQL Server is running under (the SQL Server service account) does not have permission to the share.

I don't recommend saving a trace across the network. The network...

Toby Harman (3/13/2015)

---

Many years ago I found a comment by my boss in the code which read something along the lines of

-- Don't touch this code

-- It does fancy statistical...

Be careful of using a function in a constraint. The constraint only gets checked when the table that it is on changes. If the table that the function reads from...

As a counter-example of when you would wrap something in BEGIN TRAN ... ROLLBACK:

I do a lot of performance tuning. As such, I have to run procedures so that I...

A trigger on the base table for the view.

"Fully denied" would be claims that have 1 or more "3" and 0 "1", correct?

Restore it to another server. If the restore succeeds, the backup is undamaged.

If there's an INSTEAD OF trigger on the view, then when the view is the target of an data modification the trigger is fired replacing the data modification. Hence the...