GilaMonster (2/3/2016)

---

Well, if you want to go and create extra nonclustered indexes, then whether you put include columns or not would depend on what purpose you're creating them for. I...

On Non-Clustered index i mean.

GilaMonster (2/3/2016)

---

Yup, you're getting full table scans each time you run that update, because without any indexes at all, SQL has to scan the table because it's got no other...

Thanks Gail

GilaMonster (2/3/2016)

---

If there are no constraints or indexes, how is SQL supposed to figure out that trackID is unique? Without indexes, you're going to be getting full table scans, hence...

GilaMonster (2/3/2016)

---

Is there a unique index or unique constraint on the column? Why does the table not have a clustered index? What indexes does it...

Thanks Gail for the quick reply. Was going through your old post on Deadlock query.

Attached the xml . please have a look.

Eirikur Eiriksson (1/10/2016)

---

Quick question, did you just add the SPMs or did you remove them before adding them again?

😎

The article benjamin.reyes posted a link to has good instructions on how...

Anyone on this

Thanks Guys,

Added SPN success fully but still getting below error in SQL Error log.

The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/ABC-SYS.sys.abc.in:5432 ]...

Thanks David.

Wish you and all SSCians happy and prosperous 2016.

What are the other jobs?

Is this server already starving out of resources?

Backup job normally should not impact any other .

share the script or screenshot of your maintenance plan.

Thanks Anthony.

BizTalk Application and SQL Server are on different boxes. These SQL Servers are dedicated for BizTalk

Thanks Grant.