GilaMonster (11/24/2015)

---

Nothing to do with transactions. That's a parse-time error (well, binding phase, not the parser itself). The parser sees that the object is being created twice as it parses...

There are no SQL Server MVPs anymore! We're Data Platform MVPs now!!

Microsoft has embraced a hybrid approach with Polybase

o103452 (11/17/2015)

---

Hi Gerald,

That's a good idea, not all of the packages always use the new attributes. Is there a solution for the packages that are going to use the new...

If you are not using the new elements/attributes, consider remapping the new XML into the one you want, perhaps using XSLT

batch updating is kinder to other, concurrent activities. If a bulk update takes 5 minutes, that's 5 min that other queries might wait to do their thing

ON (1=1)

makes the join a cross-join

Got an index on the date column? Otherwise you'll get a table scan, I think. Check the exec plan

Sean Lange (11/6/2015)

---

Unless they meant to type the full name and fat fingered the a...

Cool part? Or Dangerous part? ...

What's FOCM? I can't find that acronym

How is the service configured for Log on (check the Services applet)

Because the whole command is being assigned to a variable and is quoted. You need to double-quote inside a quoted string to get a single-quote out

Iulian -207023 (11/4/2015)

---

g.britton (11/4/2015)

---

Carlo Romagnano (11/4/2015)

---

If I want to be pedant, the right answer is "All of the above".

Because of lacking of batch separator "GO".

If you run the script no...

+1....

vsamantha35 (11/3/2015)

---

Hi Gerald,

1 last question,

1. Suppose if I want to list out the jobs which has to run on a <<specific date>>, how to pull that info using...