Viewing 6 posts - 1 through 6 (of 6 total)
I think you have made a lot of valid points there.
Other issues I have noticed:
We want SQL012 Cluster installed, you know all about this don't you, as your the...
January 30, 2015 at 2:18 am
I utilised this in some in house code, resolving the content of the CTE with further where cause values, (excluding the like '%...%' clause for the moment.
I then joined the...
January 16, 2015 at 7:41 am
Doesn't accommodate for wildcards though. It is only parsing and matching FULL words.
He% and Nu% would not work.
If putting a LIKE in-between KWI.KW and #KW.Keyword, you may think it works,...
October 21, 2014 at 2:59 am
I have been supporting MSSQL now for 17 years, and have come across this issue many, many times.
I usually follow the following process:
1. Fix the problem.
2. Install monitoring / alerting...
March 14, 2013 at 2:48 am
THIS, worked for me:
sp_dropserver 'xxxx', 'droplogins'
sp_addserver 'xxxx-new', local
February 11, 2010 at 3:44 am
I tried the disable of the publishing, but it still would not allow the connection to the alias.
I ended up changing the server name back on the network, disabling replication,...
February 11, 2010 at 3:11 am