This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
SQL SERVER – 2008 – Interview Questions and Answers – Part 1
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships…
Read MoreSQLAuthority News – 700 Articles and Author Updates
It is always interested to write article when reached at milestone. I start to receive many emails and suggestions just about when this blog is reaching any milestone. One question keep on coming to me is why do I write or what is in it for me? Satisfaction! I enjoy…
Read MoreSQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site
SharePoint is one interesting software from Microsoft. My outsourcing location unit is working on one large project of SharePoint. Based on users feedback and overwhelming response to article SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name I am posting one more article which…
Read MoreSQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name
If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website. When you change the physical server name the SharePoint is already connected to the SQL instance…
Read More
SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considered while creating tables or even after that. It seems very easy to apply these constraints but still we have some confusions and problems while implementing it. So I tried to write about these…
Read MoreSQL SERVER – Explanation about Usage of Unique Index and Unique Constraint
I enjoy reading questions from blog readers and answering them. One of the another SQL enthusiastic is Imran who also regularly answer questions of users on this community blog. Recently he has answered in detail about when to use Unique Index and when to use Unique Constraint. Cristiano asked following…
Read More