Viewing 15 posts - 1,696 through 1,710 (of 7,499 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 !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 13, 2011 at 10:15 am
Chad Crawford (9/12/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 12, 2011 at 12:00 am
GilaMonster (9/11/2011)
bitbucket-25253 (9/11/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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.
http://www.sqlservercentral.com/Forums/FindPost1173017.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 9, 2011 at 6:47 am
Evil Kraig F (9/8/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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 !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2011 at 12:56 pm
Viewing 15 posts - 1,696 through 1,710 (of 7,499 total)