Viewing 15 posts - 4,276 through 4,290 (of 7,499 total)
What I like most is that at SSC it is all being presented "feet on the ground" and open minded.
It did start its life from within the target public, attracted...
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
November 28, 2008 at 4:33 am
Coyote Blue (11/27/2008)
I have seen many people; with lots of letters after thier names, including VP and/or DIR, that do not understand the difference between a physically separate drive 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
November 27, 2008 at 1:28 pm
btw:
Did anyone ever test the "ok i will determine the max value myself and add 1" .... and conclude sqlserver actually performs a FULL TABLE SCAN to resolve it.
afaik DB2...
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
November 27, 2008 at 5:05 am
FYI :
http://www.simple-talk.com/community/blogs/tony_davis/archive/2008/11/25/70602.aspx
http://www.simple-talk.com/sql/t-sql-programming/unique-experiences!/
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
November 27, 2008 at 4:00 am
Coyote Blue (11/26/2008)
My 2cents: Make sure it is actually a physically separate drive, and not just a drive partition on the same physical drive. My experience has been that 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
November 27, 2008 at 12:17 am
This may clarify a bit regarding surrogate keys:
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
November 27, 2008 at 12:08 am
I guess we all need to do what I did today .... have a day off :w00t:
I followed a "refresh" day of CPR for human victims this time.
It cleared 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
November 26, 2008 at 12:21 pm
You can change min and max whilst your instance is online.
You'll see its actual impact after issuing a system checkpoint.
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
November 25, 2008 at 1:32 pm
but if you're going to use maint plans, apply at least CU2 (current = CU10 and sp3 is in public beta)
For the moment we apply CU10 for new installations. (didn'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
November 25, 2008 at 1:02 pm
- try to keep a primary key column meaningless, you'll not have to modify (datatype/length) it during the lifetime of the database. (var)Char always tend to get meaningfull after 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
November 25, 2008 at 12:52 pm
well .... Kalen has great info on 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
November 25, 2008 at 8:01 am
another reason to avoid functions as much as possible.
In many cases they can be replaced by another form of joins and that explicitely point to one of the biggest dangers...
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
November 25, 2008 at 3:34 am
Rubbish in .... rubbish out :unsure:
As in many cases, providing exactly what you need may get your problem(s) solved much...
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
November 25, 2008 at 2:52 am
can you post the full create database statement for that database on pre-prod and on prod ?
i.e. the create statement and all the following alter database statements
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
November 25, 2008 at 2:45 am
rbarryyoung (11/24/2008)
Jonathan Kehayias (11/24/2008)
SQLBatman is a hero, I am just Jonathan Kehayias. I should really come up with a witty screenname or something for my online presence.
Hmmmm, how about...
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
November 25, 2008 at 12:15 am
Viewing 15 posts - 4,276 through 4,290 (of 7,499 total)