Date Range
Date Range
Date Range
Friday, March 30, 2012. Problems Linking to Oracle Server. Has anyone successfully linked to an Linux Oracle server running 9i? We are unable to get the link working. have installe dvarious drivers and still get connection refused. Any thoughts? If this is a Linked Server issue I would try the SQL Server Engine forum. Problems linking Access to SQL replicated tables. I was wondering if anyone could help me. I am running an Access application that uses linked tables to connect to a SQL server.
Friday, March 30, 2012. Problem with Maintenance Plan to delete files older than 2 days. Hoping that someone in the group can shed some light on an issue Im. We are trying to all delete backup files older than say two. Days Ive tried a few methods, none of which have worked so far. If I create a new Maintenance Plan and add a Maintenance Cleanup Task. And set it to delete all files in a given directory of a given.
Friday, March 30, 2012. I have a table with 5 primary keys. I have clustered index defined on. However, I can see that this index is only using three. Why is that? I for some reason when I run queries I get index scan as opposed to. TIt sounds like the indexes you have are not working for you. For us to assist you, please post the table DDL, along with a query or two. That you believe do not properly use indexing.
Friday, March 30, 2012. When I manually run the IS packages to load the data warehouse and then process the dimensions and cubes, everything works fine. When I schedule the packages as jobs, eventually the data goes wrong. The jobs are scheduled in the correct order. If I get your description right, the SSIS packages are not executed in the correct order. Is that so? You can also use SQL Agent jobs directly to send processing commands to Analysis Serivces. Eventually the data goes wrong.
Friday, March 30, 2012. I have a table with 5 primary keys. I have clustered index defined on. However, I can see that this index is only using three. Why is that? I for some reason when I run queries I get index scan as opposed to. TIt sounds like the indexes you have are not working for you. For us to assist you, please post the table DDL, along with a query or two. That you believe do not properly use indexing.
Friday, March 30, 2012. When I manually run the IS packages to load the data warehouse and then process the dimensions and cubes, everything works fine. When I schedule the packages as jobs, eventually the data goes wrong. The jobs are scheduled in the correct order. If I get your description right, the SSIS packages are not executed in the correct order. Is that so? You can also use SQL Agent jobs directly to send processing commands to Analysis Serivces. Eventually the data goes wrong.
Tu as semé la joie.
Thursday, March 29, 2012. A few BLOBs per page. The length of those values are lets say 2KB? Message posted via droptable. You can set the table property to store all large objects out of the row,.
Friday, March 30, 2012. Here is the design I.