Viewing 15 posts - 1,621 through 1,635 (of 5,843 total)
You can always set up your own log shipping instead of using the built-in stuff, which can use whatever backups you already do. I had to do that for a...
February 16, 2015 at 12:41 pm
Log shipping can pull from the secondary to acquire log files on a UNC path, which presumably will remain active when your primary "dies". So you should be able...
February 16, 2015 at 11:58 am
Ozzmodiar (2/16/2015)
Assuming I went forward with log shipping, have...
February 16, 2015 at 10:46 am
Transaction log shipping. From your description that will be sufficient for your needs and is VERY simple!
February 16, 2015 at 10:34 am
Ford Fairlane (2/15/2015)
I am looking for solutions to a tricky situation.
I have a database in say Datacenter A. Probably about 300GB in size. It is running on SQL Server...
February 16, 2015 at 7:34 am
GilaMonster (2/13/2015)
TheSQLGuru (2/12/2015)
February 13, 2015 at 10:53 am
In about 20 years of working with SQL Server, mostly as a consultant at a wide variety of clients I have come across only a few systems that were CPU...
February 12, 2015 at 8:20 am
Sorry, I cannot guide you on this. It is WAY beyond a forum post, and in fact would be tens of hours of consulting at a minimum. Honestly...
February 11, 2015 at 11:40 am
Oh, beware of unindexed FK type fields. Doing iterative table scans to find things can be ugly. 🙂 Not sure if that applies here but it is general...
February 10, 2015 at 3:08 pm
1) That wasn't an "attached" query plan. Help me out here please. 🙂
2) Are the data types all proper?? Conversions can kill!
3) Maybe it would be best to DROP...
February 10, 2015 at 11:48 am
WHY do you want to implement Always On?? There are SOOO many ways you can mess that up, and lots of caveats, provisos, limitations, gotchas, etc. I have...
February 10, 2015 at 11:37 am
I have been doing SQL Server for about 20 years, most of that as a consultant at all kinds of clients. I can count on precisely zero fingers the...
February 10, 2015 at 11:35 am
Please attach the estimated query plan. My guess is index deletes are in play with the bad plan. There may be ways to assist with that.
February 10, 2015 at 11:30 am
Floats are not precise values, so I wonder if that isn't part or all of the issue.
Can you convert them to varchar(50) or something and do a string...
February 9, 2015 at 11:09 am
Make it easy for us to help you by creating tables, populating them with data (you could use Lowells work for that?) and then showing expected output from your description...
February 9, 2015 at 7:53 am
Viewing 15 posts - 1,621 through 1,635 (of 5,843 total)