Alan.B (11/29/2016)

---

My solution can be totally optimized and simplified but here's a solution that uses DelimitedSplit8K (see the link in my signature):

You'll notice three UNION ALL's. The first query after...

Jeff Moden (11/18/2016)

---

N_Muller (11/18/2016)

---

Jeff Moden (11/3/2016)

---

I don't know if you've ever read the following but it might give you some hints about why you might not want to drop the...

Jeff Moden (11/3/2016)

---

I don't know if you've ever read the following but it might give you some hints about why you might not want to drop the Clustered Index prior...

SQL Server doesn't allow to create filtered indexes or indexes on computed columns in temp tables with ansi warnings turned off. Here's a simple example:

set ansi_warnings off

create table #temp...

If you have temp tables (#tables) with indexes in a stored procedure where ansi warnings are turned off for aggregation of null values, the procedure fails. Regardless of good...

The type of data and the quality of the queries was not on my question. Apparently if it is BY DEFINITION, then SQL Server has a bug, because it...

This is a very good article. How many times I've seen beautifully written and concise SQL that doesn't perform. As said, "our goal is not to write less...

Grant Fritchey (4/29/2016)

---

N_Muller (4/29/2016)

---

Grant Fritchey (4/29/2016)

---

I'll just pile on and agree.

The main issues I've seen are...

Grant Fritchey (4/29/2016)

---

I'll just pile on and agree.

The main issues I've seen are with multi-statement, table-valued,...

Thanks everyone for the replies. I get it that it is probably CE. By my reading, I see that most people indicate the new CE improves performance, but may...

SpeedySQL (11/4/2015)

---

You can find the SPID (SQL session ID) of the request using this script:

USE master;

SELECT

r.session_id

,db_name(database_id) db

,r.status

,r.blocking_session_id blockedBy

,r.start_time

,r.wait_type

,r.total_elapsed_time/1000 secs

,command = SUBSTRING (txt.text, r.statement_start_offset/2,

((CASE WHEN r.statement_end_offset = -1

...

Forgot to mention about the DelimitedSplit8K. I tried that as well and it still doesn't meet my performance needs. Any other suggestions are welcomed.

I fully understand that LEFT and INNER joins are different. We wouldn't have different commands to give the same result 😉

Anyhow, the problem I have is quite simple, but...

Filetable is built on top of filestream so, in principle, there shouldn't be much of a difference. The main difference is that filetables are accessible by other windows applications...

I appreciate your comment, but you still didn't answer my question. Anyhow, there are many reasons you need a recursive CTE where maxrecursion > 100. A sequential list...