First of all do you really want your data to be globally unique? For example if you are trying to implement a merge replication that will transfer and receive data...

Absolutely it will. It will restore the tables, data, indexes and all other db objects.

Amol

Hi,

Sending the data thru SSRS, webservice, backup, replication seems to be overkill here, best and the fastest way to send such small amounts of data would be to create a...

Could you please elaborate your issue? Your statement doesn't tell what kind of manipulation you need.

Thanks,

Amol

Hi,

Best way would be to design a star-schema database and then load your data from the OLTP db to this star-schema database using ETL process. ETL process could be implemented...

Waleed,

NEWID() and NEWSEQUENTIALID() are both used to generate GUIDs, NEWSEQUENTIALID() was introduced in SQL Server 2005 to generate sequential GUID's. The advantage of using Sequential GUIDs is it performs much...

Manko T,

It's probably related to the permission issues on the file directory, since the Jobs runs under the credentials of SQL Server agent, check to see if that credentials has...

Use the SQL Query in the Execute SQL Task, set the resultset as "Full Result set", in the results use a variable that is defined of type "Object".

Use the For...

As George mentioned DO NOT keep shrinking the log file, its probably undersized now.

The reason for the large transaction log size is because they have not been backed up....

Best is to leave the formatting and case conversions at the front end application, should try not to use SQL Server for formatting and case conversion tasks which are easily...

DBCC CHECKIDENT([tablename], RESEED, [new_reseed_value])

GO

Thanks,

Amol

Hi,

Parsing of variable length columns text file could also be achieved using the Script Transform component in SSIS. Will involve some amount of VB.NET scripting.

Thanks,

Amol

At first i thought the wish list is unreasonable, but by looking at the replies seems like lot of folks are already enjoying most of the wishes if not all....

Congrats Akash, i have been reading the entire post and found some real good debates. By the way where is your job location in India?

Strange but the Stored Procedure got fixed on its own since last week, meaning it's back to 3 minutes now. I didn't change anything.

Thanks anyways.

Amol