Viewing 15 posts - 4,141 through 4,155 (of 7,506 total)
It is a bad practise to restart sqlserver instances if not explicitly needed !
(all cached objects will need physical IO to get cached again (your apps will notice !), 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 18, 2009 at 1:56 pm
one thing that can bite you nasty is your local (temptb) copy of source data.
1) create your temp tables up front in stead of using select into.
2) only select 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
January 18, 2009 at 3:08 am
DBADave (1/16/2009)
...If they don't I will turn off auto grow and restart the instance and see if this resoves the issue of the files not growing proportionally....
turn off auto...
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, 2009 at 7:33 am
the article has been mentioned by Nicholas Cain in one of the previous replies.
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx)
Nicholas Cain (1/15/2009)
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, 2009 at 6:45 am
Nicholas Cain (1/15/2009)
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, 2009 at 2:06 am
The tricky part for most of us is: How do you size your tempdb ?
Nicholas Cain (1/15/2009)
...My tempdb is vastly larger than it will ever need to be. ....
Do you...
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, 2009 at 1:55 am
Phillip Oyog (1/15/2009)
This is my first post ever on SqlServerCentral so bear with me. We have a high-availability mirror set up in our office running on Windows 2003 srvr...
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, 2009 at 1:46 am
What I intended to show is that sqlserver handles it diferently if it as no table content data.
After create it states
Checking identity information: current identity value 'NULL', current column value...
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, 2009 at 1:02 am
an in place upgrade inherits some settings from sql2000. The goal (from ms) is to keep it working !
With a fresh install of sql2005, it will implement best practises and...
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, 2009 at 12:14 am
Indeed, freeing the proc cache cause all sql (including sprocs) to be re-evaluated for a plan the next time they execute.
With well organized indexes (including clustered please) and up 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
January 15, 2009 at 12:51 pm
did you free the db's proccache after the reindex ?
Possibly the old cached plans nolonger serve optimal with the new statistics and organisation.
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 15, 2009 at 10:39 am
Mahi (1/14/2009)
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 14, 2009 at 2:47 pm
raymond.lew (1/14/2009)
Hello, I have an identity problem.
Who doesn't every once in a while 😉
Maybe this helps you figure out what's going (wr)on(g).
SELECT @@VERSION
GO
IF OBJECT_ID ('id_test') IS NOT...
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 14, 2009 at 2:31 pm
GSquared (1/14/2009)
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 14, 2009 at 2:10 pm
SELECT A.SOLD_TO_CUST_ID
, C.NAME1
, DATEDIFF(DAY, ( CONVERT(CHAR(10), B.STATUS_DT, 121) ), GETDATE()) as DtDiff
...
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 14, 2009 at 6:40 am
Viewing 15 posts - 4,141 through 4,155 (of 7,506 total)