IMHO, both roles should understand how to tune queries. Of course, depending upon your organization you might be limited on the tools available, but understanding proper query writing should be...

If the objects' structure is dynamic via your application code then SSDT will be out of synch anytime you modify or create them. The only way is to perform a...

If you search this site for "Data-Driven Subscriptions using Standard Edition" you'll find a few articles covering different approaches. One of which I wrote quite a while ago. All should...

As luck would have it, I recently completed a project doing just this. I can not share the details as it was for another client, but I can certainly tell...

PIVOT

Thanks gserdijn for the catch and fix!

It's also good...

It would behoove you to look into a PowerShell solution instead. Just my 2 cents.

Double check your base subscription in the UI. You must have missed something syntactically. If I remember correctly, these errors were usually caused by typos but regardless, they almost ALWAYS...

Yeah, the glaring omission is the Allocation Unit Size of 64k. I've seen this missed in far too many environments.

andreas.brandsteidl (9/14/2015)

---

Hello!

Thx for the way how to call several script files!

My question is: How can I or what is the best way to catch an error in one...

DonlSimpson (10/9/2015)

---

Great script, really useful in our shop.

I'm not sure if this is environmental or will always occur, but this step (!!NOTEPAD $(WorkDirectory)$(RunFile)) keeps the query executing until notepad...

SELECT col1, col2, col3, 0 as newCol4, 'ABC' as newCol5 FROM yourTable

Phil Parkin (10/7/2015)

---

Jason Selburg (10/7/2015)

---

SELECT col1, col2, col3, CAST(NULL as BIT) as newCol4, CAST(NULL as VARCHAR(6)) as newCol5 FROM yourTable

in this example, newCol4 and newCol5 are your non-existent columns. Using...

SELECT col1, col2, col3, CAST(NULL as BIT) as newCol4, CAST(NULL as VARCHAR(6)) as newCol5 FROM yourTable

in this example, newCol4 and newCol5 are your non-existent columns. Using the CAST, ensures that...