Answer Posted / indraneelandhavarapu

You can use File system task of SSIS to rename file and
folders dynamically.

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2498

---

What is the data tier application?

169

---

What are different types of collation sensitivity?

977

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

937

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1016

---

What is the ‘fillfactor’?

952

---

How will you add a dimension to cube? : sql server analysis services, ssas

1060

---

How to receive output values from stored procedures?

1122

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

1953

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1019

---

What is the filtered index?

1027

---

What are the types of subscriptions in SQL Server replication?

1014

---

What is sql server schema compare? How we can compare two database schemas?

1008

---

What is merge?

990

---

What is the advantage of sql server?

1015

---