Well, we discussed a rather undocumented way to shrink the transaction log in another past thread. You can Detach the database, move the transaction log to a backup location, Reattach the database without the log. It will create a new transaction log. This technique was poo pooed by Microsoft but several others proclaimed to use […]
2003-07-25
The older thread was basically everything I have done already. As of right now I run transaction log backups every 4 hours which still is not enough. I also had created a shrink job that runs twice a week. The only problem with this is that there is always connections to the database, which will […]
2003-07-25
Check out this older thread. It has many pointers for you: All the best, Dale
2003-07-25
Hi Chris, quote: Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp this is no comment on your article, but on your homepage. The link to your discussion forum yields a Fatal error: Call to undefined function: pg_connect() in /var/www-sql.nu/phpBB/db/postgres7.php on line 79 error. Cheers, Frank
2003-07-21
1 reads
When you say compilation time do ou mean when it was last created/altered or the last time it ran, or something else entirely?
2003-07-17
quote: I think the government should implement rate subsidies for developers, just like crop subsidies for farmers. They could pay unemployed developers not to develop to support rates. Then we could all relax while sitting on our verandas, sipping iced tea, looking out over our idle fields of code. ... Maybe we should start a […]
2003-06-20
1 reads
2003-06-18
use tempdb if exists (select name from sysobjects where name='sp_list_schema' and xtype='P') drop procedure sp_list_schema GO create procedure sp_list_schema(@db_nameX sysname , @db_Server sysname) as declare @SQLString as nvarchar (4000) declare @db_name as sysname declare @db_NameY as sysname set @db_name = @db_Server +'.'+@db_nameX set @db_nameY=@db_Server +@db_nameX set @SQLString = 'if exists (select name from sysobjects where […]
2003-06-11
You need to move your module code into a asp file. I've never seen a VB class module being used within asp. If you convert your module to a DLL you can instatiate it and pass values and call its methods. What you're trying to accomplish could be possible in a .NET framework. but I […]
2003-06-10
Right click on My Computer, select Manage, select Services. Or, open Control Panel and click on Services. Do you see SQLSERVERAGENT in the list of services?
2003-05-07
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers