Thank you All for your suggestions.

If there are no performance difference between a view and querying from a fact table then What are the advantages of creating views in database?...

Thank you for your response.

Hi Craig,

Thanks for your reply.I opened the package in BIDS but i was not able to see any errors.

Also compared the columns between the source and target and was not...

Thanks for Sharing the script.

I would also like to if there are any guidelines or best practices to be followed while setting up a security model for a data warehouse.

Hi Livingston,

The procedure is a simple delete statement on a table based on ID column and the total number of rows is 25.

Table in which i am trying to delete...

Hi

Please refer the below links

http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/

http://www.sqlservercentral.com/articles/partition/64740/

Steps i would suggest

1)Create a new partitioned table with a clustered index on the partitioned column

2)Load the data from original table to the new table

3)Rename the...

Hi,

I think you can consider the option of partitioning the table since it has more than 1 billion records.In order to make use of partitions effectively, the query’s where clause...

Hi Alex,

I guess we will not be able to do it as our database is in simple recovery mode.

Is there any other better way?

Hi Ron,

Thanks for your reply.Please see the details below

--Table 1

CREATE TABLE PROCESS

(NAME [varchar](50) NOT NULL,

[PROCESS_END_DT] [datetime] NOT NULL)

---Trigger 1

CREATE TRIGGER [dbo].[PROCESS_1]

ON [dbo].[PROCESS]

AFTER UPDATE

AS...

Thanks for your reply

I just have one more clarification

IF '12/07/2012'<'12/01/2013'

For the mentioned condition the first value is the same and second value is greater and again the condition should...

Thanks for your reply

Unfortunately i am still not able to do this.Please see the details below

Scenario:

I have a login test_login which has role as db_datareader and db_datawriter.

Created this stored procedure...

Thanks for your reply

The user has permissions to execute the stored procedure.The stored procdure is having CREATE,ALTER TABLE, ALTER PARTITIONS statements in it?

Iam just looking to restrict a login only...

Thank you all for the inputs.

When i execute this i get the below results

SELECT *

FROM #FILE_PROCESS_LOG

WHERE FILENAME LIKE 'FON_smp1_D062012_%'

...

Thanks for your suggestion.

I have one more problem

When i use (DT_DBTIMESTAMP)(SUBSTRING([Column 5],5,2) + "-" + SUBSTRING([Column 5],7,2) + "-" + SUBSTRING([Column 5],1,4) + " " + SUBSTRING([Column 5],9,2) + ":"...

Thanks for you help.

I have one more problem

When i use (DT_DBTIMESTAMP)(SUBSTRING([Column 5],5,2) + "-" + SUBSTRING([Column 5],7,2) + "-" + SUBSTRING([Column 5],1,4) + " " + SUBSTRING([Column 5],9,2) + ":"...