Viewing 15 posts - 3,121 through 3,135 (of 7,502 total)
Jeff Moden (2/23/2010)[hr... Other than that, the only difference is less typing... the performance, execution plan, and operation are identical ....
Let's hope they finally are equal in sql2008.
It's 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
February 25, 2010 at 6:23 am
Once again it is been prooven : a sound dba must pop the questions !
and the attitude will change from [b]"must now ... chop chop.. cannot do it other way..."...
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
February 25, 2010 at 12:00 am
KingCobra (2/24/2010)
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...
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
February 24, 2010 at 11:54 pm
You should indeed be able to define a linked server from sql2008 to mysql.
However, If you also want performance, that may not be your best choice !
If you don't need...
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
February 24, 2010 at 2:01 am
Thank you for the feedback.
That's a bummer :ermm:
Isn't each db engine like an "add on" for NHibernate ?
So maybe just adding MySQL in the config could do the trick.
My...
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
February 24, 2010 at 12:37 am
I don't know the 3790 build.
Please post the full result of
Select @@version
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
February 24, 2010 at 12:03 am
Mh-397891 (2/23/2010)
FYI, Per this article: This says to set both Min and Max memory to the same value:
The article is dated April 2003. (sql2000)
The NONO is about 64-bit.
Experiences with 64-bit...
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
February 23, 2010 at 11:57 pm
Superflokky (2/23/2010)
I want to point out that my test environment hasn't changed that much. The only thing I've changed (on the MySQL server side)...
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
February 23, 2010 at 11:58 am
You should also check your mail server, because it may withhold your mail because of e.g. spam settings, ...
Regarding your SP2 question:
SP2 has many cumulative hotfixes (as does SP3), so...
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
February 23, 2010 at 11:56 am
These is one big NONO with your configuration:
Minimum server memory(in MB): 102400
Maximum server memory(in MB): 102400
Don't set the same value for min and max server memory ! It confuses sqlserver...
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
February 23, 2010 at 11:50 am
That's exactly what I like about linked servers or OpenQuery stuff :sick::sick:
So, that's why always advise to try to avoid them in the first place.
- Check for differences in 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
February 23, 2010 at 11:42 am
Apparently you have been bitten by your own messing around with logical names !
If you start fooling around with systems info or settings, don't be surprised you may not...
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
February 23, 2010 at 4:01 am
I always use these scripts to diagnose DBMail issues ...
use msdb
go
/* is dbmail config activated ? */
Select *
from sys.configurations
where [name] = 'Database Mail XPs'
go
exec sysmail_help_queue_sp -- @queue_type = 'Mail'
go
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
February 23, 2010 at 2:14 am
Greg Snidow (2/22/2010)
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
February 23, 2010 at 2:08 am
I would advise you to read Jeffs great article :
"The "Numbers" or "Tally" Table: What it is and how it replaces a loop."
http://www.sqlservercentral.com/articles/T-SQL/62867/
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
February 22, 2010 at 1:55 pm
Viewing 15 posts - 3,121 through 3,135 (of 7,502 total)