Interview Questions Feb 24, 2006

What is Native Image Generator (Ngen.exe)?
The Native Image Generator utility (Ngen.exe) allows you to run the JIT
compiler on your assembly's MSIL and generate native machine code which
is cached to disk. After the image is created .NET runtime will use the
image to run the code rather than from the hard disk. Running Ngen.exe
on an assembly potentially allows the assembly to load and execute
faster, because it restores code and data structures from the native
image cache rather than generating them dynamically.Native images load
faster than MSIL because JIT compilation and type-safety verification
is eliminated.
Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
jobatyourdoorstep@.yahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstep@.yahoo.co.inShiprasad Koirala|||"Jobs" <jobatyourdoorstep@.yahoo.co.in> schrieb:
> The Native Image Generator utility (Ngen.exe) allows you to run the JIT
> compiler on your assembly's MSIL and generate native machine code which
> is cached to disk. After the image is created .NET runtime will use the
> image to run the code rather than from the hard disk.
There's a little contradiction in the two sentences above. The native image
is stored in a special area of the GAC on the disk (typically harddisk).
BTW: In general Microsoft's public newsgroups are a place for peer support
and not an advertising platform.
--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Interview Questions Feb 24, 2006

What is Native Image Generator (Ngen.exe)?
The Native Image Generator utility (Ngen.exe) allows you to run the JIT
compiler on your assembly's MSIL and generate native machine code which
is cached to disk. After the image is created .NET runtime will use the
image to run the code rather than from the hard disk. Running Ngen.exe
on an assembly potentially allows the assembly to load and execute
faster, because it restores code and data structures from the native
image cache rather than generating them dynamically.Native images load
faster than MSIL because JIT compilation and type-safety verification
is eliminated.
Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
jobatyourdoorstep@.yahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstep@.yahoo.co.inShiprasad Koirala|||"Jobs" <jobatyourdoorstep@.yahoo.co.in> schrieb:
> The Native Image Generator utility (Ngen.exe) allows you to run the JIT
> compiler on your assembly's MSIL and generate native machine code which
> is cached to disk. After the image is created .NET runtime will use the
> image to run the code rather than from the hard disk.
There's a little contradiction in the two sentences above. The native image
is stored in a special area of the GAC on the disk (typically harddisk).
BTW: In general Microsoft's public newsgroups are a place for peer support
and not an advertising platform.
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Interview Questions Feb 24, 2006

What is Native Image Generator (Ngen.exe)?
The Native Image Generator utility (Ngen.exe) allows you to run the JIT
compiler on your assembly's MSIL and generate native machine code which
is cached to disk. After the image is created .NET runtime will use the
image to run the code rather than from the hard disk. Running Ngen.exe
on an assembly potentially allows the assembly to load and execute
faster, because it restores code and data structures from the native
image cache rather than generating them dynamically.Native images load
faster than MSIL because JIT compilation and type-safety verification
is eliminated.
Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
jobatyourdoorstep@.yahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstep@.yahoo.co.in
Shiprasad Koirala
|||"Jobs" <jobatyourdoorstep@.yahoo.co.in> schrieb:
> The Native Image Generator utility (Ngen.exe) allows you to run the JIT
> compiler on your assembly's MSIL and generate native machine code which
> is cached to disk. After the image is created .NET runtime will use the
> image to run the code rather than from the hard disk.
There's a little contradiction in the two sentences above. The native image
is stored in a special area of the GAC on the disk (typically harddisk).
BTW: In general Microsoft's public newsgroups are a place for peer support
and not an advertising platform.
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Interview questions and answers

Hi,
Can someone please point me to a link which include SQL Server interview
questions and answers on database administration, performance tuning at
expert level (400)?
Thanks,
EinatTry these:
SQL Server Interview Questions
http://vyaskn.tripod.com/iq.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Gil" <gillapid@.google.com> wrote in message
news:%23N2%23kSw%23GHA.4376@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Can someone please point me to a link which include SQL Server interview
> questions and answers on database administration, performance tuning at
> expert level (400)?
> Thanks,
> Einat
>
>

Interview questions and answers

