Viewing 15 posts - 3,001 through 3,015 (of 7,499 total)
Probably you're using DHCP addresses on your client.
The IPadress registered is the one it had at install time.
It's the port number that is unique for your machine, so that's 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
June 8, 2010 at 12:28 am
We've has some connection losses to, but the mirroring (primary-mirror-witness) resumed as soon as the connection could be reactivated between principal and mirror.
It caught up very well (sql2005 std)
I know...
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
June 7, 2010 at 2:14 pm
did someone enable tcp/ip access for your instance ?
If not, this should be done (using sqlserver configuration manager followed by a stop/re-start of your sqlserver instance)
Keep in mind : many...
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
June 7, 2010 at 8:03 am
I always love to see alternatives ....
But going back to use the unstable sp_oa... is at least one bridge to far.
There has been a nice article with a CLR...
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
June 4, 2010 at 8:01 am
Regarding the FK indexes: http://www.sqlservercentral.com/scripts/Indexing/61391/
For the rest all I can say is: "With quick only comes dirty !!"
Capture your workload, and analyse it (maybe using Db Engine tuning advisor)
Only...
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
June 2, 2010 at 8:06 am
for your cluster, off course the backup location will be the same (for drives will fail over or UNC drives are the same)
If I'm correct these registry keys are replicated...
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
June 2, 2010 at 12:12 am
IMO MS did build a great product with wanted technology, but lost the battle before it had begun because of the lack of managebility aids !
Just considering you may 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
June 1, 2010 at 2:56 pm
I always suggest to support all FK with indexes, unless proven they hurt a specific case. Then only remove/disable (but document ! ) the hurting one if that case occurs...
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
June 1, 2010 at 1:34 am
How about this:
-- Alter Local Default Backup Directory and check existance / create if needed
--
Declare @NewDrive nchar(1)
Declare @RootDirectory2Add nvarchar(512)
Declare @NewDirectoryPath nvarchar(512)
Declare @Override char(1)
select @NewDrive = N'K'
, @RootDirectory2Add = ''
...
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
June 1, 2010 at 1:19 am
check out the free SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx
It will point you to some issues and the way to fix them.
Off course, it will only...
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
May 23, 2010 at 1:33 am
also have a look at the auto grow size. Maybe someone set it way to big.
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
May 20, 2010 at 9:21 am
also nice to read: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/16/bad-habits-to-kick-mishandling-date-range-queries.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
May 18, 2010 at 5:29 am
indeed, the order of execution of the log truncation _after_ the diff backup causes the log to be unusefull for recovery purposes.
Maybe a log analyser tool can still recover...
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
May 14, 2010 at 3:16 pm
afaik you nolonger need the assembly once you have created it in sqlserver.
You can even script it. That will generate a long binary string, but will be portable.
So you can...
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
May 14, 2010 at 3:09 pm
I would like a better search engine for SSC.
One that works in general as well as in the "my posts" section.
Maybe add an "extended search" or "search within results" button...
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
May 14, 2010 at 7:43 am
Viewing 15 posts - 3,001 through 3,015 (of 7,499 total)