Viewing 15 posts - 4,981 through 4,995 (of 7,506 total)
- it is prooven oledb outperforms odbc.
- use profiler to detect if you have issues with tempdb.
then you can optimise it.
You need to measure it to be able to...
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 7, 2008 at 1:29 pm
as stated before : SSNS is obsolete with sql2008.
Maybe the better way is to the the dot net frameworks version of notification services. (I cannot recall the dotnet name for...
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 7, 2008 at 1:17 pm
have a look at : "Generate Create FK-indexes" http://www.sqlservercentral.com/scripts/Indexing/61391/
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 7, 2008 at 1:14 pm
Thank you for the feedback.
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 7, 2008 at 4:06 am
- seems like only fk-in the fact ??
- I've read this nice art regarding a technique often used in questionairs...
"Introduction to Bitmasking in SQL Server 2005"
...
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 6, 2008 at 1:05 pm
- as Jack stated, you cannot guarantee data will be kept in memory.
- Best you can do is check your proc that it is performing its queries in the most...
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 5, 2008 at 7:53 am
Thank you for the feedback.
Add it to the list of reasons NOT to use linked servers 😉
cfr http://www.sqlservercentral.com/articles/Linked+Servers/62246/
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 4, 2008 at 10:48 am
so the link should be
http://www.sqlservercentral.com/Forums/FindPost457289.aspx
(as stated when you click the left-bottom number)
If you specify:
http://www.sqlservercentral.com/Forums/Topic478505-386-1.aspx#bm457289
You only get directed to the page, bot not positioned at the reply itself.
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 4, 2008 at 7:28 am
Did you have a look at the samples ?
Samples\Engine\ServiceBroker\EventLogging\Scripts
IMO if you just add an sp_start_job to the queues procedure, It'll do what you want to.
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 4, 2008 at 6:40 am
Maybe you can do this from within SQL2005 using events :
I hope this gets you on track ...
CREATE QUEUE PoisonQueue
GO
CREATE SERVICE PoisonService
ON QUEUE PoisonQueue ([http://schemas.microsoft.com/SQL/Notifications/PostEventNotification])
GO
-- set up...
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 4, 2008 at 3:30 am
How about ...
SELECT -- DISTINCT not needed because you use GROUP BY on these 3 columns
R.EntryOperatorUserID,
...
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 4, 2008 at 3:22 am
In addition to Gail's advise:
- Did someone enable PARAMETERIZATION FORCED for some or all databases (maybe even model db)
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 4, 2008 at 3:01 am
- afaik you cannot directly query wich schedule started your current job.
- I've use a "flip/flop" mechanisme in a job I knew that runs one time starting from stepx, 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
April 4, 2008 at 12:09 am
adekunle (4/3/2008)
I am sorry but it is not working.
Did the xp_sendmail work on this server before this issue ?
If yes: What's the difference with the working one(s).
Here's the proc 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
April 4, 2008 at 12:03 am
Kenena Klosson (4/3/2008)
declare mycsr or the rest listed as myscr...
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 3, 2008 at 11:53 pm
Viewing 15 posts - 4,981 through 4,995 (of 7,506 total)