Hi,
Can someone please point me to a link which include SQL Server interview
questions and answers on database administration, performance tuning at
expert level (400)?
Thanks,
EinatTry these:
SQL Server Interview Questions
http://vyaskn.tripod.com/iq.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Gil" <gillapid@.google.com> wrote in message
news:%23N2%23kSw%23GHA.4376@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Can someone please point me to a link which include SQL Server interview
> questions and answers on database administration, performance tuning at
> expert level (400)?
> Thanks,
> Einat
>
>

Interview questions

Hello,

I have an interview coming up for a vb.net programmer and work involves Reporting Services. What questions/tests could they possibly ask me?

Thanks in advance

Hi,

The forums is basically a place where you can ask your doubts/queries etc. For interview questions, it would be better if you search Google. There are a lot of inteview questions sites too.

Regards,

Vivek

Interview Questions

Ok .. I was just thinking about all the interviews i ve had , and those I ve taken ...

What are the questions you would ask a DBA if you are allowed to ask him only 3 questions and have to judge him on that ?

My favourites would be Disaster recovery, Nested transactions and Linked server concepts !!!

Gurus !! Your Ideas please ?I have to restrict it to just three questions, eh? This would depend on how many years of experience the person claims on their resume.

What is your strongest area of knowledge?
This is an easy one one to lure them in. Should tell you what they want to sell, too. Also, you can expand on this to see if you think they got all of those years of experience, or backdated a bit of their resume.

Why are you applying for this job?
Think about your own answer to this one. After all, it is better to be working with folks who share some goals (money, training, etc.)

What is your biggest screw-up, and what did you do about it?
If they say "I covered it up" tell them Enron is down the hall.|||What is the level of dba ? In previous interviews, I gave them a quiz to test specifics before the interview. During the interview, I ask open-ended questions (Department Z needs a database installed - what questions do you need answered before starting) - similar to MCrowley. I like the screw-up question. Anyway, if you ask open-ended questions, after they have finished answering, I normally follow-up with give me an example ... Another useful question is - what have you learned about sql server that you could not find in a book - the nuances most of us have experienced.

interview questions

hi friends,
i want some advanced interview questions that is questions, giving some
situation. and also some intresting questions.
thanks
vanithaSearch Goolge "SQL Interview Questions"
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"vanitha" <vanitha@.discussions.microsoft.com> wrote in message
news:A3B00B7A-B0F3-4804-A033-3F3CDE1BBFAD@.microsoft.com...
> hi friends,
> i want some advanced interview questions that is questions, giving some
> situation. and also some intresting questions.
> thanks
> vanitha|||For question go here:
http://www.sqlservercentral.com/testcenter/qod.asp
For answers... study. :)
ML
http://milambda.blogspot.com/|||Has anyone here every actually been "quized" during an interview.
I 've been sent to online testing sights before, but only once have I ever
actually been asked a "knowledge testing" question during an interview... an
d
I actually guessed the right answer right answer then.
"ML" wrote:

> For question go here:
> http://www.sqlservercentral.com/testcenter/qod.asp
> For answers... study. :)
>
> ML
> --
> http://milambda.blogspot.com/

interview question?

How many tables can be updated with a single update ?I would answer only one
but I'm curious of the exact answer|||even i support one ,but it is correct|||One|||I think one|||zero (where clause finds no rows)

one (duh)

many (updated row cascades to related tables)|||Cascading updates ... hmm ... why didnt I think of that ...

Well .. seems like I lost any chance of getting this job|||What does n mean ... Mr BK|||brett probably means m, not n

m is n + 1

:cool: :cool: :cool: :cool: :cool: :cool: :cool:|||I thought n meant any number...

m to me means many, but infers a relationship as in 1-m

either way...

However, here's a poll type question...how many people use cascade...

I've never...always wanted more control...prefer to delete and insert...

(And keep history)|||Never !!!|||when updates are performed, if you're writing audit records or something, those triggers should fire no matter whether the table being updated is the target table or a related table, right?

oh, and to me, m implies 0 to many, not 1 to many

my answer to the question was "zero, one, or many"

;)|||Originally posted by r937
when updates are performed, if you're writing audit records or something, those triggers should fire no matter whether the table being updated is the target table or a related table, right?

