After you read this article, you will find out: Free Online Resume Builder Comparison Table.Top 5 Free Online Resume Makers.The Most Favorite Free Online Resume Maker for Other People.Related Useful Resume Resources. Is There any Good Free Online Resume Maker? Are you looking for a good free online resume maker which can help you to write a winning resume? This page is right for you, if the answer is yes. There are many online resume creator...
Introduction In my earlier article we have discussed about the SQL Server schema comparison tool in Visual Studio 2010 http://www.dotnetfunda.com/articles/article1121-sql-server-schema-comparison-tool-in-visual-studio-2010-.aspx. Today in this article I’m going to explain yet another new tool in Visual Studio 2010 which is nothing but the DATA COMPARISON tool. This tool is of extreme use for the developers to compare data in 2 tables in different...
SQL SERVER – Index Created on View not Used Often – Limitation of the View 12: "I have previously written on the subject SQL SERVER – The Limitations of the Views – Eleven and more…. This was indeed a very popular series and I had received lots of feedback on that topic. Today we are going to discuss something very interesting as well.During my recent performance tuning seminar in Hyderabad, I presented on the subject of Views. During the seminar,...
SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber: "I strongly favor ORDER BY ColumnName.I read one of the blog post where blogger compared the performance of the two SELECT statement and come to conclusion that ColumnNumber has no harm to use it. Let us understand the point made by first that there is no performance difference.Run following two scripts together:USE AdventureWorksGO-- ColumnName (Recommended)SELECT *FROM HumanResources.DepartmentORDER...
I'm always looking for ways to save time. Suppose I want to attach some files to an email, and I already have a folder open containing those files.
I used to have to click "Attach a file," find the photos, click them, etc. Starting today, if I'm using Google Chrome or Mozilla Firefox 3.6, I can just drag and drop the files to attach them — easy as pie.
We'll enable this for other browsers as soon as they support this feature. For...
What are the properties of the Relational tables?
Relational tables have six properties: Values are atomic.
Column values are of the same kind.
Each row is unique.
The sequence of columns is insignificant.
The sequence of rows is insignificant.
Each column must have a unique name.
What is De-normalization?
De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It is sometimes necessary because current DBMSs implement the relational model poorly. A true relational DBMS would allow...
What command do we use to rename a db?
sp_renamedb ‘oldname’ , ‘newname’
If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. Use sp_dboptions to bring database to multi user mode.What is sp_configure commands and set commands?
Use sp_configure to display or change server-level settings. To change database-level settings, use ALTER DATABASE. To change settings that affect only the current user session, use the SET statement.What are the different...
