Interestingly all the deadlocks (around 70+) from past 2 days are showing
ridlock fileid=4 pageid 165303 dbid=6

how to see what data is in the page?
Since this...

What would be the possible naming convention for a Filtered Index?
FNCI !!

Thank you...

I was wondering how the max_length field was calculated and tried digging the system view sys.columns

and stuck at sys.syscolpars and thought to simply trust the view !!

Sean Lange (11/2/2016)

---

This kind of query is going to return so many false positives I would think it would be more efficient to simply make a list of every procedure,...

Grant Fritchey (11/2/2016)

---

OK, but just using the equals (=) as an example, you can put the column on either side of that and a variable, parameter, or hard coded value...

Grant Fritchey (11/2/2016)

---

Just curious, what about the right hand side? You can write a query that puts a function against a column on either side of the operand and it...

So much limitations hidden inside BOL? that I haven't even thought of !!

I did not even know these existed. Was thinking new in 2016 !!

ChrisM@Work (10/4/2016)

---

I'm sorry, I don't know the answer to your question - however, Googling revealed this interesting teaser written by Paul White. You may well find pointers (pun intended) to...