Viewing 15 posts - 3,346 through 3,360 (of 7,506 total)
it isn't mandatory, but it helps for sure :-P:-D
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
October 31, 2009 at 4:35 am
I posted my SQL2005 script, because you posted in the SQL2005 forum !
for sql2000 you can use:
SET NOCOUNT ON
SET ROWCOUNT 1000
WHILE 1 = 1
BEGIN
DELETE TableName WHERE <Your Condition Here>
...
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
October 30, 2009 at 6:33 am
Anamika (10/30/2009)
thanks,but to take a back up i don't have space in the server. it'z a 200gb database.
regards,
anamika
You can also produce the backup to a remote location, provided you grant...
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
October 30, 2009 at 4:44 am
That's an eye opener indeed !
In many cases we only see the beauty of life, once we have to mis part of it.
For Belgium these links may get donation started:
Flemish...
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
October 30, 2009 at 4:34 am
If both sqlservers can "see" eachother and the destination service account has read auth on the source servers backup folder, you can restore using the source server bak files
restore 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
October 30, 2009 at 4:24 am
This is one way to work with batches:
If you don't switch to simple recovery, you log files may get filled up and even grow !
If you switch to simple recovery,...
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
October 30, 2009 at 4:10 am
or maybe someone just dropped the database that had been set for default database of the service account.
Solution:
ALTER LOGIN [ictlan\MSSQLSERVICE] WITH DEFAULT_DATABASE=[master]
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
October 30, 2009 at 1:27 am
Thank you both for clarifying how to change that behaviour at windows level;
I hadn't been looking in that direction, because in many cases, when you encounter this behaviour, it points...
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
October 30, 2009 at 1:22 am
Did you check the examples in Books Online ??
http://msdn.microsoft.com/en-us/library/ms189799%28SQL.90%29.aspx
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
October 29, 2009 at 3:05 pm
the resultset of you statement is being written to your grid of text results work area.
That may indeed fill up you c drive it it is a very large...
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
October 29, 2009 at 3:03 pm
- please provide the full statement exactly as you execute it !
(maybe even post the db create ddl)
- keep in mind, you cannot empty the primary file ! (it contains...
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
October 29, 2009 at 2:57 pm
I bet it would go very much faster the other way around :w00t: :hehe:
Did you check these Database Mirroring Best Practices and Performance Considerations ? http://technet.microsoft.com/en-us/library/cc917681.aspx
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
October 29, 2009 at 1:51 pm
- It is a very bad habit to use a domain admin account for sqlserver service account.
Always aim for minimal rights for any service account to keep doors 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
October 29, 2009 at 1:45 pm
IMO easyest is to script it all and execute the scripts at the target instance.
Keep in mind to also script the granted usage rights.
What do you need to script ?
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
October 29, 2009 at 1:40 pm
repent_kog_is_near (10/28/2009)
x86-32 is where we are now.What are the factors that should influence going for 64bit environment.?
Search SSC for "64-bit"
http://www.sqlservercentral.com/articles/News/abitabout64bit/1360/
http://www.sqlservercentral.com/articles/Miscellaneous/overviewof64bitsql/1166/
and off course at MS.
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
October 29, 2009 at 1:32 am
Viewing 15 posts - 3,346 through 3,360 (of 7,506 total)