Please don't post multiple threads for the same problem.

No replies here please, direct replies to http://www.sqlservercentral.com/Forums/Topic1686770-3412-1.aspx

Please don't post multiple threads for the same problem.

No replies here please, direct replies to http://www.sqlservercentral.com/Forums/Topic1686770-3412-1.aspx

cms9651 (5/19/2015)

---

GilaMonster (5/19/2015)

---

Declare @RangeStart varchar(20) = '01/01/2015 00:00:00', @RangeEnd varchar(20) = '01/01/2015 00:00:00' -- these come from the application

WHERE toDate >= CONVERT (datetime,@RangeStart,103) and toDate < DATEADD(dd,1,CONVERT (datetime,@RangeEnd,103))

Even if...

Why? If the patching is going to take the DB down, just fail the AG over to a secondary.

Declare @RangeStart varchar(20) = '01/01/2015 00:00:00', @RangeEnd varchar(20) = '01/01/2015 00:00:00' -- these come from the application

WHERE toDate >= CONVERT (datetime,@RangeStart,103) and toDate < DATEADD(dd,1,CONVERT (datetime,@RangeEnd,103))

Even if you don't...

Ok, let's go back to the problem.

What, exactly, are you trying to do? What data do you have? What should be returned by the query?

GilaMonster (5/19/2015)

---

Your upper and lower bounds of the between are the same. That means the query will only return rows where the toDAte is EXACTLY '2015-01-01 00:00:00.000' The date you...

cms9651 (5/19/2015)

---

But I have tried this syntax in sql query and the output is always empty:

AND doTableDate BETWEEN CAST('01/01/2014 00:00:00' AS DATE)

AND CAST('01/01/2014 00:00:00' AS DATE)

....

AND doTableDate >= CAST('01/01/2014 00:00:00'...

Well the problem has the same form, same cause and same solution as the one you discussed in there.

Your upper and lower bounds of the between are the same. That...

Is this the same problem as you're discussing in the BETWEEN thread? If so, please post there and not in a new thread. Thanks

30GB in use is not hard, especially...

You're not looking for mapped drives, you're looking for local drives, like C:, D:, E:, etc

Maybe give the sysadmin the backup and ask him to restore it?

p.a.petrov (5/18/2015)

---

The only thing that really coincides with the timing of the plans being regenerated is a DB maintenance job that we have: the daily index reorganizing (when fragmentation is...

Personally I can't even see where a merge join would be coming...

Almighty (5/18/2015)

---

if possible run the Trace on SQL server from other client machine (not from the same server) for 1 whole day or at list for peak hour and...