Forum Replies Created
Viewing 15 posts - 6,616 through 6,630 (of 7,499 total)
-
RE: Help with sql scripting.
Include dbo to Model-db so it is included in every new db that will be created.
Try this
_test_test_test_...
-- jobi dd 19/03/2004
-- toevoegen YourDomain\YourDBOUser aan server en met db_owner-rechten op alle...
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
-
RE: database creation script generation
there is a web sql-management intereface (I beleive at MS) downloadable, I cannot rember where, but it had this functionality.
If I find it...
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
-
RE: dropping table with indentity referenced by FKs
you mean dropping the parent table will also drop all dependant tables ?
sqlserver does not support that. You'll have to build your drop-ddl yourself.
You can do that with a recurrent...
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
-
RE: SQL clusters - not seeing all drives
Are you looking at the same instance of sqlserver ?
Are server1 and server2 nodes from the same cluster ?
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
-
RE: Scripting off indexes.
maybe sp_helpindex 'yourobject' as a base for your generate script may be quiet usable combined with the undocumend
sp_meforeachtb.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
-
RE: Scripting off indexes.
IMO it's tricky to drop all indexes just to do a BCP.
This will hurt you system _and_ it will hurt again when you recreate these indexes !
And in the mean...
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
-
RE: Referential Integrity check (without foreign key defined)
What you (they) did not put into it, you'll not get out of it the easy way
Lest's hope you have naming-conventions to point...
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
-
RE: Error 8198 (could not obtain information about Windows NT group/user) after upgrading to MsSQL SP4
- apparently that bug/malfunction has not been solved with sp4
check support.microsoft.com/?kbid=883551
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
-
RE: running stored procedures on a multiprocessor system
my 2ct
- also keep locking in mind !
- sp_updatestats + dbcc updateusage will rectify your statistics
- you can use sql-perfmon to find out what is consuming how man.
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
-
RE: SQLDMO
Check out Data Transformation Services (DTS) in your Enterprise manager.
This will be more simple and intuitive.
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
-
RE: Using something other than datetime for dates and times
If you don't invest in determining the correct datatype for you attributes/columns, don't even wast time at performance !
Indeed,with sqlserver you only have 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
-
RE: 15000 Records to be Inserted
Move your sp-validation to your vb-code and use SQLBULKCOPY (vb.net).
this is a "fast load" if you have ordered your data according to the clustered index of your 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
-
RE: error when restoring a database
"tell me why I don't like Mondays"
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
-
RE: Reallocate transaction log file
check out : Moving SQL Server databases to a new location with Detach/Attach
(http://support.microsoft.com/default.aspx?scid=kb;en-us;224071)
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
-
RE: Advacing the system date, when a job is scheduled on daily basis.
if I'm correct, after you changed your systemdate, sqlagent will change the "next rundate/time" to 27/05/2005 12:00AM. So the only thing it does is check wether it has the correct...
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
Viewing 15 posts - 6,616 through 6,630 (of 7,499 total)