Viewing 15 posts - 4,111 through 4,125 (of 7,499 total)
Golova (1/21/2009)
One more question:
If I have to roll back to the SP2 according to Microsoft i nave to re-install SQL server 2005 and then restore all system dbs,...
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 22, 2009 at 12:44 am
Jeff Moden (1/21/2009)
... simple question... "Using a SELECT statement, how do you return the current system date and time as part of the return in either?" ....
Bad to 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 22, 2009 at 12:23 am
I knew one of my friends did suffer these DRP issues after upgrade, but I couldn't find the ref.
Today I found it back, so here it is:
http://sqlblog.com/blogs/allen_white/archive/2007/10/08/pay-attention-to-cluster-setup.aspx#11345
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 21, 2009 at 11:55 pm
langsoo (1/12/2009)
Any genius out there willing to help?
approximately 1,000,000 members of SSC ...
first glimps:
One thing I've seen in your 1222 list :
UPDATE WebCustomer SET CustomerCode = CustomerID
WHERE CustomerGuid = N'851e456e-2389-4c82-96b9-4be6aa93f717'
....
(@1...
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 21, 2009 at 7:43 am
hmm... indeed posting the query would indeed demistify a little bit.
Just copy/paste it as it is in your actual application/script.
(no matter the language 😉 of the columns)
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 21, 2009 at 2:15 am
Norm (1/20/2009)
I have implemented an auditing solution that uses 3 different trace files. My ultimate goal was to have a static trace id for each type of audit (DDL,DML,Logins).
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 20, 2009 at 2:00 pm
Here's a set of scripts to diagnose SSB.
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
And don't forget the SQLserver Errorlog !
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 20, 2009 at 1:52 pm
As you have seen, if the question is good, the solution(s) come in quickly :w00t:
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 20, 2009 at 1:49 pm
Lynn gave you the solution.
However for the query I would suggest to use a convert with a specific conversion type.
This way everybody maintaining your query will know of the explicit...
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 20, 2009 at 11:04 am
- Cross db queries ??
- we have been warned as from sql7.0 (if I'm correct sp2) that this kind of joins were obsolete. And with every migration project I've...
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 20, 2009 at 10:50 am
Is this related to bug http://support.microsoft.com/kb/959006/
SP3 has it in its fix list :w00t:
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 20, 2009 at 10:39 am
Nice testing Gabe.
Thank you for the feedback.
One of my co-workers discovered the same and it is a valuable lesson.
It is certainly worth to know, because everyone experimenting with partitioning 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 20, 2009 at 10:35 am
Lynn Pettis (1/7/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 20, 2009 at 6:44 am
Dugi (1/10/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 20, 2009 at 6:37 am
Right there with you Lynn.
To me ansi is the guideline, "dialect" will get used whenever ansi doesn't perform as it should.
IMO that's where any DBMS will try to make 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
January 20, 2009 at 12:04 am
Viewing 15 posts - 4,111 through 4,125 (of 7,499 total)