Viewing 15 posts - 2,911 through 2,925 (of 7,506 total)
Brandie Tarvin (8/6/2010)
GilaMonster (8/6/2010)
Brandie Tarvin (8/6/2010)
I have to wonder how many times a single record is split because not all the data will fit on a page.
Not permitted (except row...
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 6, 2010 at 4:59 am
As a rule of thumb I have the magical number "7" 😀
Meaning, if you need more than 7 indexes, you'll have to expect troubles and take things more in 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
August 6, 2010 at 4:18 am
Gianluca Sartori (8/6/2010)
GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.
Access is often a trojan...
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 6, 2010 at 4:12 am
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!Wish me luck!!
Best of luck with the new challenge !
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 6, 2010 at 3:18 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 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
Viewing 15 posts - 2,911 through 2,925 (of 7,506 total)