This soln will work for the smaller database .If in case server is not having sufficient space or takes long time to restore the complete database .This is not reasonable to restore complete database to get one table which is less than 1 mb.I have other soln for this
2004-11-01
How are you deleting them now? I think you are probably doing something like:delete from myTable where myColumn = 'somevalue' If there is an index on myColumn and SQL is using it, then I'm not sure you can get any better than that.
2004-10-11
FWIW -You might want to use Performance Monitor to monitor memory usage. Your variability in execution time may be reflected in memory and/or thread usage by DTS. We use DTS to load data from various systems into a data warehouse running on SQL Server and had performance issues and ended up moving the various DTS […]
2004-10-01
Since no one has replied, I wanted to take this opportunity to do a little clarifying.. The job I spoke of earlier that won't run.. runs if I change it's owner to an NT Authenticated user from our old Domain. Our Server was migrated to an Active Directory Domain, and now all of the Active […]
2004-09-16
Very nice product. It dumps 13Gb in less then 5 minutes on our SAN. And you see virtually no load on the processor's. I am very happy that I found this product, because we keep 3 days of backup's on disk, and the total needed drive-space is a lot less now. I do reletively often […]
2004-07-23
You can try scm.exe. Check in BOL for parameters. You also have a Restart action and remote access.
2004-07-22
I get the above message in ActiveX script when I use Excel_Workbook.Save If I click Continue the files save OK. I have tried manually overwriting the templates on the Production server using Excel 97 but this does not seem to resolve the problem when I rerun the package. Apart from completely rebuilding the templates starting […]
2004-07-13
23 reads
I experienced a similar problem a few times: some lines in a Stored Procedure didn't work. I dropped those lines and wrote it anew from scratch (in Enterprise Manager), and it worked.I suppose there were some characters in those lines that Enterprise Manager doesn't show ...
2004-04-30
2004-04-24
Just guessing here, but is it the image that says that SQL Server 2000 is not supported below Service Pack 3? If so, don't worry, just click the button to ignore the message and continue the installation, then install SP3a once the initial install is complete.
2004-04-06
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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