What about the other tables in the query?

What indexes do they have?

Are there any FK constraints between these tables?

Jeff Moden (3/16/2016)

---

I strongly agree. NULL is not NOTHING. NOTHING is a known...

RV16 (3/16/2016)

---

The best way to copy student image is using robocopy instead of sql server scripts

So I just used that way:

And now its solved. So I just put answer anyone...

When deciding on changing the data types take into consideration that same operations (say, WHERE DateCol1 = DateCol2) take 2-3 time longer on DATETIME2 than on DATETIME.

Do it only where...

The query may be greatly simplified.

You just need to start from another end.

Do not turn birthday to ages, turn predefined ages into date ranges for birthdays:

SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE())-6,...

Not that challenging, really.

Just take each requirement 1 by 1 and put it in SQL.

1. If an employee has an schedule...

As for me, there are 2 many words for such a simple operation.

This should do:

INSERT INTO [Clock] ([clockIn], [UserName])

VALUES(GetDate(), 'Rose')

WHERE NOT EXISTS (

SELECT * FROM [Clock] WHERE [clockIn] ='12/03/2016'

AND...

For such occasions I've built a script which checks if TRN log files are filled for >50% and launches corresponding BACKUP LOG jobs when required.

Those jobs may included into replication...

When saving the script from SSMS make sure you choose UNICODE encoding.

Is the described behaviour version dependent?

I replicated the tables, enforced and checked the FK, and I still have Clustered Index Scan on Projects, Clustered Index Seek on Departments and Nested...

I'm glad you have no comments on this statement:

MMartin1 (1/21/2016)

---

We are not recommending a practice of not maintaining some type of order in a table, just providing the solution given...

There is a missing piece in your example:

Select ....

From OrderDetail

Where OrderId = @OrderId

ORDER...

Mvs2k11 (3/8/2016)

---

Thanks ..I was figuring out the data which has millions of records however I have the data which have mentioned..

What is the solution.. when I put max recursion to...

You can add a computed column to the table and then index it.

It's always the story about those "simple questions".

🙂