Viewing 15 posts - 2,911 through 2,925 (of 7,499 total)
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
I doubt order is of any concern with the current versions (2005/2008).
You need to keep in mind the total length of fixed data types is still restricted to 8060...
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 2, 2010 at 2:46 pm
- I would start with the SQLServer upgrade advisor (SQLUA).
This will point to potential issues with your database(s).
- I would also run the Best practice tool, to see how...
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 2, 2010 at 2:39 pm
$partacu$ (8/2/2010)
...If we specify only table_name, then the information returned from the query would be for the table under 'dbo' schema only...
One small addition to Gails reply:
If you have db-access...
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 2, 2010 at 7:50 am
Viewing 15 posts - 2,911 through 2,925 (of 7,499 total)