1) Latches are rarely a true source of performance problems on SQL Server and outside of PFS/SGAM tempdb allocation issues and perhaps a few other circumstances they tend to be...

paul.s.vidal (7/11/2016)

---

I was researching and i find out that the mirroring offers exactly the same as oracle Dataguard.

But also found that is going to be deprecated soon, but is still...

Ed Pollack (7/11/2016)

---

Hi Deepak,

Those indexes are not considered overlapping/duplicate indexes as they do not share sorting functionality. For the sorting columns, order matters. The first index begins with...

chudman (7/10/2016)

---

Thanks, Kevin,

I am not trying to be snarky or nit-picking. I am really curious. I have come across this a couple of times recently in third-party databases,...

chudman (7/10/2016)

---

This response is directed at Kevin

I am curious how an non-clustered index that matches the clustered index could be more efficient. Can you elaborate on that,please?

Thanks

Jeff Bennett

Saint Louis,...

Important stuff in your article. Probably 75+% of the new clients I see in my consulting business have duplicate or overlapping indexes - most often created via DTA use.

I think...

Raghavender (7/8/2016)

---

ChrisM@Work (7/7/2016)

---

Raghavender (7/7/2016)

---

in the stored procedure if we change the substring in condition to like its working if we set the compatibility level to 120, where as with substring...

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

---

[Col1] ASC,

[Col2] ASC,

[Col3] ASC,

[Col4] ASC

Majority of the queries use all...

We can go back-and-forth with he-said-she-said's for weeks and not cover all the permutations or pros and cons of indexing. That's specifically why I didn't even start down that road....

There are cases where the number of cached plans can actually become a bottleneck in that the hashing and specifically hash lookups can take too long or create their own...

I don't think you need to do big calculations. You just need to do repeated stuff with no delay.

http://blog.sqlauthority.com/2013/02/22/sql-server-t-sql-script-to-keep-cpu-busy/

http://stackoverflow.com/questions/24810905/trying-to-create-an-sql-query-that-will-max-all-cpus-to-100

You can go in and directly modify all of the log shipping tables and jobs if you want. But personally in this situation I simply use scripts and windows scheduled...

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

---

Hello Folks,

Is it a good practice to create clustered index on non-primary key columns since the primary key column is not queried at all. Please share your thoughts or...

Raghavender (7/7/2016)

---

in the stored procedure if we change the substring in condition to like its working if we set the compatibility level to 120, where as with substring in condition...

The Dixie Flatline (7/7/2016)

---

I am insulted that you would dare accuse me of such a travesty!! :w00t:

Just kidding.

We aren't updating the same table after an insert. ...