Viewing 15 posts - 1 through 15 (of 1,182 total)
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...
March 12, 2020 at 2:35 pm
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...
March 10, 2020 at 1:54 pm
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...
March 5, 2020 at 7:57 pm
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...
March 5, 2020 at 7:02 pm
April 5, 2019 at 11:05 pm
August 25, 2017 at 4:56 pm
Thanks gserdijn for the catch and fix!
It's also good...
June 13, 2017 at 4:10 pm
It would behoove you to look into a PowerShell solution instead. Just my 2 cents.
May 3, 2016 at 12:42 pm
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...
December 8, 2015 at 8:25 am
Yeah, the glaring omission is the Allocation Unit Size of 64k. I've seen this missed in far too many environments.
November 10, 2015 at 6:56 am
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...
October 9, 2015 at 3:16 pm
I'm not sure if this is environmental or will always occur, but this step (!!NOTEPAD $(WorkDirectory)$(RunFile)) keeps the query executing until notepad...
October 9, 2015 at 3:13 pm
bsmith 63193 (10/7/2015)What about specifying a specific value for a column in all rows?
bsmith 63193 (10/7/2015)
SELECT col1, col2, col3, 0 as newCol4, 'ABC' as newCol5 FROM yourTable
October 7, 2015 at 3:07 pm
Phil Parkin (10/7/2015)
Jason Selburg (10/7/2015)
in this example, newCol4 and newCol5 are your non-existent columns. Using...
October 7, 2015 at 1:38 pm
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...
October 7, 2015 at 1:31 pm