Viewing 15 posts - 1,276 through 1,290 (of 7,503 total)
With such findings, it is best to always mention the actual engine version on which you performed the test.
Select Serverproperty('ProductVersion') as ProductVersion
, Serverproperty('ProductLevel')...
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
January 18, 2013 at 3:07 am
Here's a good article to help you to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.
It also contains an interesting...
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
January 18, 2013 at 3:00 am
- If the time interval is near constant, just start a sqlprofiler trace to capture all the needed and analyse it afterward.
- how are the backups being created at your...
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
January 16, 2013 at 12:48 pm
Isn't creation date and time information of the bak-file enough ?
To assemble a recovery requence, IMHO it is best to just pull all the needed data out of the msdb...
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
January 11, 2013 at 6:59 am
Keep in mind you cannot connect Object Browser using and admin:server\instance connection.
You must use a Query panel ( New Query ) and then connect using admin:server\instance .
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
January 11, 2013 at 3:40 am
Also with SQL2012, only a single active DAC is allowed !
only one DAC is allowed per instance of SQL Server. If a DAC connection is already active, any new request...
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
January 9, 2013 at 11:52 pm
Here's a good starter article to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.
You've posted in a SQL2005 forum. If...
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
January 4, 2013 at 1:58 am
Whenever I suspect the IO system to be unreliable, I move all DB stuff that is on it !
No doubt.
I wouldn't take the risk of down time or losing data...
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
January 4, 2013 at 12:38 am
Well, could be someone of these users is locking some critical data, blocking everybody else from processing their stuff.
Attached you can find my SP_dba_whoblocks sproc which I use on all...
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
January 3, 2013 at 2:29 am
did you check for (b)locking in your sqlinstance ?
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
January 3, 2013 at 12:04 am
DanMaxic (12/13/2012)
Please dont try use master.sys.xp_cmdshell, becouse of security reason it might be blocked.
u can use the DMV dm_exec_connections to get the info:
SELECT TOP 1 local_net_address 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
December 13, 2012 at 11:57 pm
just a very primitive tip: Start small !
Start building your disaster recovery project with a very small scope, not that critical to business activity.
Only read the headers of the...
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
December 10, 2012 at 12:49 am
Red Gate should indeed fix ALL refs it has to this wonderful resource !
1) Grant deserves it ! :smooooth:
2) The topic deserves it ! :kiss:
3) many people are looking...
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
December 6, 2012 at 10:33 am
Guess what was the first script my win-admin produced using powershell: A nice GUI :hehe:
A wpf window requesting user input.
Just like I did, he started off with...
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
December 6, 2012 at 9:39 am
Del Lee (12/6/2012)
Not sure why we are concerned about SQL Injection on this, though. I'm doing a straight INSERT. ...
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
December 6, 2012 at 8:43 am
Viewing 15 posts - 1,276 through 1,290 (of 7,503 total)