oh, and to me, m implies 0 to many, not 1 to many

my answer to the question was "zero, one, or many"

;)

fair enough...but now we trapse down the logical data modeling path...

things are not always 0-m...could be required to be 1-m...

EDIT: And you didn't answer the cascade question...|||sorry, i assumed my answer to the cascade question would be obvious

i use as much RI (http://evolt.org/RI) as the database supports

unless i'm doing consulting work at a cllient site where there's a DBA with veto on changes or exceptions to his database guidelines...

but that's politics ;)|||That's a great link...love the VW...

And yes, I get the cascade answer...you must be a big IDENTITY kind of guy...

I never thought of cascading as a function of RI though...

but it seems related...

no pun intended|||I use cascading for RI whenever possible. There have been a few times where I have modeled relationships with multiple update paths, and then Cascading fails and I had to resort to triggers.|||Originally posted by Brett Kaiser
That's a great link...love the VW... thanks

actually, when it comes to the natural versus surrogate primary key debate, i tend to favour natural keys, insofar as any candidate key can be called "natural"

however, i have been know to use IDENTITY and its cousins AUTONUMBER, AUTO_INCREMENT, and SEQUENCE from time to time

one of the best articles on the subject, long but very worth the time to read, is Key Points About Surrogate Keys (http://www.rationalcommerce.com/resources/surrogates.htm)|||i think guid is coming up ;)|||You know...|||why I outta...Moe, Larry build a database...

Interview question stored procedure

Can anyone answer ths question please.

If your page is running slow what sould u check specifically with the store procedure. What is it tht you might think is giving a problem. or how would u go about see what making your stored procdure run slow.??

Give these articles a try:

http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx

http://articles.techrepublic.com.com/5100-22-1045447.html

http://www.mssqlcity.com/Tips/stored_procedures_optimization.htm

|||

Absolute basics are check the execution plan, look for things like table scans which could be turned into index seeks by adding indexes, perhaps use the database engine tuning advisor.

Check the SQL for subselects where joins could be used instead, multiple predicates where an IN or BETWEEN clause would be better, unnecessary ORDER BY or DISTINCT instructions, possibly split up stored procedures which have the format

if inputvar = true

do this select

else

do that select

into separate sub-stored procedures for each select with the top level sp just doing the logic and then calling the appropriate sub proc (having multiple optional queries in the same proc means that the query plan may have to be re-generated each time, which costs performance)

Lots of other things you can do too, which I'm sure are mentioned in the above answer's links.

Interview Question

Hello all,
i'm aware of oracle, but i had a quesrtion in SQL Server today in an interview. Which i didn't understand well. But the question is "We have a cursor in SQL Server and what should we do to drop the cursor and keep the logic". Actually i didn't understand the question well, but those are the exact words. Please let me know if any of you have any idea about this.

Actualluy when i was talking to some one he said that we need to use "temp tables" for that. I have no idea about that. I would really appreciate if someone can clear this for me.A short answer would be to change processing logic from row-based to set-based. However, if the requirement of logic was intended to be interpreted literally, then a cursor can be replaced with a WHILE loop where the key that uniquely identifies each row from the table (or tables) that you're processing can be represented in one field.|||You would need to look at the requirement for the process and rewrite it as a set based solution.

It may or may not benefit from a temp table or a loop.

Would also review the rest of the processing, design, architecture as the presence of cursors usually indicates that someone who is not very experienced at develoiping on relationtional databases has been involved.|||I'm still new to al this, but I was wondering:

Won't using cursors be faster and saves database storage space sometimes during a calculation then having to go through creating, inserting ,selecting from a temp table and later droping it?|||cursors place locks on your tables and therefor cause waits for others users that want to modify data.|||Cursors are very fast in Oracle (providing it's not sitting on Windows), but in MSSQL it's the method of "last resort".|||Originally posted by Patrick Chua
I'm still new to al this, but I was wondering:

Won't using cursors be faster and saves database storage space sometimes during a calculation then having to go through creating, inserting ,selecting from a temp table and later droping it?

SQL Server is efficient at actions that work on sets of data which the sort of processing that sql and relational databases are built for.
It is innefficient at procedural processing which is the sort of thing you would find in a client.

Sometimes a cursor can be faster than the equivalent set based sql (especially with correlated subqueries) but I still wouldn't use one.

With Yukon and the proposed common language runtime then maybe procedural code can be embedded in t-sql and things may change.|||Thanks for the insights.

Will try not to use cursors, but it always the easiest way out. :)

