Viewing 15 posts - 1,786 through 1,800 (of 7,506 total)
I have a cell phone because I'm on call ... if it weren't for that, I wouldn't have one at all.
Company takes care of 20€ / month leaving me 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
August 2, 2011 at 10:57 am
Then I see no issue(s) on having it in 90 mode for a transition time span 😉
Keep in mind to keep a backup of your SQL2005 db created from 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
August 2, 2011 at 10:33 am
we tend to prep our backup jobs to have a last step to copy the .bak files to a safe zone.
Restores towards test servers are being performed using these safe...
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
August 2, 2011 at 10:14 am
I hope you did run the upgrade adviser tool. It will point to potential issues and may be a great to prevent failures and prepare migration projects.
Don't start without 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
August 2, 2011 at 10:09 am
how about:
if exists (SELECT 1
FROM [Annual_Edu_2006].[dbo].[HREMP_Adp]
Where [LName]+', '+[FName] = @username
and convert(VARCHAR(10),DOB,101) = @DOB )
return 1
else
return 0
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
August 2, 2011 at 9:53 am
some drop'm after a restore. I don't advise it, but it happens.
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
August 2, 2011 at 1:54 am
BEFORE going for any harsh action I would investigate the issue.
What else is failing, causing issues to that sqlinstance at that time ?
(IO subsystem notifications, other db having alike issues,...
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
August 2, 2011 at 1:53 am
search ssc for "lost sa password". Those threads will get you started.
e.g. http://www.sqlservercentral.com/Forums/Topic1054427-146-1.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
August 2, 2011 at 1:46 am
As I got to understand it, an itvf can be fully bound and taken into account at plan compile time.
That may provide more intelligent solutions then we might expect 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
August 1, 2011 at 11:45 pm
why the hassle with cu3 and 4 before going to SP1 ??
SP1 = CU6+ ssms intellisence fix (bug after vs2010SP1) and maybe some more.
if I'm correct : SP1+SP1CU1 = RTM+CU8
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
August 1, 2011 at 2:13 pm
did you run the upgrade adviser ? It will point to potential issues.
You should be able to just restore the database(s) in stead of a having to port all data.
(unless...
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
August 1, 2011 at 1:28 pm
alter your function to be an inline table value function. That may do magic !
create itfv_x
returns table
as return (select your_case_statement as Et_Voila)
keep in mind you'll have to modify your 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
August 1, 2011 at 1:21 pm
set statistics time will show compile time and execution time of the query, just to give you a look on consumption.
btw did you notice
...
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
August 1, 2011 at 1:17 pm
If the errorlog doesn't bring any refs to your issue, I think best is to start a trace which also captures oledb errors and run your app until the issue...
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
August 1, 2011 at 1:12 pm
I did like the free ebook "SQL Server Statistics" available at red-gate ebook store. http://www.red-gate.com/our-company/about/book-store/
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
August 1, 2011 at 12:14 pm
Viewing 15 posts - 1,786 through 1,800 (of 7,506 total)