Viewing 15 posts - 1 through 15 (of 1,183 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 5, 2020 at 7:02 pm
PIVOT
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 5, 2019 at 11:05 pm
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 25, 2017 at 4:56 pm
Thanks gserdijn for the catch and fix!
It's also good...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 13, 2017 at 4:10 pm
It would behoove you to look into a PowerShell solution instead. Just my 2 cents.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 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.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 10, 2015 at 6:56 am
andreas.brandsteidl (9/14/2015)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 9, 2015 at 3:16 pm
DonlSimpson (10/9/2015)
I'm not sure if this is environmental or will always occur, but this step (!!NOTEPAD $(WorkDirectory)$(RunFile)) keeps the query executing until notepad...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 9, 2015 at 3:13 pm
bsmith 63193 (10/7/2015)
What about specifying a specific value for a column in all rows?
SELECT col1, col2, col3, 0 as newCol4, 'ABC' as newCol5 FROM yourTable
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 7, 2015 at 1:31 pm
Viewing 15 posts - 1 through 15 (of 1,183 total)