Viewing 15 posts - 5,476 through 5,490 (of 7,499 total)
http://blogs.msdn.com/sql_protocols/archive/2005/11/10/491563.aspx
states
By default using SQL Native Client your login packet will be encrypted over the wire so as to not disclose your password. This encryption is supported by...
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
November 6, 2007 at 2:40 am
I also found this overview :
http://www.sql-server-performance.com/faq/sql_server_management_studio_load_time_p1.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
November 6, 2007 at 2:02 am
the way we did it, it's just a windows thing.
each user has a SID-history in windows, apparently the current sid as well as the sid-history sids are being used to...
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
November 6, 2007 at 1:12 am
indeed, it may even be your server instance's selfcreated certificate to encrypt e.g. connections, ...
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
November 5, 2007 at 2:02 pm
only if a rollback is issued all transactions are undone if the transaction count <> 0.
you can use the @@trancount to check if a transaction still exists.
- check raiserror in...
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
November 5, 2007 at 12:41 pm
I think you may be better of using xp_fileexists.
http://www.sqlservercentral.com/Forums/Topic360785-9-1.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
November 5, 2007 at 12:31 pm
any hint is a means which you can use to actualy influence a queries behaviour !
It should be an exception to use a hint, and its purpose should be tested...
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
November 5, 2007 at 7:52 am
- builtin\administrators is a windows thing. Removing it has nothing to do with being able using the sqllogin 'sa'
- sa is a sql user, maybe some 1 did also change...
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
November 5, 2007 at 2:40 am
we just created the same userid in the new domain and imported the old domain's user SId in the SID-history list of that user in the new domain.
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
November 5, 2007 at 2:35 am
-Thanks for the tip. It doesn't change much overhere. (it was unchecked, I checked it and didn't notice big a change)
- I'm using the /nosplash startup parameter, this...
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
November 5, 2007 at 12:50 am
- as you have read, you must take very good care when designing and creating partitions and indexes.
- be sure indexes are alligned !
- indeed, reorg. 1T rows isn't going...
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
November 5, 2007 at 12:23 am
- I'd suspect page splits (clustering index) and file autogrowth.
- work with transactions
- avoid the cursors, do a direct insert in stead !
- insert rows sorted according to the clustering...
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
November 4, 2007 at 7:17 am
did you check Kimberly's very good white paper on partitioning ?
http://msdn2.microsoft.com/en-us/library/ms345146.aspx
it contains very good sample scripts !:smooooth:
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
November 1, 2007 at 2:05 pm
Just my 2ct.
Split the table !
My guess is the must be more info appart from the relation that you can document in your relation table. e.g. startdate/enddate of the relation...
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
November 1, 2007 at 2:00 pm
if you are only selecting objects in the current database, you can use object_name(object_id) in your select list
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
November 1, 2007 at 1:51 pm
Viewing 15 posts - 5,476 through 5,490 (of 7,499 total)