I had to do some fixing to your CREATE TABLE scripts (suggestion - next time when you post a question, test the scripts first). And I changed the data types...

SteveD SQL (3/4/2016)

---

Hi Hugo,

A Role can be...

I am sure that sometime, somewhere deep in the dark and muddy past of SQL Server (probably back in the Sybase days),...

Sean Lange (3/4/2016)

---

Of...

At the top of your screen, just below the line that reads "Welcome, (name) / My ccount :: Briefcase :: Logout", and just to the right of the...

Before looking at the execution plans, one more generic query - is it possible to rewrite the reporting process to execute the "expensive" query once, save the results, and then...

Thanks for posting the plans, Pedro!

Let's first look at the "fast" query 1. This one is actually quite terrible, and would probably go a lot faster if you use a...

Perhaps somewhere in the code that is in the database, three-part naming is used for object references. So perhaps a SELECT statement used FROM DatabaseA.dbo.TableX instead of just FROM dbo.TableX....

etl2016 (3/4/2016)

---

Now there is requirement to add a new column D which qualifies each aX, whether it is start of the month, if so what year and what month etc....

Mvs2k11 (3/5/2016)

---

Thanks for the response. This was helpful but my database has 2 tables where the provided the link has a single table which has all the names, ids in...

A frequent confusion for people who are starting to learn SQL Server is to think about what happens from their own perspective. That is not the case. From your perspective,...

First of all, comparing fulltext with like is kind of an apples and oranges thing. So I will just ignore that last remark.

Based on what you tell us, my first...

RonKyle (3/4/2016)

---

No issues here. I of course know a date data type can be NULL. My only issue, and one for which there is no solution in an...

RonKyle (3/4/2016)

---

For your example, only 'Work Order Status' and 'Technician Assigned' could be normalized out in a standard structure. My question is simple. Why not? One of the many purposes...

Sean Lange (3/4/2016)

---

Hugo Kornelis (3/4/2016)

---

Sean Lange (3/3/2016)

---

Shall I repeat the concrete example yet again? You have a column in step 3 that is required. That column cannot be made NOT...