Viewing 15 posts - 14,956 through 14,970 (of 39,970 total)
Can you snapshot the mirror db and run checkdb there to see if the same errors occur?
November 15, 2011 at 1:51 pm
First, please debug the consistency errors, and potentially call MS bfore you run this. If it cannot fix linkages, it will drop pages and remove data. Not what you want...
November 15, 2011 at 11:34 am
So the date is stored as an offset, not as '2011-11-12'.
Is the date stored as Nov 12 or Dec 11? That's what matters. The display is separate, but if...
November 15, 2011 at 11:03 am
I do that sometimes, not necessarily 10 sec, but maybe 15, or something else. It's fraught with danger, and I do end up making mistakes, but I might be talking...
November 15, 2011 at 10:33 am
November 15, 2011 at 10:14 am
If that happens, dc loses, power, I'm not sure that the mirror will pick up. The mirror will think it's lost connectivity with the witness and principal.
What you ought to...
November 15, 2011 at 10:07 am
Stefan Krzywicki (11/15/2011)
It is funny how keyboard shortcuts can baffle people. I was talking someone through writing a query in SSMS and finished with "now hit...
November 15, 2011 at 10:03 am
Gianluca Sartori (11/15/2011)
Steve, you trigger doesn't work. Both Jeff and Gail passed you, consider rewriting! 😛
😛
November 15, 2011 at 8:01 am
PhilipC (11/14/2011)
I've been doing this for a while myself, and found it very...
November 15, 2011 at 7:54 am
I like Lowell's technique, but I'd add that if you are sending this off, I'd send to a group, even if it's just a group of one. Usually I find...
November 14, 2011 at 1:42 pm
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!
+1, congrats
November 14, 2011 at 9:43 am
The products you listed don't do all three, really. #1 and #2 are SQL Monitor. I believe that #1 and #3 are more the other products. It's really a focus...
November 14, 2011 at 9:11 am
MysteryJimbo (11/11/2011)
I...Circumstances caused me to leave college and do manual work
Warehouse line worker
Forklift driver
Did those help you study/work harder?
November 14, 2011 at 9:09 am
Bill Stutters (11/14/2011)
November 14, 2011 at 9:08 am
Eric M Russell (11/10/2011)
November 14, 2011 at 9:04 am
Viewing 15 posts - 14,956 through 14,970 (of 39,970 total)