Viewing 15 posts - 4,291 through 4,305 (of 7,499 total)
mohinidba (11/24/2008)
how to i move temp db.the link is not opened
That only means you haven't got Books Online installed on your pc.
No problem. You can find it online at http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).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
November 24, 2008 at 11:51 pm
Congratulations Jonathan !
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
November 24, 2008 at 1:41 pm
I'm just popping a first glimps.
Why should a function that only returns a fixed date, return a NULL value if the input is null and the input is not checked.
Correct...
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
November 24, 2008 at 1:31 pm
are you member of the db-ower db group or sysadmin at the production instance ?
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
November 24, 2008 at 1:24 am
It is a best practice to have tempdb on its own drive(s).
Yes it is for performance. (cfr like you would separate page files from C-drive)
Keep in mind: every instance user...
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
November 24, 2008 at 1:07 am
are you using a maintenance plan for this ?
If yes, upgrade to at least Cumulative Update 2 for sp2 (current is CU10, sp3 is in beta.)
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
November 23, 2008 at 1:31 pm
Very good summary.
I hope I'll get another chance next year.
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
November 23, 2008 at 1:23 pm
Jack Corbett (11/22/2008)[/b...Yeah, you definitely traveled a loooong way to make it to PASS. Would you do it even if you weren't presenting?
PASS is always a hard week because...
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
November 23, 2008 at 6:43 am
just my 2ct to add to the previous replies....
- double check the nic cables to see if the connectores are fixed.
- check for hardware firmware know issues and upgrade if...
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
November 23, 2008 at 6:29 am
Once again a statement that makes 100% sense.
"Let the first one without sin throw the first rock."
Few rocks will be thrown:Whistling:
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
November 21, 2008 at 12:39 pm
Arthur.Lorenzini (11/20/2008)
It needs to fetch extra datapages to get cd.salesman_employee_id.
If you comment it out, it will solve the query index only for table customer_detail.
How up to date are your statistics...
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
November 20, 2008 at 1:54 pm
DBASkippack (11/20/2008)
BACKUP DATABASE MyDB TO DISK =
'D:\MyDB_01of04.bak',DISK='D:\MyDB_02of04.bak', DISK='D:\MyDB_03of04.bak', DISK='D:\MyDB_04of04.bak' WITH INIT, NOFORMAT
Unfortunately, my RESTE IS NOT WORKING. I...
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
November 20, 2008 at 1:42 pm
randy.witt (11/20/2008)
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
November 20, 2008 at 1:37 pm
very good info.
Thanks
Johan
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
November 20, 2008 at 5:09 am
I see you did discover the dbmail helper objects 😉
- Does it succeed if you use a vbs to send mail using that smtp server ?
- double check the port...
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
November 19, 2008 at 11:56 pm
Viewing 15 posts - 4,291 through 4,305 (of 7,499 total)