Viewing 15 posts - 2,041 through 2,055 (of 5,843 total)
Here is a link to a SQL Saturday session I did on new and enhanced features of SQL 2014. If you are on enterprise edition there are some substantial...
May 18, 2014 at 9:17 am
Please start a new thread instead of posting to one that is a year old.
May 17, 2014 at 1:11 pm
GilaMonster (5/16/2014)
May 16, 2014 at 6:58 pm
Looks like it took me just a bit longer than Robert and Gail to craft my "you probably shouldn't be doing this work (alone)" reply.
OP: You just had...
May 16, 2014 at 1:04 pm
OP: Sorry to be blunt but I have to ask: are you SURE that you are qualified to be setting up DR for this client? You are doing...
May 16, 2014 at 12:56 pm
Are you sure you have an "Active/Passive" failover cluster service or application in place (i.e. SQL Server Failover Cluster Instance et al) since you say you DON'T have Always On...
May 15, 2014 at 7:36 pm
1) Check Connect to see if there are any similar issues posted there.
2) I would not expect this to be improved by Microsoft.
3) This could also be because of your...
May 15, 2014 at 1:55 pm
Post up a screen shot of the tool you are using that you described in the first post.
As for Always On, see here for DMVs you can use to get...
May 15, 2014 at 1:50 pm
1) You cannot have a PK on a NULLable column. Fix the column attributes or do something different.
2) Partitioning is a VERY COMPLEX subsystem! You are...
May 15, 2014 at 1:02 pm
If you screw something up when dealing with HA/DR the company can lose a tremendous amount of revenue (and even wind up going out of business). I have a...
May 15, 2014 at 12:57 pm
Adding to what Grant said, there are some HORRIBLY bad design and coding choices here. Some of them you will likely have no (easy) hope of overcoming.
In...
May 15, 2014 at 12:52 pm
I don't work for Red Gate (although I am a Friend) and I can recommend their Source Control product too.
May 14, 2014 at 9:40 am
1) Permissions?
2) Patch up to latest build?
3) Check Connect for a similar issue?
May 14, 2014 at 6:37 am
raysteve43 (5/13/2014)
May 13, 2014 at 12:24 pm
Viewing 15 posts - 2,041 through 2,055 (of 5,843 total)