Forum Replies Created
Viewing 15 posts - 5,656 through 5,670 (of 7,499 total)
-
RE: Point in time restore issue - urgent
I guess your rollback operation may be taking to long.
If that is the case (long runnig transaction or a transaction with many logrecords),...
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
-
RE: Attempt to fetch logical page - Error
That's SP4. (=latest sp) So this should be ok.
IMO the DBCC CheckDB must be executed asap!
from Books Online:
Error 605
Severity Level 21
Message Text
Attempt to fetch logical page %S_PGID in database...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
-
RE: Point in time restore issue - urgent
best is to start with putting your db read_only and single_user.
USE PIT_TEST
go
ALTER DATABASE PIT_TEST Set single_USER , READ_only WITH ROLLBACK IMMEDIATE
-- don't put a go here, because others...
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
-
RE: Attempt to fetch logical page - Error
Indeed a dbcc checkdb would be the first action to be taken.
If you cannot do it yourself, contact your dba-systemadmin to perform it asap.
What's your version of sqlserver are 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
-
RE: Attempt to fetch logical page - Error
- Can you provide the ddl or the query that produces this error ?
- do you perform a checkdb on regular basis ?
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
-
RE: Ambiguous column name error
Seems to be a flaw in sql2000
With sql2005 SP2 + cumul HF *
the query
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
-
RE: Ambiguous column name error
Indeed, SQLUA-bol states
"Column aliases in ORDER BY clause cannot be prefixed by table alias "
With the example :
For example, the following query executes in SQL Server 2000,...
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
-
RE: DTC Error
did you install and configure MSDTC (control panel\add remove programs\windows components\application server)
Keep in mind that if the sql2005 box is running with windows 2003 and the sql2000 may be running...
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
-
RE: Ambiguous column name error
just my 2 ct
With SQL2005 the order by in will use the column-aliasses whenever possible.
That's why your query did not fail with sql2005 (you only specified location once in 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
-
RE: Unable to launch startup trace with regread ....
QA in this case was meanth for Query Analyser
So when I run the sproc from query analyser, everythig works fine,
If I schedule 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
-
RE: Unable to launch startup trace with regread ....
Because we always have SQLAgent running, I've just implemented an extra job to check and launch the sox-trace proc.
This job is scheduled to start whenever sqlagent starts.
I've kept the startup...
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
-
RE: Please help for auditing
Red Gate has a free "SQL Log Rescue" for SQL2000 !
Very nice !
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
-
RE: ORACLE to MSSQL - Constraints and Tools??
maybe it's worth to mention that MS has a free migration assistant for Oracle to SQL2005.
I don't know if it supports the Oracle 7.3
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
-
RE: Should tables be clustered?
As stated in Greg's blog, many times we just overlook the fact that most of the time, a CIX is not choosen for a special reason, but just to have...
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
-
RE: Should tables be clustered?
Just to add .. MS has released a nice article "Comparing Tables Organized with Clustered Indexes versus Heaps" in the sql2005 best practises.
you can find it at http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/clusivsh.mspx
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
Viewing 15 posts - 5,656 through 5,670 (of 7,499 total)