Post

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.

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 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
SSIS task execution order by Sriharim on 12/10/2017 8:21:05 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 ...

Winners

Winners & Prizes

Ads

Social

Like us on Facebook

Top Authors

Tue, 27-Oct-2020 Authors

semidot

TorbenGade124

All Time Authors

rajnilari2015

SheoNarayan

vishalneeraj-24503

Latest members | More ...

(Statistics delayed by 5 minutes)

Advertisements