Viewing 15 posts - 2,011 through 2,025 (of 7,506 total)
apparently you have declared a unique alternate key (i.e. a unique index)
Double check you are checking all your unique constraints (pk/ak) before qualifying a row for insert
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
June 7, 2011 at 2:45 pm
Digs (6/7/2011)
I have two large tables that get updated daily or (added to).
I want to run this TSQL daily.
ALTER INDEX ALL ON DIM_Data REORGANIZE
and
DBCC SHRINKDATABASE (MyDB,10);
Say I have...
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
June 7, 2011 at 1:41 pm
That will only work of the errorlog file hasn't been rolled over ( more than your number of kept files )
If your database has "autoclose off" - which I hope...
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
June 7, 2011 at 1:33 pm
SQLRNNR (6/7/2011)
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
Where do you see this watermark?
I get to see it in 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
June 7, 2011 at 1:23 pm
GilaMonster (6/7/2011)
The client-from-hell is no more.
Congratulations !: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
June 7, 2011 at 1:21 pm
What's with the watermark on our SSC ??
Is it webmaster fun, or is SSC changing logo ?
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
June 7, 2011 at 10:29 am
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
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
June 6, 2011 at 5:51 am
It is best to always post your exact question documented with your actual code.
The more actual info we get, the better advise we can give you.
If you would have posted...
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
June 5, 2011 at 10:55 am
Seems to me to be the way to use a clr fn just to actually use one.
Why don't you use a regular tsql derived column ?
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
June 5, 2011 at 9:59 am
Once you have the script, you can use SQLCMD to deploy it to all your environments, or if you can group connect to the required instances ( SSMS registered servers...
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
June 5, 2011 at 9:57 am
river1 (6/3/2011)
I have SQL Server 2000 and i need that a job send an e-mail every 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
June 3, 2011 at 9:45 am
Please read the description and pick the one that suites you best.
http://www.sqldev.net/downloads/xpsmtp/default.html
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
June 3, 2011 at 8:39 am
keep in mind datetime holds date and time.
Your predicate looks for yourdatecol="2011-06-02 00:00:00.000'
edited.
Oh please don't use a date conversion function because it will avoid an index being used in 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
June 3, 2011 at 2:46 am
we have been using Gert Drapers smtp proc on our sql2000 instances for years. No outlook client needed !
Have a look at http://www.sqldev.net/downloads/default.html
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
June 3, 2011 at 2:44 am
start from scratch or restart form the point where it failed ...
I don't know what the effect is on the "network" problem, but at one time when I had...
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
June 1, 2011 at 2:58 pm
Viewing 15 posts - 2,011 through 2,025 (of 7,506 total)