50 millions rows of data is not really that much data. it sounds like you are being blocked. exclusive schema locks, data , etc.

this is my suggestion what you should...

i'l repeat what has already been said: it's a badk idea to expose your SQL se3rver directly to the internet.

that said, un doubtedly, you'll need to modify the router between...

you can do what some people call an exotic join...joins that are not T1.field = T2.field

but things like :

ON UserName = REPLACE(Userlogin,'\Domain','')

or on char index/patindex

ON (CHARINDEX(UserName , Userlogin)...

fantastic job providing the DDL and sample data!

i think you can use row_number() to get what you are after:

SELECT * FROM (

SELECT

ROW_NUMBER() OVER(PARTITION BY symbol ORDER BY quote_date DESC)...

datareaders gives them access to data, i think they just want to see the schema(table NAMEs and column NAMEs)

that permission would be VIEW DEFINITION (in a single database)

or VIEW ANY...

i think since the data is comma delimtied string, you can be sneaky and use LEN / LEN(REPLACE

/*

Att q x ...

here's a DML delete trigger example that is catching a ton of whodunnit information and sending an email;

maybe you can use that as a model?

CREATE TABLE WHATEVER(

WHATEVERID INT IDENTITY(1,1)...

i've edited my working oracle linked server connection with your info, so it seems to match how i've got mine set up:

--#################################################################################################

--Linked server Syntax for Oracle 10G

--#################################################################################################

DECLARE...

rayh 98086 (4/11/2013)

---

Thank you both!

When I check the file, copying into Notepad, I do not see any extra characters. To be safe, I even created created a test by...

usually when i get that error, it's because the files are coming from a UNIX file type, where the rows end in \r instead of \n

usually this fix,...

you have to script the table out , whether via SSMS, powershell, or custom TSQL.

select into newtable only copies an identity definition(if it exists) and column datatype/size/length/nullability.

it does not...

i'd have to see an example of what would actually be prohibited where you said

"Trick questions in a interview are strictly forbidden in working environments governed by EOE"

that doesn't...

the system function sys.dm_exec_sql_text(a.sql_handle) is for SQL2008 and above only.

SQL2005 will throw an error on syntax, because it's not valid. no cross applying functions back then but the...

excellent point, something like this would be five rows in a text editor, but one...

Duran i guess you'd have to show us an example or two from the results of the query, instead of the query itself.

for example, maybe the recommendation is an...