Sql Server Articles (246) - 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.

246 records found.
 
Sandeepraturi
How to Configure SQL server Database mail and send mail using SQL Database Mail 
Last updated on: 26 Feb 2018 10:42:05 AM by Sandeepraturi | Views: 1500 | Category: Sql Server |
Votes: 1 | Rating: 3 out of 5
here, we will learn how we can configured SQL Database Mail in SQL Server and how to send mail using SQL Server.
Sandeepraturi
Use of PIVOT in SQL 
Last updated on: 21 Feb 2018 12:04:39 AM by Sandeepraturi | Views: 1269 | Category: Sql Server |
PIVOT in SQL is very power full technique to transform row level data into column level.
Sandeepraturi
SQL full database BACKUP through SQL SCRIPT 
Last updated on: 20 Feb 2018 01:35:45 AM by Sandeepraturi | Views: 1493 | Category: Sql Server |
This article explains how we can take SQL database backup through SQL Scripts.
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: 1753 | Category: Sql Server |
Votes: 1 | Rating: 4 out of 5
In this we will learn the importance of ever increasing clustered index / primary key in SQL Server.
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: 3891 | Category: Sql Server |
Votes: 4 | Rating: 4.5 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: 8554 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
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: 4322 | Category: Sql Server |
This is the second part on the topic fragmentation in SQL Server, which majorly focus on read problems with fragmentations.
  • Neerajprasadsharma
    Fragmentation in SQL Server| Internal and External Fragmentation 
    Last updated on: 08 Jul 2017 09:31:36 PM by Neerajprasadsharma | Views: 3571 | 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: 2954 | 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: 2182 | 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: 3615 | 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: 4470 | 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: 4878 | 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: 2737 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    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
    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: 1472 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    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.