Viewing 15 posts - 3,031 through 3,045 (of 7,499 total)
Do you need info of some ids or of all ids ?
If all, just remove it from the where clause.
If some: can you predefine them ?
Avoid loops, think sets...
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
April 28, 2010 at 8:32 am
I would prefer an inner join, but you'll have to figure out what kind of result set you actually need to determine if you need a left join.
Off course, 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
April 28, 2010 at 12:54 am
- you also need to take care of the inner join that you use in combination with a left joined object !!
- for the moment you are using...
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
April 28, 2010 at 12:35 am
If you need the three conditions to be true, why are you coding left joins in stead of inner joins ??
If you only need to validate B and C 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
April 27, 2010 at 2:18 pm
avoid dynamic sql if you can ....
all time ref: The curse and blessings of dynamic SQL http://www.sommarskog.se/dynamic_sql.html
But I don't think you need dynamic sql anyway.
So, skip the "declare...
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
April 27, 2010 at 2:12 pm
as you have seen indexdefrag may not give you the results you aimed for.
(Books online has more details about the differences between dbreindex and indexdefrag)
Do you have a clustered 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
April 27, 2010 at 1:58 pm
Maybe it wouldn't be such a bad idea to contact SQLCAT to get your calculations confirmed that would make mirroring the optimal solution for your case.
Another ref that may help...
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
April 27, 2010 at 6:11 am
have a look at: "A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core"http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempdb-should-always-have-one-data-file-per-processor-core.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
April 27, 2010 at 4:55 am
sudhakara (4/22/2010)
ALZDBA (4/22/2010)
You should contact your mail server admin and ask him/her to allow smtp relay for you sqlservers IP adress.
Can you share me the link where i can learn...
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
April 22, 2010 at 7:37 am
As already stated above : probably these parameters haven't been provided by the connection.
Some applications use a config or ini file which provide the connection string.
e.g.
add key="SQLServerConnectionString" value="Data Source=TheDevServer\Instance01;Initial Catalog=MyDatabase;Integrated...
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
April 22, 2010 at 4:20 am
You should contact your mail server admin and ask him/her to allow smtp relay for you sqlservers IP adress.
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
April 22, 2010 at 3:28 am
Did you have a look at ongoing process locks during your jobs ?
Maybe your website is just being forced out because of the locks your sql jobs cause on your...
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
April 22, 2010 at 3:24 am
Paul White NZ (4/20/2010)
ALZDBA (4/20/2010)
Can you use that kind of filtered index for DRI purposes?
Not for enforcement purposes, no - you need an unfiltered UNIQUE index/constraint or a PRIMARY KEY....
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
April 21, 2010 at 12:45 am
Paul White NZ (4/18/2010)
New for 2008, a filtered unique index can allow an unlimited number of NULLs.
Can you use that kind of filtered index for DRI purposes ?
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
April 20, 2010 at 7:22 am
Good catch, Perry.
That is indeed fundamental !
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
April 17, 2010 at 12:01 pm
Viewing 15 posts - 3,031 through 3,045 (of 7,499 total)