Hi Solomon,

Sorry that I had to get to do a lot of other tasks, could get back to this only today. Thank you for the explanation and the suggestions.

I overloaded...

Regarding the memory issue and SAFE vs UNSAFE, there is not much you can do:

1) The TimeZoneInfo class is known to have memory leaks which is why it has a...

Thank you again Dwain. I already wrote a function which takes in a string and returns datetime. (returns 1/1/1900, if it's an invalid date format or gibberish.) That solved it....

Hi Dwain,

My query seemed to work on some server which runs SQL server 2000. When I execute the same on SQL Server 2008, I get the error: Conversion failed when...

Thank you Dwain, got that. My bad, I should've tried with:

before I posted here.

🙂

Hey Seth,

Got it! nvarchar(512) takes 1024 bytes because it's unicode. Since my windows paths are always ASCII, I could have declared the column in the table as varchar(512) which takes...

Dude, that was a mistake in changing the name of the table, before copying the piece of the code and removing company specific info and other parts, not concerned with...

You can set an xp_cmdshell proxy to make the copy. By default I believe it uses the SQL Server service account. If you haven't set a proxy, and are using...

Are there actually two users who do this?

If so, the first user when he selects top 10 records, he can create a view let's say "UserView" with these 10 records.

the...