hoseam (3/15/2016)

---

DECLARE @End_Date DATE

,@The_Date ...

Emil B (3/15/2016)

---

DesNorton (3/15/2016)

---

The cleverer peepels here will probably shoot...

Sounds like we both have quite a lot of job security, eh Jeff?!? 😀

1) patch up. Some SIGNIFCANT fixes have been put out there for dbcc checkdb recently

2) search web for argenis Fernandez dbcc checkdb (and paul randal too) to find some good...

Jeff Moden (3/14/2016)

---

TheSQLGuru (3/14/2016)

---

1) IIRC, partitioning is an Enterprise Edition only feature. That could preclude it's use right off the bat.

2) Partitioning CAN make SOME or even MOST queries...

1) IIRC, partitioning is an Enterprise Edition only feature. That could preclude it's use right off the bat.

2) Partitioning CAN make SOME or even MOST queries run very fast...

I wonder if this new function voids the use of parallelism in the engine like a Scalar or Multi-statement TVF does ...

In the database layer one solution is a trigger that checks the value and rolls back the transaction.

You could validate date in the application layer (and probably should, honestly),...

Someone needs to point out that using this in a...

Someone needs to benchmark the STRING_SPLIT() function coming out in SQL Server 2016 and update the main article!

https://msdn.microsoft.com/en-us/library/mt684588.aspx

UNION will get you multiple rows if the primary one hits and the alternate does also.

At first blush I can't think of a way to do this in a single...

Keying off of a CRITICALLY important point that Grant makes: expecting fragmentation. This one will absolutely harm your system in numerous ways in a number of cases:

1) Non-sequential GUIDs: 85...

1) If you are asking for lots of rows with lots of columns back to a client app that alone can take a LOT of time, even if SQL Server...

ChrisM@Work (3/10/2016)

---

Junglee_George (3/10/2016)

---

I wiil use the NVARCHAR 4K version of [DelimitedSplitN4K] for splitting the input parameter string.

If you can help me in rewriting the stoed proc usp_StatusHistory , it will...

Phil Parkin (3/9/2016)

---

TheSQLGuru (3/9/2016)

---

I'm going to STRONGLY disagree with any notion anyone might have that putting this lookup stuff into a table (of any flavor) and joining to it in...