Yukon!, almost didn't really get what u mean, but I remember reading it in SQL Mag as a code name for the next SQL Server edition ...just letting others who are as blur as I am know.
er..right?|||Yep.

>> Will try not to use cursors, but it always the easiest way out.
It's the easiest only if you think of processing row by row.
I always ban cursors from code to force people to find a set based solution.|||can't wait till yukon comes out.

As for cursors, - their usage starts at design time. The old school designers are the ones to blame for what developers and DBA's have to live with :)

interview question

when does sql use update lock?>>> is the salary worth it ?

see BOL for that answer

interview question

here is a question asked in a interview:
u created the sales database with the initial size of hte transaction log of 50 mb with autogrow, but no autoshrink
u do not make any backup and donot set the truncate log on check point option to on.
what will be the transaction log size after the next check point has passed?Umm... >= 50mb|||You are in a job interview where the person hiring asks you inane and pointless questions that have little or no value in either database administration or database design, and for which the answers could easily be looked up in Books On Line. At the end of the interview, you are offered the job at a substantial salary bump. Do you work for the dolt, or do you continue seeking an employer that has actual competence?|||lol@.blindman. In the instance above, you tell him he hasn't provided you enough information (which he hasn't btw). If he could do some research though, create a business proposition for why he should waste your time answering stupid questions, get business signoff, send it through QA and user-acceptance testing, then test the release, you'll have a production answer for his highness right away.|||First, there's no "Trancate on checkpoint" in 2K, which means they are talking about 7.0 or 6.5, which is bad in itself.

Second, unless a user process kicked in within less than 0.00000001 millisecond after the "create database..." statement completed, peterlemonjello's answer is almost absolutely correct, - except it will be 50MB exactly, not more or equal to.|||hmmm what an interesting way of asking for clarification... I like it. :D
by the way, it was't me who was being interviewed and it was a colleague of mine, I wasn't sure about the question itself so thought to get some expert comments from the guru's here.
anyways thnks for the replies :p

Interview question

I was asked in an interview what was the fastest way to count the rows in a
table?
I assume that: Select count(*) from Tablename - is or is not the fastest way
.
Is there another way that is faster or did I miss something.
thanksYour query would result in a full table scan. You can
also do this:
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid < 2
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.masterado.net
"brian" <brian@.discussions.microsoft.com> wrote in message
news:585DEB83-4414-4FD6-BDEA-2CF49C47FAB3@.microsoft.com...
>I was asked in an interview what was the fastest way to count the rows in a
> table?
> I assume that: Select count(*) from Tablename - is or is not the fastest
> way.
> Is there another way that is faster or did I miss something.
> thanks|||The count returned by this method can be used as an approximation but might
not be accurate. The SELECT COUNT(*) method should be used in normal
production code.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:e1WlYqQ2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Your query would result in a full table scan. You can
> also do this:
> SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid <
> 2
>
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.masterado.net
>
>
> "brian" <brian@.discussions.microsoft.com> wrote in message
> news:585DEB83-4414-4FD6-BDEA-2CF49C47FAB3@.microsoft.com...
>|||> Your query would result in a full table scan.
Not necessarily. SELECT COUNT(*) FROM tblname can use (scan) any index on th
e table. Preferably
there is an index on a narrow column, and SQL Server can scan that index (le
ss pages to read).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:e1WlYqQ2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Your query would result in a full table scan. You can
> also do this:
> SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid <
2
>
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.masterado.net
>
>
> "brian" <brian@.discussions.microsoft.com> wrote in message
> news:585DEB83-4414-4FD6-BDEA-2CF49C47FAB3@.microsoft.com...
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote in message news:uT63vfT2FHA.892@.TK2MSFTNGP12.phx.gbl

