Viewing 15 posts - 121 through 135 (of 179 total)
In case you haven't seen it.
https://serverfault.com/questions/69135/what-is-the-difference-between-bulk-logged-and-simple-recovery-model-which-one/69137
In my opinion BCP requires a trip outside the database and it is a waste of resources.
January 5, 2018 at 2:58 pm
January 5, 2018 at 1:55 pm
When you run from command shell, I think it assumes the account used by SQL Server, which may not have permission to access the source directory if it is using...
January 5, 2018 at 12:55 pm
Are you looking for a change to improve yourself, or just an opportunity to do what you are good at (or interested in)? The former is a healthy choice. The...
January 5, 2018 at 12:50 pm
If these databases are being backed up regularly, from job history you can tell how long the backup part would take. For network copy, a simple test will give you...
January 5, 2018 at 12:30 pm
January 5, 2018 at 12:10 pm
I'm in an environment where the core of the business relies on leased software solutions. That means I am not allowed to do any creative stuff at all apart from...
January 5, 2018 at 12:00 pm
January 5, 2018 at 11:39 am
Let's focus on OP's question - Y or N.
I say just GO for it. OP you do have a backup, right? Please do let us know the result.
January 4, 2018 at 5:51 pm
An ounce of prevention is worth (I forgot the rest).
We have security cameras in the server room just to keep an eye on things like this.
January 4, 2018 at 4:54 pm
What scripting language is this?
Why don't you create a SQL Server Agent job and have it email you in html format directly?
January 4, 2018 at 4:50 pm
I experimented with Ola's idea form quite some time and eventually rolled my own solution in which I keep track of every index (page count, fragmentation level, time required to...
January 4, 2018 at 4:41 pm
Viewing 15 posts - 121 through 135 (of 179 total)