Articles (2387) - Page 1

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

2387 records found.
 
Neerajprasadsharma
Why the Clustered Index should be Unique In SQL Server Updated
Last updated on: 20 Jun 2017 08:10:18 PM by Neerajprasadsharma | Views: 155 | Category: Sql Server |
This article is a small part of the big series i started with my very first article on create primary key in SQL Server followed by question answer series on the primary key and then and explaining all the point of the answer in detail with internal structure.
Neerajprasadsharma
Why Clustered Index (Primary Key) key Should be as Narrow as possible 
Last updated on: 14 Jun 2017 09:14:36 PM by Neerajprasadsharma | Views: 225 | Category: Sql Server |
In this article we will learn why a Clustered Index should be as narrow as possible.
Neerajprasadsharma
Introduction To SET STATISTICS IO On SQL Server With Examples 
Last updated on: 05 Jun 2017 12:37:43 PM by Neerajprasadsharma | Views: 326 | Category: Sql Server |
Votes: 2 | Rating: 5 out of 5
You might already seen plenty of articles on the same topic, but today we will see all this with simple explational and an example to understand what actually the SET STATISTICS IO ON tells us?
Neerajprasadsharma
SQL Server Index Internals with Example | Indexes In SQL Server 
Last updated on: 31 May 2017 08:51:35 PM by Neerajprasadsharma | Views: 695 | Category: Sql Server |
In this article we will learn the internals of indexes and fragmentation
Amatya
Top Sql Server Interview questions and their answers with examples (Part 3) 
Last updated on: 26 May 2017 02:56:40 AM by Amatya | Views: 745 | Category: Sql Server |
Hi friends, Here we will look into various Interview questions which are common and frequently asked in Interviews. Hope it benefits for freshers and experienced.
Amatya
Some SQL queries which should be practiced before going to Interview - Part 2 
Last updated on: 26 May 2017 02:13:35 AM by Amatya | Views: 745 | Category: Sql Server |
Some SQL Server queries which you should prepare before going to your interview. Basically while going to C#, ASP .Net interview SQL Server interview is common. So be prepare for SQL server queries.
Amatya
Top Sql Server Interview Questions and their answer with examples (Part 3) 
Last updated on: 23 May 2017 12:13:29 AM by Amatya | Views: 474 | Category: Interview Questions |
Hi friends, Here we will look into various Interview questions which are common and frequently asked in Interviews. Hope it benefits for freshers.
  • Amatya
    Top Interviews Question and their answer with examples (Part 2) 
    Last updated on: 22 May 2017 12:39:03 AM by Amatya | Views: 303 | Category: Interview Questions |
    Hi friends, here we will look into an article for Interviews question which are common and frequently asked in Interviews. I will recommend to read my previous article 'Top Interviews Question and their answer with examples (Part 1)'. Hope it benefits freshers.
    Amatya
    Why team leaders, senior developers advises comments in C# 
    Last updated on: 22 May 2017 12:06:26 AM by Amatya | Views: 166 | Category: Best Practices |
    Comments in coding plays a vital role when we work in a team or individual. Here in this article we will get to know why to use comments while coding and how its help us.
    Amatya
    Top Interviews Question and their answer with examples (Part 1) 
    Last updated on: 20 May 2017 01:40:16 AM by Amatya | Views: 431 | Category: Interview Questions |
    Hi friends, Here we will look into various Interviews question which are common and frequently asked in Interviews. Hope it benefits for freshers.
    Amatya
    Difference between Class and Structure 
    Last updated on: 20 May 2017 01:16:41 AM by Amatya | Views: 332 | Category: C# |
    Here we will try to understand difference between class and structure, as its very important to know the concept.When developer are experienced its important to think that for specific task we should make a class or structure. So here they can know the difference and can go through class or structure as per their need.
    Amatya
    Do and Donts in Interview 
    Last updated on: 20 May 2017 12:33:50 AM by Amatya | Views: 2663 | Category: Interview Questions |
    Here in this article I'm going to say few things that we should do and not to do in the interview.Hope it will be useful for the friends to get their mind makeup about the interview process. Its all about basic facts that you should practise from the day when you start for your professional career.
    Amatya
    Some basic SQL queries which should be practiced before going to Interview - Part 1 
    Last updated on: 19 May 2017 05:15:51 AM by Amatya | Views: 361 | Category: Sql Server |
    Some SQL Server queries which you should prepare before going to your interview. Basically while going to C#, ASP .Net interview SQL Server interview is common. So be prepare for SQL server queries.
    Neerajprasadsharma
    Beginners Guide: Foreign Key in SQL Server 
    Last updated on: 13 May 2017 07:11:15 AM by Neerajprasadsharma | Views: 540 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    Learn what is foreign key in SQL Server, what is the need to have a foreign key and how to create it
    Neerajprasadsharma
    Beginners Guide: Group By In SQL Server 
    Last updated on: 11 May 2017 01:12:40 PM by Neerajprasadsharma | Views: 358 | Category: Sql Server |
    Learn the basics about group by and aggregate functions in SQL Server