Viewing 15 posts - 3,556 through 3,570 (of 39,898 total)
What's the issue? There shouldn't be much of a difference, or really any, once you're connected. The alias and hostname resolve to an IP+port for the eventual communication.
September 13, 2019 at 2:48 pm
When I'm in the Redgate office, we have an open plan. I either wear headphones, which sometimes work, or go find a small cube. We have a few available for...
September 13, 2019 at 2:47 pm
As Phil mentioned, it's good to see what the data is. What I usually want is
-- base data
insert table values (a, 1), (b, 2), (c, 3)
--- results
create...
September 13, 2019 at 2:44 pm
Yet.
Remember to use the word yet when you have goals or impediments. People might not want to change, yet, but perhaps they will over time. Many things happen on the...
September 12, 2019 at 3:36 pm
This might help: https://stackoverflow.com/questions/182750/map-a-network-drive-to-be-used-by-a-service/4763324#4763324
If you want a mapping to persist, there's a flag. You need to be logged in as the user to do this.
September 12, 2019 at 3:19 pm
By default, the agent maintains 9 logs. Each time the service starts, it creates a new log and discards the oldest one.
If you recycle manually once a week, you should...
September 12, 2019 at 2:57 pm
September 12, 2019 at 2:50 pm
These will capture information, and it may be useful here. However, the length of the query doesn't necessarily impact the log growth. It can, but the log growth is a...
September 12, 2019 at 2:27 pm
Is hyperthreading enabled? The product has been shown to work with hundreds of cores. I think you're missing something in your view.
September 12, 2019 at 1:57 pm
Was there any long running query? I see some bad queries sent from the web server that tie up the SQL Server. Maybe not peg things, but they just take...
September 11, 2019 at 9:07 pm
Smelly
Flew back from London to find a generator not working. Had to load it up to take to the repair guy at lunch and spilled gas on my hand. My...
September 11, 2019 at 9:00 pm
Not seeing this in FF, Chrome, Edge. It's possible you have some security limitations that could cause this or something else, but the site appears to be working for me.
September 11, 2019 at 8:57 pm
You can script out the objects and make changes, but this is not a rollback. It's a roll forward.
If you are just changing procs/functions/views, just make a dacpac of the...
September 11, 2019 at 8:56 pm
Viewing 15 posts - 3,556 through 3,570 (of 39,898 total)