jim.riedemann (6/25/2015)

---

It still works in 2012 (my default environment and the one in which I experimented with your code). It also works in SQL 2014. I just wanted to point...

jim.riedemann (6/25/2015)

---

Very interesting resolution to a problem. I looked at your code sample with the "IF 1=0" and couldn't believe it worked. Tested it, and of course it does.

I hadn't...

Consider using CROSS APPLY instead...

Nakul Vachhrajani (6/24/2015)

---

I guess the explanation is quite simple:

Divide by 0 is not causing a problem in the SELECT clause because of the presence of EXISTS. You can have pretty...

Post your query.

Tell us how you got the results to your text file

If you can arrange the columns in the order most-searched to least-searched, start with indexes on the most-searched and add others as conditions dictate. Also, consider combinations. e.g. if...

something like this:

add a column "when datetime" to your table then:

begin tran

declare @when datetime = current_timestamp;

insert into table

exec sp_who2

update table

set when = @when

where when...

Great article. Also a great take on some of the problems ORM can cause. It's one reason I'm not a LINQ-to-SQL fan. For anything but the simplest...

Isn't this the Travelling Salesman problem or a variation thereof? That's an NP-Complete problem. No known polynomial-time solution exists and IMHO none will ever be found. For...

select Providerid, Providername, Clientid

, (Rate / count(*) over()) as [divided rate]

from table1

Giving this a bump to spark new interest

Easy but encourages a bad practice: Using an INSERT statement without a column list. OTOH if you had a column list with the two non-identity columns, the question...

OK -- so the question is clearly missing something. Here's what I tried: Create the table as given, then disable the PK:

CREATE TABLE SalesArchive

(

Salesid INT PRIMARY KEY...

Grant Fritchey (6/9/2015)

---

g.britton (6/9/2015)

---

Grant Fritchey (6/9/2015)

---

Differences in parameter values or WHERE clause criteria? Use of hard coded values or parameters (either of which is sniffed) vs. local variables (which are...

spaghettidba (6/9/2015)

---

ARITHABORT is a client setting that can be changed at any moment.

If you change your SSMS connection setting and clear the cache for that plan ( DBCC FREEPROCCACHE(plan_handle) )...