Probably not. He's probably trying to use an = for the upper end of a date range, which isn't the best...

You can't create useful indexes based only...

DATE is a date without a time component. Therefore you can't subtract microseconds from it.

SET @End_Date = DATEADD(DAY ,7 ,@The_Date)

and then instead of using BETWEEN @Start_Date and @End_Date, rather...

Without seeing the queries that run against the table, absolutely no way to say.

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

Ed Wagner (3/15/2016)

---

GilaMonster (3/15/2016)

---

Brandie Tarvin (3/15/2016)

---

In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a...

I tend to worry about it if I also see parallelism-related latch waits. But that's worry to...

Brandie Tarvin (3/15/2016)

---

In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not...

I don't understand the request, can you be clearer please?

It's an indication of buffer pool churn. Whether that's due to insufficient memory, bad queries or poor indexing is another matter.

Oh, and CXPacket...

Before you turn it off, make sure it isn't required by your company's audit or security...

Someone's implemented a DDL trigger somewhere, and it's broken.

Check in Object Explorer. Each DB, programability, triggers or Server Objects-> triggers for server-wide triggers (which is probably more likely where this...

It's coming from this fragment: @TheDate -1

You can't add or subtract integers from a DATE variable. Try DATEADD(dd,-1,@TheDate) in both places where that occurs

Threads are required to process logins.

Not offhand, no. You'll probably need a job that runs every (x) minutes, checks the state and then takes any necessary action. Won't be much overhead if it does nothing...

2) Because the log records still have to be sent to the secondary. If they could be removed from the log before being sent to the secondary, then you'd have...