Download
100% FREE
Office Document APIs for .NET
Online: 999
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home >
Post
An Article
An Interview Question
A Forum Post
A Career Advice Question
A Video
A Code
A Job
A Product Catalog
An Interview Experience
A Bookmark
A News
Posts from different categories of different sections at one place
You can also select category below to view posts from different sections at one place.
Select Category
> Sql Server
ALL
.NET Certifications
.NET Core
.NET Framework
ADO.NET
Android
Angular
AngularJS 1x
Aptitute Test
ASP.NET
ASP.NET AJAX
ASP.NET Core
ASP.NET MVC
ASP.NET Web API
Aurelia
Azure
Best Practices
BizTalk Server
Bootstrap
C#
Cloud
CMS
CSS 3
Data Structures & Algorithms
Design Pattern & Practices
DotNetFunda.Com
Entity Framework
Error and Solution
F#
Function Points (FPA)
HR
HTML 5
IIS
Interview Questions
JavaScript
jQuery
Kinect
LightSwitch
LINQ
Management
Mobile Development
MSBI (SSIS, SSRS, SSAS)
Mule
Networking
News and Community
Node.js
NoSql
OOPS
Oracle
Others
PostgreSQL
PowerShell
Product Reviews
Project Management
Python
QA (Testing)
R Language
Regular Expressions
SEO
SharePoint
SignalR
Silverlight
Sql Server
TypeScript
UML
VB.NET
Visual Studio
WCF
Web Analytics
Web Services, Remoting
Windows 8
Windows Forms
Windows Metro
Windows Phone
WPF
WWF
XML
Articles
Interviews
Forums
Videos
Codes
Bookmarks
How to Configure SQL server Database mail and send mail using SQL Database Mail
by Sandeepraturi on 2/24/2018 2:32:33 AM
Use of PIVOT in SQL
by Sandeepraturi on 2/21/2018 12:04:39 AM
SQL full database BACKUP through SQL SCRIPT
by Sandeepraturi on 2/18/2018 4:44:41 AM
Tips: Why we should have Ever Incresing Primary Key / Clustered Index
by Neerajprasadsharma on 2/8/2018 12:03:35 AM
Why Primary Key/Clustered Index should be static in SQL Server
by Neerajprasadsharma on 9/19/2017 10:15:09 PM
Difference Between Rebuild and Reorganize Index in SQL Server| Fill Factor| Fragmentation in SQL Server Part 3
by Neerajprasadsharma on 8/21/2017 8:27:41 PM
SQL Server Fragmentation| Internal And External Fragmentation Part 2
by Neerajprasadsharma on 8/3/2017 12:40:13 PM
Fragmentation in SQL Server| Internal and External Fragmentation
by Neerajprasadsharma on 7/4/2017 10:17:34 PM
Why the Clustered Index should be Unique In SQL Server
by Neerajprasadsharma on 6/19/2017 10:45:44 PM
Why Clustered Index (Primary Key) key Should be as Narrow as possible
by Neerajprasadsharma on 6/12/2017 9:31:53 PM
Introduction To SET STATISTICS IO On SQL Server With Examples
by Neerajprasadsharma on 6/5/2017 12:37:43 PM
SQL Server Index Internals with Example | Indexes In SQL Server
by Neerajprasadsharma on 5/28/2017 4:37:53 AM
Top Sql Server Interview questions and their answers with examples (Part 3)
by Amatya on 5/26/2017 2:56:40 AM
Some SQL queries which should be practiced before going to Interview - Part 2
by Amatya on 5/26/2017 2:13:35 AM
Some basic SQL queries which should be practiced before going to Interview - Part 1
by Amatya on 5/19/2017 5:12:11 AM
Beginners Guide: Foreign Key in SQL Server
by Neerajprasadsharma on 5/13/2017 7:11:15 AM
Beginners Guide: Group By In SQL Server
by Neerajprasadsharma on 5/11/2017 1:12:40 PM
Beginners guide: How to Sort Results In SQL Server
by Neerajprasadsharma on 5/10/2017 1:12:39 PM
Beginners guide: How to use And & OR Operator in SQL Server
by Neerajprasadsharma on 5/9/2017 2:12:40 PM
How to create Auto Increment table in SQL Server
by Neerajprasadsharma on 5/7/2017 3:17:48 PM
More ...
What is the default extended event session to capture Deadlocks?
by Bandi on 8/31/2017 6:36:33 AM
What is the best alternate for SQL Profiler as it is being deprecated in future releases?
by Bandi on 8/31/2017 6:34:17 AM
can we drop versioning enabled tables (Temporal table)? DROP TABLE dbo.TableName
by Bandi on 8/31/2017 6:31:22 AM
Can we mark an existing table as Temporal table?
by Bandi on 8/31/2017 6:19:32 AM
Can we TRUNCATE a Temporal Table?
by Bandi on 8/31/2017 6:09:04 AM
Can we update DATETIME2 columns that are defined as GENERATED ALWAYS ON in Temporal Table?
by Bandi on 8/31/2017 6:06:43 AM
What happens if you define DATETIME2 columns as Nullable in Temporal table ? CREATE TABLE Employee ( [EmployeeID] int NOT NULL PRIMARY KEY CLUSTERED , [Name] nvarchar(100) NOT NULL , [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START NULL , [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END , PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo) ) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.EmployeeHistory));
by Bandi on 8/31/2017 5:56:57 AM
which of the following clause is used to define DATETIME2 columns in Temporal Table?
by Bandi on 8/31/2017 5:51:59 AM
what are the columns to be defined for Temporal Table?
by Bandi on 8/31/2017 5:49:21 AM
can we create Temporal Table with out Primary Key column?
by Bandi on 8/31/2017 5:43:02 AM
which options makes a SQL table as temporal table in SQL Server 2016?
by Bandi on 8/31/2017 5:35:14 AM
which of the following SQL statement is used to remove a log file called logfile1 from a database called DB1?
by Bandi on 8/29/2017 9:31:52 AM
Which of the following tool is used to identify rules and patterns in the company data and determine why things happen and predict what will happen in the future?
by Bandi on 8/29/2017 9:21:11 AM
what is the alternate option to maintain log/history tables in SQL Server 2016?
by Bandi on 8/29/2017 8:28:46 AM
which of the following clause is used to return SQL resultset in JSON format in SQL Server2016?
by Bandi on 8/29/2017 8:25:36 AM
which inbuilt function can be used to know the id value of the last row that was inserted, rather than re-run another query just to get the maximum id value ?
by Bandi on 8/29/2017 7:42:36 AM
The table includes a DATETIME column named EventTime that stores the date and time of each Event. There is a non-clustered index on the EventTime column. To create a report that displays the total number of events happened on the current day, You need to write a query that will return the correct results in the most efficient manner. Which T-SQL query should you use?
by Bandi on 8/29/2017 7:28:00 AM
Here is the JSON string DECLARE @jsonInfo VARCHAR(MAX) SET @jsonInfo = N'{ "info":{ "type":1, "address":{ "town":"Hyd", "state":"TS" "country": "India" }, "tags":["sport", "Water Polo"] }, "type":"Basic" }' what is the output of below query ? JSON_QUERY(jsonString, '$.info.address.town')
by Bandi on 8/29/2017 7:22:34 AM
What is wrong with the below T-SQL batch statement ? @find varchar(30); SET @find = 'ABC'; SELECT LastName FROM Person WHERE LastName = @find;
by Bandi on 8/29/2017 7:06:38 AM
The id_num column of the below table is an auto increment column but what do the 2 numbers after the IDENTITY clause mean? CREATE TABLE new_employees ( id_num int IDENTITY(100,10), fname varchar (20), minit char(1), lname varchar(30) )
by Bandi on 8/29/2017 6:12:03 AM
More ...
How to create table in Entity Framework
by Ishan7 on 12/10/2020 11:47:56 PM
How to List particular Records in sql server
by Jayakumars on 11/28/2019 6:11:12 AM
How to Update Dynamic File
by Jayakumars on 9/19/2019 12:37:53 AM
How to Update this Situation for SQL SERVER
by Jayakumars on 8/6/2019 3:43:37 AM
How to Find count Details Sql server
by Jayakumars on 1/25/2019 1:49:32 AM
sql server dba interview questions
by Sudheep.Grandhe on 11/29/2018 3:22:42 AM
how can i optimize query
by Santosh4u on 9/26/2018 4:45:36 AM
query data based on time column but display data id wise
by Sriharim on 8/5/2018 4:12:47 PM
How to Shows output this
by Jayakumars on 8/3/2018 3:38:25 AM
How to count and Duplicate in sql server
by Jayakumars on 8/2/2018 5:35:54 AM
Multiple column pivot in sql server
by Kirthiga on 5/31/2018 8:04:32 AM
Query to find Last day of the current month
by Kirthiga on 5/23/2018 1:24:00 AM
How to add individual number in a Cell using sql
by Kirthiga on 5/22/2018 7:44:03 AM
How to Resolve in this error for Sql server 2017
by Jayakumars on 5/3/2018 8:30:25 AM
Cannot create primary key Serial to table have existing data .
by Ahmedsa on 1/27/2018 8:54:00 AM
How to Update following Data
by Jayakumars on 1/18/2018 1:16:34 AM
to write a query without getting duplicates from two tables ?
by Chamu on 12/28/2017 6:11:34 AM
B left join A is same as A right join B.now my question is why should i use right join ?in sql serv
by Chamu on 12/27/2017 1:55:46 AM
B left join A is same as A right join B.now my question is what is the importance of right join?
by Chamu on 12/27/2017 1:43:30 AM
where to use cross join ?and example?
by Chamu on 12/27/2017 12:34:11 AM
More ...
Learn SQL basics step by step.
by Questpond on 12/18/2018 3:44:42 AM
Database Normalization beginners tutorial.
by Questpond on 9/24/2018 12:37:01 AM
Explain Columnstore index in SQL Server.
by Questpond on 9/8/2017 2:52:09 AM
Learn SQL Server step by step tutorial - Part 1 ( Beginner series)
by Questpond on 12/10/2016 7:31:26 AM
Learn MSBI ( Microsoft Business Intelligence ) in 4 days ( SSIS , SSAS and SSRS)
by Questpond on 5/16/2015 6:14:30 AM
MSBI Demo Class
by Kapilbisp on 7/18/2014 4:37:31 AM
Differences between ISNULL and NULLIF - sql server interview questions
by Sqldev on 12/12/2013 9:52:47 AM
Differences between primary key and unique key - SQL Server Interview Questions
by Sqldev on 11/28/2013 11:47:28 AM
SSIS Lesson 3 - Extra data from a sql server table into a Flat file using SSIS import and Export wizard
by Sqldev on 10/4/2013 10:44:39 AM
SQL Server interview question :- Find the second highest salary ?
by Questpond on 4/1/2013 12:21:01 AM
SSIS Tutorial 2 - Load data from excel file into sql server table
by Sqldev on 10/4/2013 10:50:19 AM
SSIS tutorial 1 - Introduction to SSIS
by Sqldev on 10/4/2013 10:49:25 AM
CTE in SQL SERVER
by Sqldev on 10/4/2013 10:48:43 AM
SQL Server training :- How to implement Pivot?
by Questpond on 3/1/2013 3:32:06 AM
SQL SERVER interview question - What are the different System databases in sql server ??
by Sqldev on 2/24/2013 10:23:57 AM
SQL Server Error Message Resolution -- Could not obtain exclusive lock on database 'model'.
by Sqldev on 10/4/2013 10:47:29 AM
SQL Server interview questions/training: - What is page split?
by Questpond on 11/9/2012 5:48:59 AM
SQL Server interview question: - Difference between UNION and UNION All?
by Questpond on 4/13/2012 9:56:32 AM
What is SSIS , SSAS and SSRS ( part 2) with sample demo?
by Questpond on 2/25/2012 12:48:56 AM
What is SSIS , SSAS and SSRS ( part 1) with sample demo?
by Questpond on 2/23/2012 12:39:00 AM
More ...
Sort DateTime format for string literal
by Rajnilari2015 on 7/7/2018 7:09:10 AM
Convert String to Datetime format
by Rajnilari2015 on 7/7/2018 7:03:02 AM
Auto Generate Alpha numeric ID in SQL server
by Kirthiga on 5/22/2018 6:50:55 AM
SQL query to get day of the week in tamil font
by Kirthiga on 5/22/2018 6:29:20 AM
How to know complete SQL SERVER VERSION & Edition details via SQL query
by Sandeepraturi on 2/20/2018 6:44:30 AM
SQL full database BACKUP through SQL SCRIPT
by Sandeepraturi on 2/18/2018 4:01:26 AM
Named Pipes Provider, error 40 Microsoft SQL server when unable to connect
by Self-Innovator on 11/29/2017 7:16:50 AM
SQL Server query to display all student name in one cell seperated by ','
by Amatya on 9/26/2017 3:42:47 AM
SQL Server query to print first letter of a Name in Upper Case and all other letter in Lower Case.
by Amatya on 9/26/2017 3:37:34 AM
Tricky SQL Server, developer should know
by Amatya on 9/26/2017 2:47:10 AM
SQL Server query to calculate number of A in string
by Amatya on 9/26/2017 2:11:11 AM
SQL query to create a clone of existing table without using Create Command.
by Amatya on 9/26/2017 2:05:23 AM
How to fetch random record form a tblDNFRec
by Amatya on 9/26/2017 12:58:08 AM
Sql Server query to get database date and UTC Date
by Amatya on 9/26/2017 12:39:59 AM
Get student details from [B]tblDNFRec[/B] table whose joining month is "January".
by Amatya on 9/26/2017 12:36:13 AM
Get joining year, joining month and joining date from tblDNFRec table.
by Amatya on 9/26/2017 12:34:01 AM
Get firstname from tblDNFRec not starting with single character between a-m.
by Amatya on 9/26/2017 12:29:48 AM
Get DBCC IND command output into a table
by Neerajprasadsharma on 6/29/2017 9:02:02 PM
Create a dummy table from number table-SCRIPT
by Neerajprasadsharma on 6/3/2017 11:31:55 PM
Create Number Table in SQL Server
by Neerajprasadsharma on 5/28/2017 2:39:37 AM
More ...
List of Top Server India For 2019
by Nishuyadav on 3/12/2019 9:48:44 AM
Top Sql Server
by Elwincarter on 2/2/2018 11:51:11 AM
Questions
by Lindachaney on 2/2/2018 8:55:22 AM
Difference Between Rebuild and Reorganize Index in SQL Server| Fill Factor| Fragmentation in SQL Server Part 2
by Lindachaney on 2/2/2018 8:52:52 AM
Difference Between Rebuild and Reorganize Index in SQL Server| Fill Factor| Fragmentation in SQL Server Part 3
by Lindachaney on 2/2/2018 8:52:25 AM
Why Primary Key/Clustered Index should be static in SQL Server
by Lindachaney on 2/2/2018 8:51:58 AM
Why Primary Key/Clustered Index should be static in SQL Server
by Elwincarter on 1/30/2018 9:43:27 AM
primary-keyclustered-index-should-be-static-in-sql-server
by Sriharim on 12/13/2017 3:31:13 PM
Clone Table solution
by Aruntuteja on 9/28/2017 4:25:52 AM
Test
by Rammanoharj99 on 8/28/2017 12:42:29 PM
by Sriharim on 10/29/2015 12:05:19 PM
by Sriharim on 8/27/2015 10:29:33 AM
ssrs-demo-using-stored-procedure-with-parameters
by rajeshgajra19889-26855 on 9/19/2014 1:30:21 PM
Search string in all column
by rajeshgajra19889-26855 on 7/15/2014 10:06:53 AM
SQL Server Integration Services (SSIS) – Part 2 – Transforming SQL Data to Excel Sheet
by Rabbil on 8/23/2013 2:22:12 AM
Find the Factorial of number(s) in SQL Server
by Rabbil on 5/21/2013 12:34:00 AM
Tricks to speed up your SQL query
by Ankit_Parmar555 on 8/16/2012 5:55:18 AM
SQL Server 2012 feature supported by editions
by Sheonarayan on 7/5/2013 5:22:17 PM
SQL Server Integration Services (SSIS) - Part 2 - Transforming SQL Data to Excel Sheet
by Faceoff on 5/30/2012 10:09:01 AM
SQL Server Integration Services (SSIS) - Part 1 - Basics of SSIS and Creating Package
by Faceoff on 5/30/2012 10:01:16 AM
More ...