> Not necessarily. SELECT COUNT(*) FROM tblname can use (scan) any
> index on the table. Preferably there is an index on a narrow column,
> and SQL Server can scan that index (less pages to read).
Wouldn't a clustered index be the fastest possible, so that the rows are lin
ed
up for a quickie?
I doubt, therefore I might be.|||> Wouldn't a clustered index be the fastest possible, so that the rows are
> lined up for a quickie?
Not sure what you mean by 'lined up' but the issue with the clustered index
is that the clustered index leaf nodes are the data rows. Consequently, the
scan of a 10GB table with 100M rows will require scanning 10GB of data. A
scan of a non-clustered index on an int column of that table will only scan
about 400MB data (plus overhead) in the non-clustered leaf nodes. This is
why the optimizer chooses the narrowest available index for the COUNT(*)
operation.
Hope this helps.
Dan Guzman
SQL Server MVP
"Kim Noer" <kn@.nospam.dk> wrote in message
news:uDKVnIW2FHA.1148@.tk2msftngp13.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote in message news:uT63vfT2FHA.892@.TK2MSFTNGP12.phx.gbl
>
> Wouldn't a clustered index be the fastest possible, so that the rows are
> lined up for a quickie?
> --
> I doubt, therefore I might be.|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Ooe7gxW2FHA.2216@.TK2MSFTNGP15.phx.gbl

> in the non-clustered leaf nodes. This is why the optimizer chooses
> the narrowest available index for the COUNT(*) operation.
Thanks for the clarification!
I doubt, therefore I might be.|||"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:e1WlYqQ2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Your query would result in a full table scan. You can
> also do this:
> SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid <
> 2
>
You don't have to do a table scan. A scan of a secondary index will work
too. Moreover the value in sysindexes is not guaranteed to be correct. So
"Select count(*)" is correct, although the "right" answer probably touches
on all these issues.
David|||No, this will not always need to do a full table scan. Since every
nonclustered index has a pointer to every row, a leaf scan of any nc index
will also give an accurate result.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:e1WlYqQ2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Your query would result in a full table scan. You can
> also do this:
> SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid <
> 2
>
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.masterado.net
>
>
> "brian" <brian@.discussions.microsoft.com> wrote in message
> news:585DEB83-4414-4FD6-BDEA-2CF49C47FAB3@.microsoft.com...
>
>

Interview question

Hi,
I had a job interview yesterday and they gave me a small test to complete.
One of the questions was the following... I was not sure what to answer...
If you have the following table:
CREATE TABLE [Customers] (
[FirstName] [varchar] (50) NOT NULL ,
[LastName] [varchar] (50) NOT NULL
) ON [PRIMARY]
And all the queries that you will have for this table are like these:
1. LastName ='Simpson'
2. FirstName ='John' and LastName='Smith'
3. LastName='Parker' and FirstName like 'J%'
4. LastName ='Owen'
5. FirstName ='Danny' and LastName='Jackson'
6. LastName='Owen' and FirstName= 'Michael'
7. LastName like 'A%'
.
(with different values for FirstName and LastName):
What kind of index (only one) do you think it would be more effective for
running those queries faster? Please, explain why.
Any ideas?
Thanks!!On Thu, 10 Mar 2005 10:07:23 -0500, Star wrote:
(snip)
>What kind of index (only one) do you think it would be more effective for
>running those queries faster? Please, explain why.
Hi Star,
A composite index on (lastname, firstname) would be best. Since there
are no other columns in this table, might as well make it clustered.
Reason: all queries presented include at least the last name (or the
start of the last name); some include (part of) the first name as well,
so each query can use this index to immediately jump to the part of the
index where matches are.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Clustered index on (lastname, firstname).
The common column in all queries is Lastname so it should appear first in
the index. Clustered because if you have only one index it usually makes
sense to cluster it.
David Portas
SQL Server MVP
--|||create nonclustered index ix_nc_customers_lastname_firstname on
customers(lastname, firstname)
go
- nonclustered
- composite
- first column should be LastName in order to allow 1, 4 and 7
AMB
"Star" wrote:

