Sounds like a data mining problem. That subsystem has been included with SQL Server since, what, SQL Server 2000? And almost no one is using it!! Not using that is...

ryanjb1989 (8/19/2015)

---

I have been asked to create a report for one of our clients. The report is pretty basic but I am concerned about the overheads with my planned approach.

The...

I still don't...

Tim Walker. (8/19/2015)

---

GilaMonster (8/19/2015)

---

Don't use the Profiler GUI against a production server. It can and will cause problems, up to and including crashing the server (I've done it). Statistics profile...

Can't do anything with a picture. But a scan doesn't necessarily mean what you think sometimes. What is the actual row count entering that table on the loop? What is...

IMPLICIT CONVERSIONS can be a REAL shock and PAIN-CAUSER in SQL Server. The alternative is getting the wrong answer with no warning or error (which is by FAR the worse...

Tim Walker. (8/19/2015)

---

Is the SQL Server Profiler Reads Column Incorrect For Parallel Plans?

I often use profiler as one tool to help identify bad plans. The reads column gives me a...

Ken at work (8/18/2015)

---

I'm not sure what...

assuming both datatypes ARE real, cast the hard-coded values in the isnulls to the same datatpye - not the result of the isnull.

Yes, yes it does! 😎

1) Have you patched up SQL Server (and Windows)?? There were quite a few patched bugs with AGs.

2) When you set things up, did you follow the LARGE amount of...

ramana3327 (8/18/2015)

---

Hi,

We have 4 node cluster with sql cluster in always on. How do you maintain an this hadr? In addition to that we are using logshipping to different server...

GilaMonster (8/17/2015)

---

I'd still recommend you put a CASE around the division (see my edits in earlier post), as a plan change could still result in the division happening before the...

What is the code of the referenced objects too? They could be got-knows-what-containing views/mTVFs, etc.

1) We need create table script and sample data to help with a query.

2) Why use integers for what looks to be a Boolean (isDay)? VERY inefficient data type choice...