Alvin Ramard (9/1/2015)

---

Sean Lange (9/1/2015)

---

Alvin Ramard (9/1/2015)

---

SQLRNNR (9/1/2015)

---

GilaMonster (9/1/2015)

---

Ed Wagner (9/1/2015)

---

ZZartin (9/1/2015)

---

Now if only all websites used the same algorithm to determine whether a...

Well...we haven't actually seen the query so I can't say there is no...

Thugs (9/1/2015)

---

DECLARE @Tab1 table (ID Int , PS varchar(10),NPS1 varchar(10), NPS2 varchar(10))

INSERT INTO @Tab1

SELECT 1, 'A', 'B', 'C'

UNION ALL

SELECT 2, 'D', 'E', 'F'

UNION ALL

SELECT 3, 'G',...

bwhiteside (9/1/2015)

---

Hi. We recently upgraded our ERP and went from using SQL Server 2008 to 2014. In addition, we upgraded our hardware (faster, better everything). Suddenly all of the queries...

Alvin Ramard (9/1/2015)

---

SQLRNNR (9/1/2015)

---

GilaMonster (9/1/2015)

---

Ed Wagner (9/1/2015)

---

That's...

ScottPletcher (9/1/2015)

---

Honestly, though, I still think that overall the "use identity as the 'default' clustering key" myth is even more damaging than an "almost always use NOLOCK" myth. Improper...

ScottPletcher (9/1/2015)

---

Sean Lange (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Sean Lange (9/1/2015)

---

Munabhai (9/1/2015)

---

drop table #temp

CREATE TABLE #TEMP

(

date1 DATE,

date2 DATE

)

insert into #TEMP values

('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

SELECT date1, date2,

CASE

WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01')...

ScottPletcher (9/1/2015)

---

Sean Lange (9/1/2015)

---

Munabhai (9/1/2015)

---

drop table #temp

CREATE TABLE #TEMP

(

date1 DATE,

date2 DATE

)

insert into #TEMP values

('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

SELECT date1, date2,

CASE

WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01') THEN 0...

Ed Wagner (9/1/2015)

---

Alvin Ramard (9/1/2015)

---

Lynn Pettis (9/1/2015)

---

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't want to...

Munabhai (9/1/2015)

---

drop table #temp

CREATE TABLE #TEMP

(

date1 DATE,

date2 DATE

)

insert into #TEMP values

('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

SELECT date1, date2,

CASE

WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01') THEN 0

WHEN ISNULL(date2, '1900-01-01')...

Matt Miller (#4) (9/1/2015)

---

Sean Lange (8/31/2015)

---

Matt Miller (#4) (8/31/2015)

---

Sean Lange (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page....

Matt Miller (#4) (8/31/2015)

---

Sean Lange (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums, quite...

Brandie Tarvin (8/31/2015)

---

Ed Wagner (8/31/2015)

---

Sean Lange (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums,...

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums, quite a few others are as...

spam reported