peacesells (12/17/2013)

---

mister.magoo (12/17/2013)

---

That should catch the error happening, but it's not going to pass an error on to SSIS unless you specifically return an error code and handle that...

wolfkillj (12/19/2013)

---

When I looked at this (in SQL Server 2012), I was interested to see that the faster plan (using the variable in the WHERE clause) included a TOP operator...

When I looked at this (in SQL Server 2012), I was interested to see that the faster plan (using the variable in the WHERE clause) included a TOP operator between...

Luis Cazares (12/17/2013)

---

wolfkillj (12/17/2013)

---

Since SQL Saturday #272 was mentioned in the SSC e-mail newsletter today, I thought I'd mention that I'll be presenting there.

(My session is based on a...

Since SQL Saturday #272 was mentioned in the SSC e-mail newsletter today, I thought I'd mention that I'll be presenting there.

(My session is based on a similar session presented...

Koen Verbeeck (12/17/2013)

---

mister.magoo (12/17/2013)

---

Good day Threadizens 🙂

I have written an article (my first) on how to get help with SSRS reports.

It was inspired by Jeff's classic "Forum Etiquette: How to...

mister.magoo (12/16/2013)

---

Thanks for updating us with the actual location, always nice when...

N_Muller (12/13/2013)

---

I have a very complex stored procedure that it takes about 45 seconds to run the first time, and after that it takes at most a second to rerun...

nawillia (12/13/2013)

---

BIDS and SSMS could be using different ANSI settings, which could result in different execution plans (a bad one for BIDS and a good one for SSMS).

>>how...

Abdul Rahman (12/11/2013)

---

nawillia

We once had performance issues and was on a call with Microsoft on this.

I was told that SSMS is...

S t e f (12/12/2013)

---

Hi thanks for the reply.

I think it looks like an EAV as I've effectively take an attribute and changed it to a row:

Before:

Expenditure

BudgetID

FoodAmount

FoodFrequency

FoodComment

FuelAmount

FuelFrequency

FuelComment

etc...

After:

Expenditure

Expenditure

BudgetID

ExpenditureItemID

Amount

Frequency

Comment

ExpenditureItem

ExpenditureItemID

ExpenditureItemName

-------------

Has anyone come across...

Revenant (12/13/2013)

---

batgirl (12/13/2013)

---

wolfkillj (12/13/2013)

---

Ed Wagner (12/13/2013)

---

batgirl (12/13/2013)

---

Revenant (12/13/2013)

---

jasona.work (12/13/2013)

---

SQLRNNR (12/13/2013)

---

we crossed back over to positive digits a couple of...

Luis Cazares (12/10/2013)

---

Are you using SSRS to call tha procedure? SSRS might be changing your variables to the actual values in the query using the Join function. To correctly insert...

sgmunson (12/12/2013)

---

I'll assume your query produces a single record with the XML data type, and as the UNION ALL expects data types to match, and that my idea assumed a...

Wesley Middendorff (12/13/2013)

---

Well, I am a glutton for punishment and I just couldn't let something so silly ride and after thinkning about it the re-image would take just about forever...