Viewing 15 posts - 2,911 through 2,925 (of 7,502 total)
seandeyoung-1145978 (8/5/2010)
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
August 5, 2010 at 2:39 am
seandeyoung-1145978 (8/5/2010)
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
August 5, 2010 at 1:56 am
We constantly run into communication problems !
That's about the biggest challenge of being a DBA :w00t:
Take a deep breath.
Now:
- refrase the question and the answer(s).
- try to use 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
August 5, 2010 at 1:14 am
BOL contains good info on indexes.
There are some nice articles on indexing at SSC :
- Introduction to Indexes (by Gail Shaw) : http://www.sqlservercentral.com/articles/Indexing/68439/
- Indexing Strategies (by Ramesh Gummadi) : http://www.sqlservercentral.com/articles/Indexing/indexingstrategies/1252/
-...
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
August 5, 2010 at 12:42 am
where isnull(TargetSafetyStockQty,0) <> 0
isnull is a proprietary version of COALESCE, but with just a single replacement value.
From BOL
ISNULL (check_expression ,replacement_value )
Check BOL: http://msdn.microsoft.com/en-us/library/ms184325.aspx
So the where clause will return only rows...
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
August 5, 2010 at 12:38 am
GilaMonster (8/4/2010)
Jack Corbett (8/4/2010)
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
August 4, 2010 at 11:22 am
Brandie Tarvin (8/4/2010)
CirquedeSQLeil (8/3/2010)
There are plenty more examples of religion associated acts of terror too (Holocaust....
I have to disagree with this statement. As an amateur historian, I don't see 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
August 4, 2010 at 4:38 am
Duran (8/3/2010)
OK, so the instances would failover and continue to be available on the one remaining node, so the hardware on each node would need to be powerful enough 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
August 4, 2010 at 3:55 am
I couldn't have done that better 😎
Very, very nice plan and bug analysis.
Who am I ? Sometimes this is me[/url] :alien: and most of the time this is...
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
August 4, 2010 at 3:35 am
That depends on your resource group settings.
By default - for sqlserver - it will be configured to become active at the onther node(s).
Keep in mind, this will be done at...
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
August 3, 2010 at 8:17 am
Jamie Wormald (8/3/2010)
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
August 3, 2010 at 8:14 am
Your disk definitions need to be in the same cluster group as the one you want to install your sqlserver instance on.
Create a cluster resource group that only holds 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
August 3, 2010 at 5:41 am
Clustering a sqlserver instance (can host multiple user databases) is no problem.
Load balancing does not exist for sqlserver.
Off course you can load balance the applications, but when they get...
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
August 3, 2010 at 5:34 am
maybe this can get you started ...
select [Server]
, JobNaam
, JobEnabled
--, last_run_date
...
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
August 3, 2010 at 1:35 am
Good point.
Those are the apps that should be documented in a failover checklist.
At least they should be mentioned in the migration/upgrade plan for the 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
August 3, 2010 at 1:05 am
Viewing 15 posts - 2,911 through 2,925 (of 7,502 total)