mburbea (5/25/2014)

---

For those looking for the fastest way to split 8k CSVs in SQL Server, I present hybrid.

Hybrid performs about TWICE as fast as Paul White's Split CLR function. And...

BTW, can someone test the physical tally table splitters as well? @paul-2 Can you be so kind to me :unsure:

SELECT TOP 11000

...

Paul White (5/14/2014)

---

I have no objections. See...

Paul White (5/14/2014)

---

Is everyone running Jeff's original/updated test rig from the article to get these results?

If so, you might not be testing what you think you are. There is a...

mburbea (5/14/2014)

---

Usman's reformation of the query to remove the union from "cteStart" and add it to the final result as has a nice appreciable gain in performance. It now seems...

mburbea (5/14/2014)

---

Usman actually seems to be right. The avg row size of the intermediate CTE tables seems to have no real bearing on the plan. THe conversion to smallint/int of...

mburbea (5/13/2014)

---

That makes sense.

After playing with the new Lead variant, my conclusion is that it seems to be slower than the mister.magoo collate latin1_general_bin version. That seems to be the...

OK, I am dragged in again by so many notifications received for this excellent never ending thread :-). After looking at the recent comments it is really fascinating to...

In case you are connecting to a source using x32 drivers, you have to use the x86 version of dtexec utility located under the Program Files (x86) folder.

kk1173 (3/8/2013)

---

I created a indexed view as suggested earlier and need help with that.

Here is my indexed view.

ALTER VIEW dbo.vFact WITH SCHEMABINDING

AS

SELECT a.MinorMkt

, SUM(ISNULL(admits,0))...

Without knowing much details, It would be all guess work. Please post DDL of the tables, some data and the required output to get better help.

But seeing your code I...

I would be tempted to use UNION ALL for such case i.e. something like

Select p.Year, p.Month, SUM(p.cramount) As Credit, SUM(q.dramount) As Debit From

(

Select b.voucherno, DATENAME(YY, a.dt) As Year,...

I guess you are missing GROUPing BY YEAR clause. Shoud not it be something like this

DECLARE @FromDate DATETIME

DECLARE @EndDate DATETIME

SET @FromDate = '2013-01-01 00:00:00.000'

SET @EndDate = '2013-02-13 00:00:00.000'

SELECT year(sd.FKDAT) As...

mister.magoo (2/22/2013)

---

Usman Butt (2/22/2013)

---

L' Eomot Inversé (2/22/2013)

---

mister.magoo (2/22/2013)

---

What bothered me was that feeling that "someone should have thought of this ages ago, shouldn't they"?

Always makes me nervous when that...

L' Eomot Inversé (2/22/2013)

---

That...