Viewing 15 posts - 9,886 through 9,900 (of 39,803 total)
cbowman (4/7/2015)
I am curious to know what CI tools and/or processes you all are using on your database and if those tools are working well. We are using MS...
April 7, 2015 at 7:10 am
Thanks for the note, Phil. Missed that in a review.
April 7, 2015 at 7:05 am
I'd try restarting this. You can check the target v total server memory as well and see if the server appears starved.
April 2, 2015 at 12:49 pm
Strange. Consistently reproducible?
Can you reboot the instance/host and try it? I'd learn towards transient error unless it continues.
April 2, 2015 at 12:47 pm
As far as I know, this is correct. You can have some AG nodes in an FCI and some not. I didn't see an MSDN reference, but probably one somewhere.
I...
April 2, 2015 at 12:46 pm
Are you sure that the correct log files are being copied to both server B and C? It almost seems like a file isn't getting to C, and then the...
April 2, 2015 at 12:41 pm
I learn toward Erland's last suggestion. Another schema.
April 2, 2015 at 12:35 pm
If you don't want data, I'd say use the native scripting features to script the database and build the objects (or use something like SQL Compare).
I might still do this...
April 2, 2015 at 12:34 pm
David In BC (4/2/2015)
After...
April 2, 2015 at 12:27 pm
I'm not sure it's one way or the other. Does SOA work for banks? Probably not for some things, good gor others. It's really a decision for building a strong...
April 2, 2015 at 9:40 am
SQL-DBA-01 (4/1/2015)
Bad day for me. I lost 7 points. I selected option - (c). 🙁 🙁
You never lose points. Only miss out on gaining them.
April 2, 2015 at 8:19 am
SPs have tended to be low risk. There's a chance they fix a bug you've built a workaround to and that breaks, but usually they've either worked well or the...
April 1, 2015 at 8:03 pm
One other thing you could try is a small table (or series of tables) that give the oldest valid date for a table. Then join to that.
In other words, if...
April 1, 2015 at 11:34 am
Yet Another DBA (4/1/2015)
April 1, 2015 at 11:29 am
You are welcome, and good list. The one thing I might add is to run through specific steps, or use a trace from the 2005 server and execute this against...
April 1, 2015 at 11:26 am
Viewing 15 posts - 9,886 through 9,900 (of 39,803 total)