Quick questions, are the backups successful (check the log)? Any cleanup tasks scheduled or running? Is it the right drive?

😎

Thanks Jason, nice job testing this.

😎

Quick suggestion, have a look at this article When is a Seek not a Seek? by Paul White, sounds...

erb2000 (10/4/2015)

---

Our application has serious problems after upgrading to Sql Server 2014. We tracked it down to the huge IN clauses running very slowly. It's not easy to...

Two possible solutions

😎

USE tempdb;

GO

SET NOCOUNT ON;

--- First Create two tables

IF OBJECT_ID(N'dbo.tabA') IS NOT NULL DROP TABLE dbo.tabA;

CREATE TABLE dbo.tabA

(

cola1 NVARCHAR(100) NULL

,cola2 NVARCHAR(100) NULL

...

Quick question, can you supply some more details, the data and query posted need a little bit more explanation as the result is simply a Cartesian produce of the two...

sqllearner1234 (10/3/2015)

---

I'm using this to create a view for duplicates , but no of records coming out of this view are more than I'm passing in:(this query works fine in...

farax_x (10/3/2015)

---

I have a function which generate random number in range :

CREATE FUNCTION Func_Rand

(

@max-2 BIGINT ,

...

Jason A. Long (10/3/2015)

---

Eirikur - I'm with Chris on this one... VERY slick solution.

I have to confess that I'm baffled by optimizer's ability to do an index seek with leading...

Quick question, is this query really producing the desired result set when it is missing the filtering in the XML subqueries?

😎

Perception

Lynn Pettis (10/2/2015)

---

Because I don't necessarily want to restart SQL just to clear some of the DMVs I...

Why?

😎

joshdbguy (10/1/2015)

---

I just ran into an issue with cascading locks due to a SPID on one of my production servers. When researching the lock, I noticed that there was no...

ChrisM@Work (10/2/2015)

---

dwain.c (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

This made me spill my...