Viewing 15 posts - 9,121 through 9,135 (of 59,078 total)
There is a JAVA app that clears and reloads a staging table, but occasionally it fails to reload. So I am trying to figure out a way that will...
June 18, 2019 at 4:30 am
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"
What did...
June 18, 2019 at 4:25 am
If you're not using at least SQL Server 2012, the feature/syntax doesn't exist prior to that. You say you're using v17 but what is that for? SSMS? That's not what...
June 18, 2019 at 4:15 am
Mya be you have some different collation or timezone setting. Here is what I am getting. 6/14/2019 5:00:00 PM
My recommendation would be to rewrite it so that it does...
June 17, 2019 at 4:16 pm
So I come across this thread nine years and several iterations of SSMS after the event, totally fed up with having to restart SSMS repeatedly, often losing work along...
June 17, 2019 at 2:10 pm
Perhaps for the same reason jackrabbits run in front of cars?
Heh... and squirrels. 😀
June 17, 2019 at 1:37 pm
To answer the logically next expected question...
https://www.google.com/search?&q=save+powershell+output+to+table+in+sql+server
Of course, I don't have a code example for this because I don't use PowerShell to do such things, especially since the list...
June 17, 2019 at 1:12 pm
Heh... perhaps the next article should be about the delays of ghost row cleanups. 😀
June 17, 2019 at 12:31 pm
I'll never understand why some people write 100's of lines of code without testing the code before turning it into a stored procedure or whatever and wether or not there...
June 17, 2019 at 12:14 pm
I'm going to suggest that you DON'T make such an over-arching delete system. There may be a need for different instances/systems to do the deletes of old backup files on...
June 17, 2019 at 12:17 am
p.s. Since the forum software still provides no easy method back to the article being discussed, here's the link to the original script article, if anyone is interested.
https://www.sqlservercentral.com/scripts/add-working-days-but-avoid-holidays-2
June 17, 2019 at 12:11 am
Thought I'd throw my 2 cents in from a presentation I did nearly a decade ago and it still works to allow the secure operation of xp_CmdShell. Here's the full...
June 16, 2019 at 11:40 pm
It also depends on what the package is doing...and whether or not I have to connect to SQL Server for other configuration values.
That same thought is usually the justification...
June 16, 2019 at 3:08 pm
I would like to know if corruption/unavaialability of one partition would impact whole DB? Will I still be able to access rest of the partitions? Can I take one...
June 15, 2019 at 12:01 am
Hmmph... additionally, the "Free" online version is limited to 100 lines of code. The non-free versions aren't expensive but, considering the bug I found above, I wouldn't spend a nickle...
June 14, 2019 at 11:51 pm
Viewing 15 posts - 9,121 through 9,135 (of 59,078 total)