1. You could give our product, MiniSQLBackup, a try. It can generate smaller backups for you.2. If you set to overwrite, that means you will only have the latest backup. If you consistently copy this backup file to another location/server and tag them accordingly, it should be fine.3. tempdb grows usually because of temporary workspace needed for sorts […]
2004-09-22
If you are running the DTS package as a job, your SQL agent needs access to the operating system file. That means your sql agent must be started with windows authentication.
2004-08-26
2004-07-15
1 reads
Good J..P..Sometimes I have implemented something like this:SELECT ServerName, Environment, ServerRole FROM V_ServerDetail WHERE ServerName = ISNULL( @ServerName, ServerName ) ORDER BY ServerNameBut your solution is better since it works for NULL columns /rockmoose
2004-07-15
Does anybody know what this meansMicrosoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]The query processor could not start the necessary thread resources for parallel query execution.
2004-05-26
5 reads
you can also change de database-ower (exec sp_changedbowner @loginame = 'theOneAndOnly' ,@map = 'true' ) Then that user by default creates dbo-objects. If he/she wants older existant 'theOneAndOnly' -tables, he/she should qualify them !con : there can only be one database-owner !
2004-01-09
1 reads
I'm seperating the columns out due to the size of the database. This is more of a data warehouse than anything else. I'm not sure how to join the tables together when inserting the data. I've been browsing through the BOL, but haven't found anything yet. - JH
2003-08-04
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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