Viewing 15 posts - 76 through 90 (of 236 total)
I assumed you double checked as you say it's idle, but did you make sure there aren't other jobs or processes kicking off at the same time the index is...
February 27, 2015 at 10:45 am
Make sure to take a look at AWS and AZURE. If your DB doesn't need to be up constantly and is a small size, the prices for online services may...
February 26, 2015 at 5:54 pm
I've always created "temporary" (not really temporary) tables, or used dev/test databases to test performance. It's not perfect but you can easily see whether a clustered index will increase performance...
February 26, 2015 at 5:43 pm
Luckily we found a backup of the keys. Thanks for the assistance. I have a lot of adjustments to make on my end to mitigate this issue in the future.
February 6, 2015 at 9:28 am
Backups were in place. Other issues caused the problem.
It's in the SSISDB catalog. I also can't export without the master key.
February 5, 2015 at 9:19 am
Perry Whittle (2/5/2015)
JoshDBGuy (2/5/2015)
Unfortunately it had to be rebuilt.Once you rebuilt the system databases you should have restored master from a backup, I'm guessing you didn't?
Could not, inherited system, issue...
February 5, 2015 at 9:13 am
Unfortunately it had to be rebuilt. It's a long story but there was no way to recover the master db.
February 5, 2015 at 9:10 am
I'd like to. The issue is that the user needs to be able to modify all sql agent jobs. I've tried to do this with msdb permissions to SQLAgent but...
February 4, 2015 at 2:49 pm
Phil Parkin (1/20/2015)
JoshDBGuy (1/20/2015)
Koen Verbeeck (1/20/2015)
JoshDBGuy (1/20/2015)
That's going to be a nightmare, I'd prefer to not do that.I'm not sure why a SQL Server instance would be a nightmare.
It's not...
January 20, 2015 at 12:02 pm
Koen Verbeeck (1/20/2015)
JoshDBGuy (1/20/2015)
That's going to be a nightmare, I'd prefer to not do that.I'm not sure why a SQL Server instance would be a nightmare.
It's not a nightmare, that...
January 20, 2015 at 11:48 am
That's going to be a nightmare, I'd prefer to not do that.
January 20, 2015 at 11:18 am
What's the buffer size that you're using? For a source, if the source is slow and you set the buffer to be large, it can take a really long time...
January 20, 2015 at 11:09 am
Phil Parkin (1/20/2015)
JoshDBGuy (1/20/2015)
Phil Parkin (1/20/2015)
JoshDBGuy (1/20/2015)
January 20, 2015 at 11:01 am
Phil Parkin (1/20/2015)
JoshDBGuy (1/20/2015)
January 20, 2015 at 10:42 am
Could you be a little more specific? Are you having issues setting it up? The functionality should work the same as any other database in the Availability Group.
January 20, 2015 at 10:01 am
Viewing 15 posts - 76 through 90 (of 236 total)