Viewing 15 posts - 1,696 through 1,710 (of 7,502 total)
kapfundestanley (9/13/2011)
Are you saying is the principal has been changed to mirror,it will be still accessible?
Only "transparent" when you specify failover partner in the connection string !
September 13, 2011 at 10:15 am
Chad Crawford (9/12/2011)
September 13, 2011 at 7:40 am
... All we need is sample data... waiting on you to provide, and then there will be some awesome sql learning going on in this thread!
That wouldn't need to be...
September 13, 2011 at 12:14 am
Gianluca Sartori (9/12/2011)
ALZDBA (9/12/2011)
Way to go, Gianluca !http://www.sqlservercentral.com/Forums/FindPost1173218.aspx
--> http://www.sqlservercentral.com/Forums/FindPost1173217.aspx
Glad you liked it. 😉
I'm sure Mr. Celko won't understand, though.
Just insert a fake ISO subject to get him started .... :w00t:
September 12, 2011 at 7:05 am
Way to go, Gianluca !
http://www.sqlservercentral.com/Forums/FindPost1173218.aspx
--> http://www.sqlservercentral.com/Forums/FindPost1173217.aspx
September 12, 2011 at 5:16 am
Are you in for some Powershell ?
I am using Quests free PowerGUI and this works like a charm !
You will have to download and copy/paste Chad Miller's great Invoke-SQLCMD2 from...
September 12, 2011 at 3:01 am
If you manage to lose the dynamic sql part, you may be able to write this proc using a single sql statement !
(IMO the MD5 handling will not be indexable...
September 12, 2011 at 12:17 am
Ninja's_RGR'us (9/11/2011)
Try having 2K+ of unexpected repair on your car, having to lose 1 weeks income + all the trouble to be flooded by Irene while getting...
September 12, 2011 at 12:00 am
GilaMonster (9/11/2011)
bitbucket-25253 (9/11/2011)
September 11, 2011 at 12:49 pm
:sig:
The one who's name thow shall not state felt the need to kill a forum newbe with ancient history and lousy advise.
September 11, 2011 at 2:01 am
As Gail stated, it may depend on what your sproc is doing.
If you can get a grip on that, you may be able to tackle your cursor problem.
If you...
September 11, 2011 at 1:40 am
BTW this topic has been discussed at the first day of 24HOP [/url](24 hours of PASS free online training sessions)
Session 09 - Start time 20:00 GMT on Sept 7
title: So...
September 9, 2011 at 6:47 am
Evil Kraig F (9/8/2011)
September 8, 2011 at 11:59 pm
I've seen systems where regular DWH processing is being halted during the load window.
This way they free up resources on the dwh server and run ETL at that box to...
September 8, 2011 at 11:58 pm
looks and feels like a regular sp install.
edited:
so, as always, start with a full backup of all your db !
September 8, 2011 at 12:56 pm
Viewing 15 posts - 1,696 through 1,710 (of 7,502 total)