Yet another way to include portability on DTS packages
An proposal about using simple server name resolution and INI files to make a DTS package portable.
2008-04-10
4,202 reads
Configuration
2005-05-29
RE: Bug in Enterprise Manager
Can you specify exactly the steps to reproduce this? Since you are seeing it on different boxes I guess you have encountered a bug, and the only way to get it fixed is to open a case with MS Support for it. Also, since Service Pack 4 was released three days ago, check if it […]
2005-05-09
Connect Business Object to Analysis Services
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-01-17
RE: Help required urgent for DB
If file recovery doesn't do it, call MS. They might get you to a stable state. Also, do a full backup of your db file (the .mdf) right now. That's got the data.
2005-01-10
RE: Deletes take forever
Related to the foreign key suggestion - do you have indexes on the foreign key columns in the other tables? This will speed the lookup significantly.
2005-01-01
RE: sql reporting services - batch pdf generation
Also found this third party soft ware independent of Reporting Services.pretty cool I thoughthttp://www.dynamicpdf.com/
2004-11-09
RE: StoredProc is slow from ASP but not from QA
You can try to give index hint to the queried tables explicitly. In this scenario, your are not trusting sql optimizer.Give no lock hint as well if the chance of dirty read is very low.
2004-10-21
Insert into table
I am running backend SQL2000 and front end Access 2003 ADP. I have a view created on two tables and a Form on the view. Form has some fields and user enter the information and click the save to insert the records to new table. In the form has two date field one system date […]
2004-09-16
What is your experience with outsourcing.
I am curious to know what peoples experience has been with outsourcing.In the UK there is a lot of tension over IT jobs being outsourced to India and other low-wage locations.What are peoples experiences, good and bad?
2004-06-18
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers