Viewing 15 posts - 2,551 through 2,565 (of 7,499 total)
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
Hey .. paulwhitenz also disappeared at SSC.:hehe:
Welcome SQLKiwi 😀
Keep in mind to have SSC altering your twitter refs in your articles 😉
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 6:55 am
sorry for that :Whistling: 😉
btw If these managers have some kind of awareness, they would understand you first need to test it on a DBA-only instance, before you can implement...
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 6:52 am
Are you already familiar with SQL2008.
If not, start testing it yourself !
maybe even get an upgrade course.
for your db/instance:
1) download SQL2008 upgrade advisor
2) run it against the db you want...
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 1:51 am
- Personally I don't like those column level select statements in the select clause.
Maybe the engine will even parse it into a join for you, but IMO it is 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
December 17, 2010 at 1:01 pm
With regards to the beverage, I used milk and honey and that did a good job.
But I will take it into my notes.
That breaking up will indeed be needed if...
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 17, 2010 at 12:53 pm
Steve Jones - SSC Editor (12/16/2010)
Stefan Krzywicki (12/16/2010)
I wonder if he's still doing that now that there's Intellisense. I like aliases, even one letter ones, but they have to be...
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 17, 2010 at 3:49 am
I noticed my devs prefer getdate because they get confused by sqlservers timestamp data type and that same word in current_timestamp !
:blush:
I think that issue should have been fixed by...
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 16, 2010 at 12:06 pm
Viewing 15 posts - 2,551 through 2,565 (of 7,499 total)