micang (2/11/2016)

---

SQL 2008 R2

Hi All,

If I have a query like so:

select contractno, Address1,dateJoined,DateLastTrans

from tableTest

where datejoined between 2012-12-01 and 2015-12-31

and my results are:

Contractno,address1,datejoined,dateLastTrans

387, johnroad, 2013-06-01,2016-01-25

267, bobroad, 2015-12-01,2016-01-25

267, bobroad, 2015-12-01,2015-12-28

578, ellenroad,...

I had a client GO OUT OF BUSINESS because all of their triggers were built with the variable problem. And I TOLD them it was going to happen before it...

join the date-range table to itself and have a WHERE clause that checks for a.start >= b.start and a.end between b.start and b.end. Or something similar to that. Play with...

My first guess is that the original plan was "good enough" in that it ran consistently at 50 seconds. But when you altered things you got a new plan and...

patla4u (2/10/2016)

---

Hi All,

I have total 460 million row in the table. I am running query for year 2016 and month = 7 and we have total 8 millions records. query...

ffarouqi (2/9/2016)

---

Come on brother!. At least now I am expecting a better answer after posting so many...

LSAdvantage (2/8/2016)

---

I’m a new member on a team and came across the following query (which I’ve obfuscated) in a stored procedure and immediately thought I would be able to add...

When you get the chance, here's some great material for you to review:

http://www.sommarskog.se/query-plan-mysteries.html

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

some may or may not be documented. I would do a web search on paul randal sql server spinlock and go from there.

SQL!$@w$0ME (2/8/2016)

---

hi Guys,

Is it a good practice to change the default fill factor value on Instance level?

Should the Primary key field (IDENTITY KEY) set to fill factor value of 100?

Any...

I am traveling and cannot take the risk of installing the SSMS Addin at the moment.

OP:

I would still like to see a screenshot and text version of what you expected...

I am not sure exactly what SSMS Add-In you are speaking of. Can you give the exact full name and/or company/developer and/or a URL for it? Maybe a screenshot that...

You can read the top posts when you search for that string of words I gave you. You are doing one of the two usual ways of doing this, and...

This is a CLASSIC data processing problem known as an UPSERT. There are a BUNCH of issues with it related to concurrency. Almost every client I have seen this type...

Could be one of many hundreds of waits caused by even more things and in any permutation.