Viewing 15 posts - 5,371 through 5,385 (of 7,499 total)
- most applications actualy do NOT need sa, nor sysadmin privileges to run the application itself.
- most software installers do not know this, or are to lazy to alter 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
January 3, 2008 at 2:45 pm
- Solution 1: get rid of the linked servers ! 😀 Maybe the process can be performed asynchrone, so replaces by a sqlagent job or so. You might even consider...
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
December 28, 2007 at 5:41 am
move the backupfolder to your c-drive to avoid this kind of hassle !
So it will be able to use c:\backup\...
Also keep in mind it has to be able to write...
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
December 28, 2007 at 5:27 am
Basicaly two types :
- nonclustered ( max 254 / table) (shortcut access)
- clustered (max 1 per table) (physical dataorganisation)
Full-Text Indexes are a whole different story because of their implementation.
check...
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
December 28, 2007 at 5:20 am
SQLServer (like any rdbms) uses statistics to determine an accessplan for your query.
If there are no statistics available it will use predefined distribution assumptions.
At database level you can set autoupdatestatistics...
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
December 28, 2007 at 5:12 am
- check your sqlserver errorlog file at both servers !
- maybe the script can help you out :
Troubleshooting Service Broker (SSB) http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
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
December 28, 2007 at 4:58 am
follow Madhivanan's advise !
select fromdate
, convert(datetime,fromdate,100) as fromdate_datetime
, convert(char(23), convert(datetime,fromdate,100), 121) as frildate_datetimestring
from emp
where convert(datetime,fromdate,100) > convert(datetime,'2/16/2007',100)
order by convert(datetime,fromdate,100)
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
December 28, 2007 at 2:25 am
- with sql2005 it is advised to switch to DBMail.
- Can you find a error notification in the job history ?
- Can you find a error notification in the SQLAgent.out...
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
December 28, 2007 at 2:11 am
you can offcourse always put the db in singleuser mode within the restore-batch.
use master
alter database yourdb set single_user with rollback immediate;
restore database your db
from ......
raiserror ('DBA- Restore Notification:...
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
December 28, 2007 at 2:06 am
as far as I know that is not possible.
You'll have to restart from your fullbackup and keep it in Norecovery until you decide to use recovery.
At that time it will...
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
December 28, 2007 at 1:56 am
We use acursor driven proc but just altering it to be #temptbl oriented, you might handle it like this:
DECLARE @SQLStatement nvarchar(4000)
--DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
Declare @tmpReindexList table...
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
December 28, 2007 at 1:20 am
Best practise is to always map your procedure parameters.
Otherwise parameterse are mapped according to their position in the parameterlist in the exec-clause.
Also keep in mind when using e.g. a vb.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
December 28, 2007 at 1:00 am
if you need order, then you'll have to tell it to the system.
So add and "Predicate_order" column so you can sort your select set according to it.
If you need rows...
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
December 27, 2007 at 8:20 am
most of the time just restarting the sqlserver service will solve your problem. (depending on the number of operations it needs to rollback)
Reason: at startuptime of a db, all uncomplete...
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
December 27, 2007 at 8:07 am
your statement
ALTER AUTHORIZATION ON consultant.DimConsultantStatus TO dbo;
just tells the system the object consultant.dimconsultantstatus is owned by dbo.
you should use
ALTER SCHEMA dbo TRANSFER consultant.DimConsultantStatus;
GO
Check bol.
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
December 27, 2007 at 8:03 am
Viewing 15 posts - 5,371 through 5,385 (of 7,499 total)