Viewing 15 posts - 4,186 through 4,200 (of 7,499 total)
GilaMonster (1/7/2009)
...Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
Aarch... yes, overlooked...
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 7, 2009 at 3:17 am
You need to dig deeper into the backup file content.
Can you post the results of
restore headeronly
from disk=...
RESTORE VERIFYONLY
from disk=...
restore labelonly
from disk= ...
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 7, 2009 at 3:12 am
Kinnari Thaker (1/7/2009)
Restore Databasefrom disk = 'D:\Dr. Acharya\ManCanDoSql.bak'
I also tried the above command with 'with replace'
It should be :
Restore Database YOURDBNAME
from disk = 'D:\Dr. Acharya\ManCanDoSql.bak'
But you should first figure out...
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 7, 2009 at 2:14 am
Searching if this bug was know by MS, I stumbled onto:
http://support.microsoft.com/kb/951188
This kb does not 100% describe the symptoms I experienced, it states the hotfix was included in Cumulative Update 7.
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 7, 2009 at 2:06 am
Lynn Pettis (1/6/2009)
ALZDBA (1/6/2009)
Lynn Pettis (1/6/2009)
This may be a dumb question, how do I get to the files in the exe file? I've never had to do that before.
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
January 7, 2009 at 1:37 am
GilaMonster (1/7/2009)
ALZDBA (1/7/2009)
However there may be a TEMPORARY bypass by using the startup parameter that has been provided for the "views with order by nolonger work" problem.
With one caveat:
From 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 7, 2009 at 1:04 am
sqlcool (1/6/2009)
is it acceptable?
how to make it better performable?
if indexes cannot be dropped and essential for the system is there ay other...
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 7, 2009 at 12:49 am
Once again a UDF got you in troubles because of hidden joins !
You should really rework that to proper joins in you calling queries and get control over you queries.
However...
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 7, 2009 at 12:42 am
Like Gail said, you should first figure out if that is the cause of you cpu hog.
Use SQLserver profiler and Windows perfmon to figure out what's goin on !
You could...
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 7, 2009 at 12:29 am
Kinnari Thaker (1/6/2009)
I get following error when i try with query analyzer:
'It is not recognized resotre option'
what does...
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 7, 2009 at 12:23 am
Better would be to use the information schema views.
Keep in mind that sql2005 only show object definitions you are granted to view.
(view definition granted)
Is this what you're looking for ?
SELECT...
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 6, 2009 at 1:22 pm
Lynn Pettis (1/6/2009)
This may be a dumb question, how do I get to the files in the exe file? I've never had to do that before.
I don't know 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
January 6, 2009 at 12:56 pm
Ells (1/5/2009)
I have read Gails post and very informative it is. I will look at the other blog. I have a feeling that there are no trasaction log backups...
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 5, 2009 at 6:19 am
Paresh Randeria (1/5/2009)
If not than do we have any better alternatives?
I am working on Datawarehouse application where previous DAY...
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 5, 2009 at 4:27 am
Gail explained the basics very well at http://www.sqlservercentral.com/articles/64582/
btw you need to take log-backups to clean up the log files content !
If you don't, they will be growing on 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 5, 2009 at 4:17 am
Viewing 15 posts - 4,186 through 4,200 (of 7,499 total)