Viewing 15 posts - 406 through 420 (of 7,472 total)
You already made my day, Jeff !
Visualising your figurative speech.
Guess what: our auditors are always charmed by the 2 year migration rule ( that is already active for 10 years...
May 3, 2023 at 5:22 am
Eeasiest would be to start adding a partition for the new month and go from there on.
You'll need to handle the 6-month partition adequately in your cleanup process. ( Leave...
May 2, 2023 at 12:44 pm
O, this is a nice solution track.
It will need some fiddling with, because it spews a load of "ole%" events.
I've ended up with this to start discovering it all:
May 2, 2023 at 12:39 pm
indeed.
Been there, did that.
You can bring a horse to the water, but you cannot make it drink.
May 2, 2023 at 9:34 am
These are SQL 2005 instances on Win 2003 ( to be retired in the next 2 years, for the last 10 years )
From systems maintenance perspective, we don't touch these...
May 2, 2023 at 6:20 am
Once you go to SQL2019, the minimum database level is 100 !
That may break some stuff if you were to migrate the db and have your app use it on...
April 28, 2023 at 2:06 pm
April 28, 2023 at 11:37 am
No we only have named instances on our SQL2005 clusters.
ClusteredSQLServerName\InstanceName is being used to connect with.
Connections which provide the correct port number workt fine
( ClusteredSQLServerName, portno OR ClusteredSQLServerName\InstanceName,portno )
April 28, 2023 at 8:14 am
It must be a SQL2005 issue.
All newer Clustered SQL Server instances work are getting connected to without an issue.
April 28, 2023 at 6:14 am
It returns the sql server full instance name allright.
April 28, 2023 at 6:06 am
local firewall active?
April 26, 2023 at 8:31 am
Why is this left join used in your "WHERE NOT EXISTS " parts?
...
April 12, 2023 at 9:57 am
Why is this left join used in your "WHERE NOT EXISTS " parts?
...
April 11, 2023 at 1:45 pm
Viewing 15 posts - 406 through 420 (of 7,472 total)