Viewing 15 posts - 2,551 through 2,565 (of 7,506 total)
Ewan Hampson (12/20/2010)
CTP: "Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Vista"
RTM: "Supported Operating Systems:Windows 7;Windows Server 2008;Windows Server 2008 R2;Windows Vista"
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
December 20, 2010 at 11:12 am
Apparently, on a side by side client install it breaks SQL2008 SSMS project stuff.
- New project on a new folder generates "creating project failed"
- opening an existing sql2008 project generates...
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
December 20, 2010 at 7:48 am
There are some articles at SSC and it the SSC fora.
e.g. http://www.sqlservercentral.com/articles/SQL+Server+2008/67066/
Search at SSC on "upgrade SQL2008" or "migrate SQL2008"
Here's a resource you should certainly have a look at because...
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
December 20, 2010 at 4:36 am
Since you cannot afford gaps, you cannot rely on transactions that may still be rolled back.
( for reasons over which you have no control ) there can be multiple ways,...
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
December 20, 2010 at 2:35 am
So you cannot afford gaps in this sequence number.
IMO that calls for a processing model that only operates on committed rows or sets.
Meaning, log your action and process the sequence...
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
December 20, 2010 at 1:32 am
I stick with my first advise on this one.
Keep it simple and code regular joins.
The column level nested selects will only give you benefits if cardinality meets a treshhold.
I certainly...
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
December 20, 2010 at 1:24 am
How about me just routing you to Paul Randals series of sqlserver myths:
This one on checkpoints:http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281530%29-checkpoint-only-writes-pages-from-committed-transactions.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
December 19, 2010 at 11:36 am
pankaj.nainu1 (12/19/2010)
I am facing some problem while updating a column through trigger.
I have a table User_Records with n number of columns, one of the column is SequenceNumber. When first time...
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
December 19, 2010 at 10:32 am
have a look at the OUTPUT clause (new with sql2005) and how it can help you with this request.
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
December 19, 2010 at 10:26 am
Paul Randals article has more (and more,.. ) info on waits :http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
It also refers to other great resources.
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
December 19, 2010 at 4:16 am
By default, put indexes on your FK columns (so they match the PK they refer to) and have the FK declared with check.
Grant published a little but great article on...
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
December 19, 2010 at 4:07 am
please read http://technet.microsoft.com/en-us/library/dd758814(SQL.100).aspx for more info.
ps
AFAIK SSDs no longer use read/write heads, so they won't have to be aligned ...: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
December 19, 2010 at 3:52 am
Default trace typicaly has trace id 1.
Check sys.traces to figure out what kind of trace that is, what file it tries to write to, and check if you can correct...
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
December 19, 2010 at 3:39 am
Installed it on my laptop instance.
It took 30 minutes.
First impressions: seems to be working fine.
First startup of SQLAgent got a "Warning [1]: Possible date calculation spin for Schedule 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
December 18, 2010 at 8:51 am
SQLkiwi (12/18/2010)
ALZDBA (12/18/2010)
Hey .. paulwhitenz also disappeared at SSC.:hehe:Welcome SQLkiwi 😀
Keep in mind to have SSC altering your twitter refs in your articles 😉
Thanks, though the old twitter references...
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
December 18, 2010 at 8:46 am
Viewing 15 posts - 2,551 through 2,565 (of 7,506 total)