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

2396 records found.
 
Sandeepraturi
SQL full database BACKUP through SQL SCRIPT Updated
Last updated on: 20 Feb 2018 01:35:45 AM by Sandeepraturi | Views: 95 | Category: Sql Server |
This article explains how we can take SQL database backup through SQL Scripts.
Sandeepraturi
Paypal Integration Updated
Last updated on: 19 Feb 2018 11:50:02 PM by Sandeepraturi | Views: 5285 | Category: ASP.NET |
Paypal integration using Asp.net & how will Add or Update product details.
Neerajprasadsharma
Tips: Why we should have Ever Incresing Primary Key / Clustered Index 
Last updated on: 08 Feb 2018 12:03:35 AM by Neerajprasadsharma | Views: 382 | Category: Sql Server |
In this we will learn the importance of ever increasing clustered index / primary key in SQL Server.
Amatya
Visual studio shortcuts 
Last updated on: 12 Jan 2018 03:46:08 AM by Amatya | Views: 986 | Category: Visual Studio |
Votes: 1 | Rating: 5 out of 5
Hi, here we will learn some visual Studio short keys and tips which will be helpful for developers, tester, tech lead etc. Every developer who uses Visual studio should know or familiar with the shortcut which Iam going to share here. Hope it will be helpful for freshers and even the experience software developer friends.
Neerajprasadsharma
Why Primary Key/Clustered Index should be static in SQL Server 
Last updated on: 19 Sep 2017 10:15:09 PM by Neerajprasadsharma | Views: 2844 | Category: Sql Server |
Votes: 3 | Rating: 4.67 out of 5
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: 5112 | 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: 2822 | 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: 2465 | 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: 2489 | 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: 2076 | 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: 2032 | 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: 1630 | 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: 2021 | 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: 2418 | 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: 2558 | 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.