> Hi,
> I had a job interview yesterday and they gave me a small test to complete.
> One of the questions was the following... I was not sure what to answer...
> If you have the following table:
> CREATE TABLE [Customers] (
> [FirstName] [varchar] (50) NOT NULL ,
> [LastName] [varchar] (50) NOT NULL
> ) ON [PRIMARY]
> And all the queries that you will have for this table are like these:
> 1. LastName ='Simpson'
> 2. FirstName ='John' and LastName='Smith'
> 3. LastName='Parker' and FirstName like 'J%'
> 4. LastName ='Owen'
> 5. FirstName ='Danny' and LastName='Jackson'
> 6. LastName='Owen' and FirstName= 'Michael'
> 7. LastName like 'A%'
> ..
> (with different values for FirstName and LastName):
>
> What kind of index (only one) do you think it would be more effective for
> running those queries faster? Please, explain why.
>
> Any ideas?
> Thanks!!
>
>|||An Index on LastName, FirstName would be the most optimal as there is no
occurance of
FirstName column only.
The above index will be used by both the criterias which have
LastName,FirstName and just
LastName.
Gopi
"Star" <nospam@.nospam.com> wrote in message
news:e88xfLYJFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I had a job interview yesterday and they gave me a small test to complete.
> One of the questions was the following... I was not sure what to answer...
> If you have the following table:
> CREATE TABLE [Customers] (
> [FirstName] [varchar] (50) NOT NULL ,
> [LastName] [varchar] (50) NOT NULL
> ) ON [PRIMARY]
> And all the queries that you will have for this table are like these:
> 1. LastName ='Simpson'
> 2. FirstName ='John' and LastName='Smith'
> 3. LastName='Parker' and FirstName like 'J%'
> 4. LastName ='Owen'
> 5. FirstName ='Danny' and LastName='Jackson'
> 6. LastName='Owen' and FirstName= 'Michael'
> 7. LastName like 'A%'
> .
> (with different values for FirstName and LastName):
>
> What kind of index (only one) do you think it would be more effective for
> running those queries faster? Please, explain why.
>
> Any ideas?
> Thanks!!
>|||Thank you, guys!
It helped a lot... now I know for the next time :(|||this interview wasn't in Orlando (or Celebration) Florida was it ?
Greg Jackson
PDX, Oregon|||definately Clustered on LastName, FirstName
GAJ

Interview a Database Administer for MBA Class

Hello, I am a graduate student at Baker College and am working on my MBA. I
am taking a database fundamentals class about how to utilize database
technologies to optimize success in business environments. My homework this
wend is to interview a database administrator/programmer and learn a
little about what they do on a daily basis. If anyone would please fill out
this short form I would greatly appreciate it.
Matt Anderson
Baker College Student in class BUS 562
Which type of projects are you currently working on?
What preparation did you have for this work?
Which parts do you enjoy/not enjoy?
How closely do you work with the end users?
What software programs are in use?
What issues (ie security) do you deal with?
What do you see in the future on this area?Hi Matt,
I'm currently getting my MBA at George Fox University in Portland, Oregon so
I feel your pain....:-)
Answers Below:
> Which type of projects are you currently working on?
I Currently work on large eFinance client software implementations. Banking
customers purchase our software, I"m an engineer\DBA that helps implement
and customize per client.
> What preparation did you have for this work?
Requires excellent .NET skills and Database Admin and Architecture skills

> Which parts do you enjoy/not enjoy?
I enjoy the custom implementations. Dont enjoy cutover events where we are
usually up and working on rolling new system into production from a friday
night to a saturday mid day (all nighters)...

> How closely do you work with the end users?
I dont typcially work with end users who are the Banks On-Line Banking
customers.

> What software programs are in use?
Microsoft .NET and SQL Server 2000

> What issues (ie security) do you deal with?
Security is a huge issue in online banking and efinance. Loss of data,
fraudulant activity, Phishing, etc are all very significant threats.

> What do you see in the future on this area?
This industry is growing and security will be a primary area of growth.
hope this helps,
Cheers,
Greg Jackson
PDX, Oregon|||"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:ejqDvJ%23OGHA.984@.tk2msftngp13.phx.gbl...
> Hi Matt,
>

> hope this helps,
> Cheers,
> Greg Jackson
> PDX, Oregon
>
It does! Thanks!
Matt