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...
Thanks MohammedU for the comments. Before I install the second instance, I must create the server alias. seehttp://support.microsoft.com/?id=815431...
Thanks satya for the comments. You are right, I think I should go with active/passive configuration which is much easier. Thanks! Alim Mia
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...
Yes. The function is useing proper indexes. Am I updating rightly? Thanks, Alim Mia
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:...
Thanks for the comments. However, I have missed both of yours points. How can I get rid of the while loop, and how the update going to work. In...
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...
Thanks, Ranjit. Alim Mia
Thanks. Would you please tell me how that could be done? In general, I can not build a cube from a table. It asks me for dimension table. Please...
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...
Thanks Satya. Alim Mia
Example: sp_who2 output 61 sleeping WINafbd1 WM-PB-Hdddddd71 . MYDB DROP INDEX 11284...
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...
No. The index did not help since i already have an index in another column that is in the join for the same table. My previous email was for giving...
Thanks guys. You right, there was a missing index on the EXCLUSION_FLAG. Alim Mia
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....
Thanks Guys for all the valuable comments [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]!<br /><br />Alim Mia
Thanks for the comments. If I use "SELECT INTO" statement to create the new table which will always bring the latest table structure, then why I...
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...
Separate names with a comma.
