-
as seen on SQL Authority
- Search for 'SQL Authority'
About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level.
Here, I need your…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
List of all the Interview Questions and Answers Series blogs
Posts covering interview questions and answers always make for interesting reading. Some people like the subject for their helpful hints and thought provoking subject, and others dislike these posts because they feel it is nothing more…
>>> More
-
as seen on Programmers
- Search for 'Programmers'
I know there have been a great deal of interview questions posted on SO and specifically i like the post "Good C# interview questions for a Senior developer position"
But i really wondered what sort of interview questions were asked to a senior developer or technical consultant on multithreading…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Let's have a list of some good interview questions for SharePoint developers. Please provide one question per entry, and if possible, the answers.
Also, please feel free to suggest corrections if the provided answers are wrong.
I will go first:
Q: How does SharePoint store pages?
A: How-to-locate-sharepoint-document-library-source-page-on-the-server…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I've been asked to screen some candidates for a MySQL DBA / Developer position for a role that requires an enterprise level skill set.
I myself am a SQL Server person so I know what I would be looking for from that point of view with regards to scalability / design etc but is there anything…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
AUTHOR table
Author_ID, PK
First_Name
Last_Name
TITLES table
TITLE_ID, PK
NAME
Author_ID, FK
DOMAIN table
DOMAIN_ID, PK
NAME
TITLE_ID, FK
READERS table
READER_ID, PK
First_Name
Last_Name
ADDRESS
CITY_ID, FK
PHONE
CITY table
CITY_ID, PK
NAME
BORROWING table
BORROWING_ID,pk
READER_ID…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
here is my 3 tables:
table 1 -- stores user information and it has unique data
table 2 -- stores place category such as, toronto, ny, london, etc hence this is is also unique
table 3 -- has duplicate information. it stores all the places a user have been.
the 3 tables are linked or joined by these…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have question about normalization.
Suppose I have an applications dealing with songs.
First I thought about doing like this:
Songs Table:
id | song_title | album_id | publisher_id | artist_id
Albums Table:
id | album_title | etc...
Publishers Table:
id | publisher_name | etc...
Artists Tale:
id…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi all,
I am trying to make a fashion boutique site.
In this site each product (t-shirt,jeans etc) belongs to a collection. Each collection has looks (t-shirt,jean,accessories). A product can belong to one collection and to multiple looks. How should I design the database?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi all,
I have a quick question regarding a database that I am designing and making sure it is normalized...
I have a customer table, with a primary key of customerId. It has a StatusCode column that has a code which reflects the customers account status ie. 1 = Open, 2 = Closed, 3 = Suspended etc…
>>> More
