Nope, the interviewer said "running a query". Not using bcp, or dts or insert.
Well the impression I got was that we couldn't use bcp or a dts package. This was to be done through a stored procedure or via a sql statement. Is...
Hi guys, I've been going for a few interviews and wanted to share the type of questions I was asked which weren't the normal kind of questions. 1....
Hi, appreciate the help, however it doesn't sort my problem, the reason being I will still need to have the package id. If I could get the package...
ok, but then I'm still left with the same problem, how do I identify which package I need. Is there a package id property I can retrieve from within...
Hi, I'm trying to find a DTS package name dynamically from within the package. I can't for the life of me find out to get this property through the...
Right guys, I understand the difference between nvarchar and varchar. The difference is that nvarchar uses twice as much space as varchar. However I...
ok, the row size is reduced, however when i right click ont he database in enterprise manager and click properties the overall size of the database...
Hi guys, I've read through the links. I already had a clustered index and several non-clustered indexes set up on the server. I also have run...
I have a database that was originally 18 Gb in size with 9 million records. After consideration I decided many columns that were oversized should be...
Thanks guys you've given me enough to read up on. I have a questionn for LuisMartin though... When you say "Run profiler from WS and whit filters"...
I know it sound stupid but at the time I said I would test the process in a dev environment and see if I could replicate the issue, to which he...
I got asked an interview question today in a large Investment Bank and wasn't sure of the answer. The question went like this: If on a production...
Separate names with a comma.
