Viewing 15 posts - 3,046 through 3,060 (of 7,506 total)
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
just to add to the solutions that have been posted already.
The term "primary key" comes from the concept of data analysis (normal forms, ...).
It determines the attribute(s) [columns] that uniquely...
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 2:45 am
isn't that a somewhat heavy laptop ? 😀
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 16, 2010 at 1:39 pm
Nice examples.
IMO for a very temporary solution it still may be tolerable ... to use a hybrid solution
CREATE function ufn_GetOrderDetailsCombinations ( @PurchaseOrderID int )
returns table
as
return (
/*
Select...
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 14, 2010 at 7:27 am
Best is to just read about it in Books online and then perform a test using the Database mail configuration wizard of SSMS.
Here's a nice setup ref: http://www.sql-server-performance.com/da_email_functionality.asp
Here's a little...
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 13, 2010 at 1:02 am
The question is also the same ...
Is your goal High availability and/or Data loss protection ?
Do you want no application modification impact (connection string) ?
Do you want no application modification...
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 13, 2010 at 12:53 am
Carl Federl (4/12/2010)
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 13, 2010 at 12:38 am
lauer_Christopher
I have added a reply to the thread Elliot_W mentioned.
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 12, 2010 at 2:36 am
so .... picture this ..
Physical server name TheServer IPaddress 172.16.6.10
The instance TheServer\TheInstance listening at port 2072 (double check its usage if you actually want to use this particular port number...
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 12, 2010 at 2:20 am
Viewing 15 posts - 3,046 through 3,060 (of 7,506 total)