Comments
Sort by recent activity
ZLIB is free open source code. Everyone has access to it: http://www.zlib.net/
(The Copyright strings are in your DLL's) / comments
ZLIB is free open source code. Everyone has access to it:http://www.zlib.net/
(The Copyright strings are in your DLL's)
I am using a date column, not the PK. This is for financial data that needs to be organized by quarters and years.
I can email the schema, I can't make it public. / comments
I am using a date column, not the PK. This is for financial data that needs to be organized by quarters and years.
I can email the schema, I can't make it public.
I don't have any problems inserting to or selecting from this partitioned table.
The table has both a clustered index and a covering index on the time column used in the partition function. Nothing needs to be arranged. / comments
I don't have any problems inserting to or selecting from this partitioned table.
The table has both a clustered index and a covering index on the time column used in the partition function. Nothin...
petey wrote:
To mdgraves, SQL Backup does not change any SQL Server registry settngs during installation or upgrades.
It may not change any registry settings, but it sure changed the destination of several of my backups to the Windows default folder rather than the dedicated SAN disk I had been pointing at.
I found out when the drives filled... Now I make sure to check every job after an upgrade to make sure the drive stays the same. / comments
petey wrote:
To mdgraves, SQL Backup does not change any SQL Server registry settngs during installation or upgrades.
It may not change any registry settings, but it sure changed the destinati...
The service can be set to restart, but not to affect the group. It can't be put in as a dependency on a resource without taking that resource offline, so there should be no attempt to do so.
The default should be the safe option. The installer does not appear to be able to cleanly start the new service, and even if that were not the case, the only correct answer is to "first, do no harm". / comments
The service can be set to restart, but not to affect the group. It can't be put in as a dependency on a resource without taking that resource offline, so there should be no attempt to do so.
The d...
I deinstalled the tools via Control Panel on those servers and that fixed the problem. / comments
I deinstalled the tools via Control Panel on those servers and that fixed the problem.
The two servers are ones that already had components installed but were not currently attached to my console. And they are clustered. / comments
The two servers are ones that already had components installed but were not currently attached to my console. And they are clustered.
The query returned 0 rows. / comments
The query returned 0 rows.
Did you try the new server components? http://www.red-gate.com/MessageBoard/vi ... php?t=5484
You might also try choosing a lower thread priority on your jobs to see if that helps. It has helped me at times when the server is busy. I find that the default priority RG sets is the same base priority that my SQL server process is running at.
When you say unresponsive, do you mean that you can't do an sp_who2 in Query Analyzer? Is there blocking? / comments
Did you try the new server components?http://www.red-gate.com/MessageBoard/vi ... php?t=5484
You might also try choosing a lower thread priority on your jobs to see if that helps. It has helped me...