Viewing 15 posts - 2,446 through 2,460 (of 7,502 total)
I payed attention the plain water (no bubbles ) was at room temperature. ( and it wasn't freezing in the room 😉 ).
I'll try out the warm tea the next...
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 18, 2011 at 8:15 am
setting it to 1 will prevent query parallelism for your instance.
If that is your goal, that's the way to do it.
Is that your goal ?
On most of our oltp databases...
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 18, 2011 at 7:32 am
Did you have a look at select is_member( 'yourdbgroup' ) ?
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 18, 2011 at 2:52 am
Thank you all !
Todays session went fine.
Still having a good voice after 4h+.
I banned coffee and consumed 1,5L water, nicely planned 10min break every 75 minutes. The speaking speed...
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 17, 2011 at 9:58 am
What's your MSDTC security configuration.
I think you db2 as400 uses xa transactions.
Did you enable XA transactions with MSDTC ?
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 15, 2011 at 8:43 am
Have a look at "Choosing an Authentication Mode" http://msdn.microsoft.com/en-us/library/ms144284.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
January 15, 2011 at 5:26 am
There are restrictions for online rebuild operations.
indexes that have columns of data types data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml cannot be rebuild online.
I think your index...
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 15, 2011 at 1:27 am
If those objects are strictly for reporting purposes, you can easily put them in their own database at the reporting sql instance and have them access your read only 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
January 15, 2011 at 1:23 am
Did they ever consider database mirroring.
I know it very much depends on the volume of your db load, but it if you are on Ent Edtn, you could (re)create 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 14, 2011 at 12:50 pm
IMO you did forget to grant the needed auth for SQLServer.
Whenever I need to move db files to a new disk or folder I use
this in command prompt
rem /T...
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 14, 2011 at 12:37 pm
sqlservr.exe -f means start mimimum configuration .
Shouldn't you start it without the -f parameter and the trace flag after you performed the procedure Gail pointed to?
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 14, 2011 at 10:42 am
Keep in mind your "ID+1" solution will only work if you don't have gaps in your ID sequence.
If you are using the identity property for this column, you may 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
January 13, 2011 at 12:45 pm
Probably you are calculating using int columns or decimal(x,0).
With sqlserver you need to take care of the precision you need.
In your case I would suggest to test this:
cast((SumOfPremiumOnTime * 1.00...
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 13, 2011 at 12:33 pm
Nope, You're very serious with your observations :doze:
btw : deprecated stuff for sql2005 : http://msdn.microsoft.com/en-us/library/ms143729%28v=SQL.90%29.aspx
for the moment they still plan support for text/image with "Denali" :crazy:
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 13, 2011 at 4:45 am
Did they develop/implement new code or has a part of the application been used that they didn't use previousley.
If it is a new dev part, they should have used 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 13, 2011 at 4:04 am
Viewing 15 posts - 2,446 through 2,460 (of 7,502 total)