Articles (2393) - 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.

2393 records found.
 
Neerajprasadsharma
Why Primary Key/Clustered Index should be static in SQL Server New
Last updated on: 19 Sep 2017 10:15:09 PM by Neerajprasadsharma | Views: 38 | Category: Sql Server |
In this article we will try to find the reason behind why primary key should be static and what problems we can face if the primary key is not static.
Neerajprasadsharma
Difference Between Rebuild and Reorganize Index in SQL Server| Fill Factor| Fragmentation in SQL Server Part 3 
Last updated on: 22 Aug 2017 02:05:06 AM by Neerajprasadsharma | Views: 883 | Category: Sql Server |
This article helps you to understand the difference between Rebuild and Reorganize, how they are different, when to choose Rebuild the Index or Reorganize the Index, what is fill factor and what it does and more importantly we will understand all these things with Demo.
Neerajprasadsharma
SQL Server Fragmentation| Internal And External Fragmentation Part 2 
Last updated on: 03 Aug 2017 11:06:04 PM by Neerajprasadsharma | Views: 705 | Category: Sql Server |
This is the second part on the topic fragmentation in SQL Server, which majorly focus on read problems with fragmentations.
Prabahkar
Implementation of the Common Applications of Word Fields 
Last updated on: 01 Aug 2017 01:55:26 AM by Prabahkar | Views: 782 | Category: C# |
This article demonstrates how to add page numbering, table of content and footnote to Word document by using fields in C#.
Chvrsri
How to Import WPF controls into MFC Application 
Last updated on: 20 Jul 2017 09:27:02 AM by Chvrsri | Views: 859 | Category: WPF |
This article illustrates the importing mechanism of any WPF(C#) controls into the native MFC (C++) application. Many legacy systems will have this requirement to update their old windows 32 controls to Latest WPF controls for enhanced UI design in their legacy systems.
Neerajprasadsharma
Fragmentation in SQL Server| Internal and External Fragmentation 
Last updated on: 08 Jul 2017 09:31:36 PM by Neerajprasadsharma | Views: 1072 | Category: Sql Server |
In this article you will have a clearer understanding about fragmentation in SQL Server, how it occurs, what are the causes and some problem related to it.
Neerajprasadsharma
Why the Clustered Index should be Unique In SQL Server 
Last updated on: 20 Jun 2017 08:10:18 PM by Neerajprasadsharma | Views: 1348 | 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: 1099 | 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: 1175 | 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: 1594 | 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: 1556 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    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: 1294 | 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: 895 | 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: 625 | 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: 435 | 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.