I'm researching for an article and a blog post on Stretch DB, and I'm struggling to find anything complimentary to say about it to be honest.

How many here have a...

My rule on storing XML is, is it going to only ever be used as a single chunk, or will it need to be searched/shredded.

If the latter, don't store it...

Maybe start with a basic...

DECLARE @Today DATE = GETDATE();

WHERE <the datetime column> >= @Today and <the datetime column> < DATEADD(dd,1,@Today)

Providing you have properly written check constraints on both sides, it should work (checking on inserts not enough, you need to consider updates), emphasis 'should'

Be careful...

Can you post execution plans for all of those tests?

No point in time recovery. If you're doing full backups once a day, then in simple recovery you're risking up to 24 hours of data loss in a disaster, where...

Jack Corbett (4/7/2016)

---

SQLRNNR (4/6/2016)

---

Brandie Tarvin (4/6/2016)

---

Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how...

Not real corruption.

https://connect.microsoft.com/SQLServer/feedback/details/641122/error-605-in-tempdb-on-sql-2008-r2-despite-bug-claims-to-be-fixed

tindog (4/7/2016)

---

GilaMonster (4/7/2016)

---

Or do both. There will likely be an upgrade option for the certification (usually...

Or do both. There will likely be an upgrade option for the certification (usually 1 or...

nTile window function can create a column with numbers 1 to 4. After that it should be easy to do an INSERT ... WHERE Tile = 1...

CREATE TABLE #Test (

SomeNumber...

Anyone want to hep tune a really nasty looking query?

http://www.sqlservercentral.com/Forums/Topic1774589-3412-1.aspx

Hugo Kornelis (4/7/2016)

---

Suppose you need to restore and find that the last full backup is unreadable, you can still restore from the previous full and then apply all tran...