I need to execute SSIS package from SQL Server 2000. Is there any way? Looks like, I can not use "Execute Package Task" in DTS to call SSIS...
Hi All, I am trying to install active/active two nodes cluster (Windows Server 2003/SQL Server 2000 – sp3). I had successfully install the first...
I am trying to update a table column after reading the same table through a function. However, it is taking too long. I am getting waiting type:...
The following script is taking too long to update the table that has 14 million records. Is there any alternative way to do the same? Any hint will...
Can I create a cube from a denormalized table (onle one table) in SSAS? I know we can create a cube from a denormalized table in Cognos. Any help...
While the SELECT ..... INTO batch was running, I executed the sp_who2 to see the status. I saw the status was "Sleeping" but the batch was running...
Hello, It is taking too long to run the following query: Note: I have indexes on all of the columns in conditions. My temp db size is 18 GB....
Would anyone tell me what is the advantages choosing indexed views over tables? As far as the spacing is concern, both the indexed view and the...
Hello,<br />I was trying to create 14 indexes on a table that has around 80 millions records. But got the following error message:<br /><br />Name:...
Because of the disk failure, we had to do restore disk files (including the databases) from a disk back up. However, we can not see any DTS package....
My database size is around 250 GB. How much free space should I keep in the database for best performance. Most of the time we update the database...
In my data file, there is no free space, I shrink the data file. My "select * into" is gettting hung. How can I add free space to the data file...
I am trying to log DTS package with steps/tasks info into a SQL Server table. I need the following info: Package name, step description, step...
Separate names with a comma.
