Viewing 15 posts - 436 through 450 (of 7,501 total)
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
March 31, 2023 at 5:58 am
Viewing 15 posts - 436 through 450 (of 7,501 total)