Good question, thanks Steve.

😎

Still some confusion in the documentation at support.microsoft.com:

The following plan affecting trace flags are available in Microsoft SQL Server 2014:

9481

Use when running SQL Server 2014 with the...

If you look at the error message, it says

D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754

when it should be

D:\ZIPPINGFILE\20140528_225754.txt.zip D:\FLATFILEGENERATE\20140528_225754

Add as space...

ramana3327 (5/31/2014)

---

Hi thanks for your reply.

Code is confidential. So I am unable to provide the execution plan but I can explain what is the problem.

I have a Stored procedure and...

You have to look at which kind of threats these vulnerabilities are! If it is a local one, normally you would have more problems already as the attacker would need...

The most noticeable thing so far is that it is ......:arrow:faster!

😎

Looks like...

Quick question, can you provide the procedure source code and the execution plans? As Jeff said earlier, without further information it is hard to tell what is going on?

Furthermore do...

Jeff Moden (5/30/2014)

---

I just love fully documented and supposedly supported features that...

Jeff Moden (5/30/2014)

---

If I understand your question correctly,...

You will have to dissect the procedure as...

Raymond.Pietrzak (5/30/2014)

---

I was able to write my query against the VarChar(4000) data type. This worked.

Update [WBPROD].[dbo].[TASK_SCHEDULE]

Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION, '<timezoneId>0</timezoneId><timezone>America/New_York</timezone>', '<timezoneId>1</timezoneId><timezone>America/Chicago</timezone>')

Update [WBPROD].[dbo].[TASK_SCHEDULE]

Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION,

...

Since this is a 2012 thread, how about the window functions?

😎

create table #sampledata

(

userId int,

BaseYear int,

TotalSales float

)

insert into #sampledata

select 1,2008,25000 union

select 1,2009,22500 union

select 1,2010,23400 union

select 1,2011,26700 union

select 1,2012,25200 union

select 2,2008,25050...

I have found that one should generally (as much as I dislike generalization) avoid AUTO_GRID.

😎

samalex (5/29/2014)

---

Everyone has their own style of writing code and doing things, but there are some pet peeves I've developed over the years, especially when I review other people's code,...

Sean Lange (5/29/2014)

---

samalex (5/29/2014)

---

Wow, I agree with literally 100% of what you guys have entered, including 'sprocs'. We have a few non-DBA's who use this verbiage, and it always makes...