Viewing 15 posts - 4,186 through 4,200 (of 7,506 total)
RBarryYoung (1/7/2009)
They sure don't say much about it though, do they?
Indeed, looks like a moment where a dba just quickly mumbles "and there was this little other thingy we fixed...
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:48 pm
jeffrey yao (1/7/2009)
WOW, that sounds a bug of sql server 2k5 itself. I am glad we have SP2 + CU10. 🙂
keep in mind, if you go to SP3, you must...
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:45 pm
Perry Whittle (1/7/2009)
ALZDBA (1/7/2009)
Truncation usually occurs after each checkpoint but can be delayed under some conditions
this is the key here, it should and generally does but there can be instances...
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:42 pm
What's your db collation ??
(case sensitive , accent sensitive, ... ??)
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 11:49 am
Perry Whittle (1/7/2009)
as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run...
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 11:46 am
- Set up your service account security decently.
Give each instance its own set of accounts, also keep at least sql-user-passwords different per instance.
- also keep in mind, by applying e.g....
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 11:32 am
Still you need to investigate why there is no range joining for ranges that deffer only 1 day (end to next start).
I've messed around this procedural code, and all matching...
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 6:05 am
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
Viewing 15 posts - 4,186 through 4,200 (of 7,506 total)