Viewing 15 posts - 4,561 through 4,575 (of 7,502 total)
proving once again one should provide index on a FK column,
unless actually tested that it hurts that particular system.
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
September 10, 2008 at 12:39 pm
Well, if there is no "default" value that can be justified at logical database schema design, there will be no default value at physical fase.
Having a column without a default...
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
September 10, 2008 at 12:35 pm
good gut feeling :w00t:
It depends what's the definition for the particular view.
e.g.
[Code]
Create view myview
as
select col1, col2
from mytable
where thekey = 15
go
Select * from myview
[/code]
Will most likely not do as...
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
September 10, 2008 at 12:29 pm
e.g.
This one will map sqlaccount sa to the dbo user of your db.
Check BOL
exec sp_changedbowner 'sa', true
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
September 10, 2008 at 12:16 pm
you could just embed your primary query ...
Select nestsel.*,
mkt_rate = dbo.get_mkt_rate( ,...),
pipsaway = dbo.Calc_Pips_Away(nestsel.ticket,
...
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
September 10, 2008 at 12:13 pm
just my 2ct.
You could also consider a constraint to be meta data for your database. This way it needs to be part of your system.
Having it as a constraint will...
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
September 10, 2008 at 12:07 pm
Also a nice tool for this can be SQLCMD
If you have an inventory table containing all your sqlserver instance names, you can run a script and save all results,....
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
September 10, 2008 at 12:00 pm
barb.wendling (9/10/2008)
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
September 10, 2008 at 7:45 am
Most of my jobs only have step with "Fail job if step fails", so I've only checked for the failed steps.
This version only reports if the actual job failed...
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
September 10, 2008 at 5:20 am
You need to use SSMS (SQL 2005) to get the result aimed for with the question.
Apparently it's SSMS that puls this trick !
Indeed With Query Analyser, you'll get the syntax...
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
September 10, 2008 at 4:49 am
Keep in mind SSMS has some issues with e.g. char(13) resulting in a "syntax error near ...."
And off course you'll need to have the default 'go' for batch separator...
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
September 10, 2008 at 3:59 am
sqlserver timestamp is "for internal use only" !!
This kind of columns will be updated by sqlserver itself with every modification to the row !!
This is not a datetime column !!!
We...
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
September 9, 2008 at 7:53 am
Considerations for the "autogrow" and "autoshrink" settings in SQL Server
http://support.microsoft.com/kb/315512
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
September 9, 2008 at 1:29 am
Ken Stelter (9/8/2008)
... But, they don't really allow me much time to monitor logs and such: it's not value-added work:crazy: ...
Oh yes, SCADA stuff, not that much sqlserver performance...
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
September 9, 2008 at 1:18 am
just curious: Do you have "auto shrink" enabled for this database ?
(Bad practise ! If you actually need a shrink operation, you'd be better off doing it in a planned...
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
September 8, 2008 at 12:51 pm
Viewing 15 posts - 4,561 through 4,575 (of 7,502 total)