-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Help on SQL Server

Devendra Kumar Thakur has a Master's Degree in Computer Applications from Jabalpur Engineering College, and has worked as a Lead Consultant with companies such as Siemens, Accenture, and his current employer, ITC. The majority of his experience is with SQL Server, SSRS, and Crystal report as a developer, however he is now trying to learn SSAS.

SQL Server Free eBooks, Softwares, Tutorials and Websites

When we start working as developer or learning, we often face this issue. Where is the best tutorials, books and other learning material? Sure, google can help you but it is difficult to keep track of all the information provided by the google. While working for more than 7 year,…

Read more

0 comments, 54 reads

Posted in Help on SQL Server on 10 April 2017

Alter Datatype of All the Columns In Database

Requirement: Recently we got the information from management that our project will be getting the customers from China, so our application should support the Unicode characters. Now we support only English language, to support all the languages we decided to change all the char, varchar and text datatypes to nchar,…

Read more

0 comments, 40 reads

Posted in Help on SQL Server on 28 March 2017

SQL Server Tips and Tricks

In this article I will be listing the tips and tricks to work like a Pro.  So let's get started – Important keyboard shortcuts for Sql Server Management Studio. CTRL+N – Opens new query window CTRL+SHIFT+N – Open pop window to create new project CTRL+SHIFT+TAB – Cycle through the previous…

Read more

0 comments, 39 reads

Posted in Help on SQL Server on 20 February 2017

Part 2 - Detecting and Monitoring Memory Pressure Using DMV

I will be writing this article in four parts because this topic is huge and the amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step. 1.                    DBCC MemoryStatus 2.                    Using DMV 3.                  

Read more

0 comments, 406 reads

Posted in Help on SQL Server on 6 February 2017

Altering Data Length of a Primary Key Column

This is not an article or a script. I am posting this just to share my experience and I feel it can save a lot of time in a specific situation. Problem – We have a table let’s say Customer and this table has an alpha numeric primary key CustomerID…

Read more

0 comments, 550 reads

Posted in Help on SQL Server on 30 January 2017

SQL Server - Monitoring Table Size

There are many situations when we want to know the size of our database tables or just need a list of largest tables. The simplest way to get these details is use SQL Server Standard Report. Please refer the below screen shots to generate Standard report.This Report provides the fair…

Read more

0 comments, 537 reads

Posted in Help on SQL Server on 19 January 2017

Special Index - XML Index

I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will cover following Index – 1. XML Index 2. Full Text Index 3. Spatial Index 4. Columnstore Index Prerequisites 1. If you are reading this article, I am assuming that you…

Read more

0 comments, 384 reads

Posted in Help on SQL Server on 11 November 2016

Mastering Index – Index on Computed Columns

This article is the part of series Mastering Index, in this particular article we will be exploring Index on computed columns. Take a look at the content of this series –  Mastering Index – Introduction One of the most interesting and talked about topic in database field is Index. I…

Read more

0 comments, 388 reads

Posted in Help on SQL Server on 7 November 2016

Mastering Index – Index with included columns

This article is the part of series Mastering Index, in this particular article we will be exploring Index with included columns. Take a look at the content of this series – Mastering Index – Index with included columns One of the most interesting and talked about topic in database field…

Read more

0 comments, 313 reads

Posted in Help on SQL Server on 18 October 2016

Mastering Index – Unique Index

This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a look at the content of this series -  Mastering Index  One of the most interesting and talked about topic in database field is Index. I am writing this Series…

Read more

0 comments, 352 reads

Posted in Help on SQL Server on 14 October 2016

Mastering Index – Nonclustered Index

This article is the part of series Mastering Index, in this particular article we will be exploring Nonclustered Index. Take a look at the content of this series -  One of the most interesting and talked about topic in database field is Index. I am writing this Series of article…

Read more

0 comments, 313 reads

Posted in Help on SQL Server on 10 October 2016

Mastering Index – Clustered Index

This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take a look at the content of this series -  One of the most interesting and talked about topic in database field is Index. I am writing this Series of article…

Read more

0 comments, 360 reads

Posted in Help on SQL Server on 3 October 2016

Mastering Index – Introduction

One of the most interesting and talked about topic in database field is Index. I am writing this Series of article to cover all the different types of index available in SQL Server. I will be writing this series in two categories Index and Special Index. Please find the List…

Read more

0 comments, 524 reads

Posted in Help on SQL Server on 29 September 2016

Part 1 - Detecting and Monitoring Memory Pressure

I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step. 1.                    DBCC MemoryStatus 2.                    Using DMV 3.                  

Read more

0 comments, 366 reads

Posted in Help on SQL Server on 27 September 2016

Order by Month Number and Show Month Name

This may feel very simple to many developers and yes it is, but I saw this request somewhere in community website.So thought of creating a very simple example.  Here I am using AdventureWorks2014 database, we have table [AdventureWorks2014].[HumanResources].[Employee] and we will use [HireDate] column. I am adding two new columns…

Read more

0 comments, 786 reads

Posted in Help on SQL Server on 24 September 2016

Mastering Index - Filtered Index

Mastering Index - Filtered Index This article is the part of series Mastering Index, in this particular article we will be exploring Filtered Index. Take a look at the content of this series –  Mastering Index – Introduction One of the most interesting and talked about topic in database field…

Read more

0 comments, 460 reads

Posted in Help on SQL Server on 23 September 2016

Learn Basic SQL in 30 minutes

This article is for those who have no idea about Sql and I will be giving them a start point from there they can build their knowledge base.  Since in this article time is key,  so I will be using images as many as possible and fewer words because as…

Read more

0 comments, 310 reads

Posted in Help on SQL Server on 21 September 2016

Books VS Internet

It’s is very easy to be confused between investing in books or we should use the power of internet. If you ask my recommendation, I would strongly suggest Books.  Why, let’s take a simple example. Suppose you want to watch a great movie let’s say Avatar. Now you have two…

Read more

0 comments, 121 reads

Posted in Help on SQL Server on 19 September 2016

Sql Server - Detecting and Monitoring Memory Pressure

Introduction - Detecting and Monitoring Memory Pressure  I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step.  DBCC MemoryStatus  Using DMV  Alert and perfmon…

Read more

0 comments, 237 reads

Posted in Help on SQL Server on 15 September 2016

Interview Questions for Companies

In this article I will be posting interview questions by companies. Whenever I am facing any interview or someone shares the question , I will be adding here.  Sutherland Hyderabad  Telephonic Round Q.  What is cursor in SQL Server? Q. Tell me the Difference between Replace and Coalesce functions with…

Read more

0 comments, 173 reads

Posted in Help on SQL Server on 13 September 2016

Older posts