SQL!$@w$0ME (7/8/2016)

---

[Col1] ASC,

[Col2] ASC,

[Col3] ASC,

[Col4] ASC

Majority of the queries use all...

So the majority of your queries, or the most frequently called queries use all these columns when filtering:

[Col1] ASC,

[Col2] ASC,

[Col3] ASC,

[Col4] ASC

That's a very wide key, three 256 varchars. To...

The core guideline that the best clustered index is a unique, not null, monotonically increasing integer column (basically, identity), is true. That said, it doesn't rule my life. For example,...

SQL!$@w$0ME (7/8/2016)

---

Any downside if the clustered key(non-primary key columns) is not unique and the columns are VARCHAR fields and NOT NULL?

Or is it better to create Primary key (identity...

Phil Parkin (7/8/2016)

---

Grant Fritchey (7/8/2016)

---

I'm in agreement with Kevin.

Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If...

Phil Parkin (7/8/2016)

---

Yes. Otherwise SQL Server has to create its own 'uniquifier', to make the rows unique....

I'm in agreement with Kevin.

Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If that's the primary key,...

You'll be able to see the objects, but you won't be able to tell what they are or where they came from.

So, my suggestion is, leave the compatibility at 120 and just add the traceflag to force it to use the older cardinality estimator.

There are differences, and this could account for everything. The first plan I looked at, 1027.sqlplan, is using the 70 Cardinality Estimation Engine. That means that database is using the...

Jeff Moden (7/6/2016)

---

tezsb (7/6/2016)

---

This is where it got a bit tricky. I am not a development DBA by any stretch of the imagination. my role is to do the backups,...

Generally, you'll have the same IP address for very long periods of time. However, I travel a lot and demo Azure at many different locations. It's quite easy to quickly...

I absolutely would not seek licensing advice on the internet. Microsoft is going to decide if you're in compliance or not. I'd go there to ask.

But you are looking for waits. You have a process that is timing out. That means it's running long. Why is it running long? Well, it's not getting the resources...

ffarouqi (7/5/2016)

---

Grant Fritchey (7/5/2016)

---

I'd want the specifics on the error message.

If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job,...