Viewing 15 posts - 5,911 through 5,925 (of 7,506 total)
like the message says, you're trying to convert a varchar to a numeric datatype. The content of the varchar is not a number !
This can also occur with implicit conversions Johan Dont drive faster than your guardian angel can fly ... - How to post Performance Problems - 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
Learn to play, play to learn !
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post data and code to get the best help
February 15, 2007 at 5:38 am
- with sql2005 you would use ddl-triggers saving everything you would want to.
- with sql2000 you could try to use this trace but would not have that much detail 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
February 15, 2007 at 5:35 am
you could use smtpmail in stead of sqlmail.
have a look at SQLDev.Net
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
February 15, 2007 at 2:39 am
- If it all started all of a sudden, I would begin with starting a sql trace for e.g. one hour. Then examine the results and search for big consumers....
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
February 15, 2007 at 1:36 am
- What do you want to monitor about the errorlog ? Size or content ?
- we use a scheduled (sqlagent) job to start new errorlogs at least every week 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
February 15, 2007 at 1:22 am
- generaly it's not a good practise to create userobjects in system databases. (master, msdb, modeldb)
- also when you create a login or grant connect to a server, be sure...
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
February 15, 2007 at 1:22 am
No ! Because :
- you never know when it's going to decide to shrink.
- the shrink operation will have it's impact on the system and for the users
- your database...
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
February 15, 2007 at 12:21 am
If you choose for the 2-column solution put the columns first which has the most unique values ! So it filters on top of the tree
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
February 14, 2007 at 1:28 pm
- as long as you keep in mind that identity may leave you some gaps
- when you use objects with identity in parallel (insert with multiple users) you'll see...
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
February 14, 2007 at 1:26 pm
- saving the storage from float to int will save you space in the parent table and in de child-tables !
- indexes based on int will be smaler so they...
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
February 14, 2007 at 1:18 pm
just my 2ct
- check the queryplan your delete query is using ! If it shows a scan, you're in troubles.
- provide an index on column Expires to support the delete.
-...
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
February 14, 2007 at 5:39 am
- AFAIK there is no "alter database xyz modify filegroup FG3 set offline"
- Did you take a look at "Performing Piecemeal Restores " in books online ?
- in 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
February 14, 2007 at 1:19 am
- Check out Try/Catch in Books online (BOL)
- Scan / Seek see BOL "Table and Index Organization", "Reading Pages ", "Nonclustered Index Structures", "Clustered Index Structures",...
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
February 14, 2007 at 1:11 am
- Keep in mind that what you do within a trigger is "in transaction" ! Timeouts, locking,... !!
- keep in mind there may be more than one row involved 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
February 13, 2007 at 2:51 am
just to add to Michael Valentine Jones ' reply :
don't forget to throw everyone out of the database befor you try to restore...
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
February 12, 2007 at 6:07 am
Viewing 15 posts - 5,911 through 5,925 (of 7,506 total)