GilaMonster (3/29/2016)

---

Space used + 2 bytes.

As for make everything varchar(8000), why? Is a person's first name going to be thousands of characters long? A city name? A company name? An...

Grant Fritchey (3/22/2016)

---

Nothing is ever free. However, in most cases, the load is light enough that it only marginally interferes with normal operations. If you use backups to offload it,...

John Mitchell-245523 (3/22/2016)

---

Nader

I'm sure it's all in the documentation, but here's a summary as I understand it. DBCC CHECKDB doesn't take any locks that will cause blocking of use...

Jeff Moden (3/13/2016)

---

nadersam (3/13/2016)

---

Hi All,

We have an index rebuild job running over night, unfortunately it fails many time due to activity on system and it's chosen by sql server as...

Jeff Moden (3/13/2016)

---

nadersam (3/13/2016)

---

Hugo Kornelis (3/13/2016)

---

Do you find...

Jeff Moden (3/13/2016)

---

Supposed "long running" aren't usually the biggest problem when it comes to the front end. People look for things like queries that take over 1 second to...

Hugo Kornelis (3/13/2016)

---

Do you find that your buffer...

Hi Hugo,

Thanks for your reply.

You are right if column is included in an index , the index should be dropped first , change done then index re created.

Regarding the script,...

Thank you very much guys i will apply those recommendations and try and get back to you with result

At the beginning i had this query as a view with normal joins but noticed the index scan on patient table and high reads also.

I thought if i change the...

I did that now but still on patient table it's an index scan operation and big number of reading on table.

What i need to check is the index scan on Patient table.

This is a big table and accessed by most functions in system.

Is there anyway to reduce the count of...

I hope it's ok this time.

Thanks

Hi Orlando,

Thanks for your reply.

I have to generate example because the real data is too big and contains some sensitive data, unfortunately i am not allowed to send.

The example i...

Hi All,

Thanks for your replies.

I have attached the scripts as requested for your kind review.

Best Regards

Nader