Viewing 15 posts - 2,851 through 2,865 (of 7,499 total)
You may also want to have a look at the xml plan for your query.
( SET SHOWPLAN_XML ON)
Search for implicit conversions as they may cause an index not 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 12, 2010 at 9:43 am
just my 2ct:
Bit is context driven !
If your column name doesn't declare it by nature, you should document it well !
e.g. a column named "AreLightsOn" would by nature have a...
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, 2010 at 9:09 am
GilaMonster (9/11/2010)
Alvin Ramard (9/11/2010)
CirquedeSQLeil (9/11/2010)
Anybody else want to try this one?Why? The ball is in the OP's court. Nobody should make a move until he does.
Looks like he...
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, 2010 at 2:33 pm
you have been playing with maxdop, setting the max parallelism for a query, not restricting the max proc for the instance.
What happens if you restrict the numbers of proc for...
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, 2010 at 11:23 am
Indeed, setting max server memory is a must on 64-bit systems !
If only I would have noted the source ref in my script :blush:
--/* These settings are for x64, on...
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 10, 2010 at 5:23 am
There has be a similar Q last week.
They pointed to a bug in W2008R2 and proposed the following hotfix a the solution: Win2008R2_Win7_HotFix_KB2265716 http://support.microsoft.com/kb/2265716
Does this apply to 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
September 10, 2010 at 5:01 am
- Can you try out the trick Gail proposed ?
The trick is to execute the query whilest being connected to master db.
(off course you shouldn't use that in a...
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, 2010 at 2:33 pm
I'll have to hand this over to the other SSC members because I have no experience with partitioned views.
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, 2010 at 10:30 am
Steve Jones - Editor (9/9/2010)
Jack Corbett (9/9/2010)
And that would be The White Shadow, right?The White Shadow? That's you isn't it? I can still (almost) dunk a basketball.
I thought it was...
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, 2010 at 10:26 am
GilaMonster (9/9/2010)
ALZDBA (9/9/2010)
Or maybe even contact Allen White via LinkedIn.Or just think about him really hard and he'll appear. 😀
Shall I demistify the magic ?
No ... we'll talk it...
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, 2010 at 10:19 am
Or maybe even contact Allen White via LinkedIn.
Send him my regards 😀 and buy him a good beer :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 9, 2010 at 7:29 am
Did you try SQLserver BooksOnline ?
another must is the white paper at http://technet.microsoft.com/en-us/library/dd578580%28SQL.100%29.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 9, 2010 at 12:57 am
If you design it well, it may.
That's why you should especially take care of your indexes to be alligned.
This is one of the reasons why you must first read about...
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, 2010 at 12:26 am
classic answer : It depends.
In some cases partitioning may be a great solution (ent edtn only)
The problem will always be : how does sqlserver detect "date range" to filter its...
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, 2010 at 2:00 pm
AndrewSQLDBA (9/8/2010)
...The picture shows how I really feel at times ...
Welcome to the club :hehe:
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, 2010 at 1:53 pm
Viewing 15 posts - 2,851 through 2,865 (of 7,499 total)