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

SQLSERVERSdba

I am a MS SQL DBA, born and brought up in Mumbai, India. Done my engineering in Electronics And Telecommunications and have been working in this industry as a DBA for the past 4 years.

In Memory OLTP – 2

Good day everyone , In last post

In Memory OLTP – 1

we saw the what is In Memory OLTP and what are the requirements for that. In This post I will show you the demo of how we get performance gain.

The scripts (demo ) i will be using… Read more

0 comments, 284 reads

Posted in SQLSERVERSdba on 9 December 2016

In Memory OLTP – 1

In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL Server.

Microsoft designed In-Memory OLTP to handle the most demanding OLTP workloads. To accomplish this, In-Memory OLTP introduces two fundamentally new concepts: memory-optimized tables and natively compiled stored procedures.

Data… Read more

1 comments, 343 reads

Posted in SQLSERVERSdba on 6 December 2016

How to identify the source of page splits in a database

Page splits can slow down your queries and increase the amount of I/O needed to retrieve your data.

So, how do you monitor and identify the source of page splits, so you can avoid them in your databases?

The short answer is that you can monitor page splits with extended…

Read more

2 comments, 629 reads

Posted in SQLSERVERSdba on 13 November 2015

New Series 2 at a Time

Hi all

i have posted quite a few blogs till now, all of them were individual post except  a short series on New Features of SQL 2016 (Which can be found here  and here ). So i have decided to post a series and that too not one but 2… Read more

0 comments, 273 reads

Posted in SQLSERVERSdba on 6 November 2015

How to find blocked processes

Blocked processes are often a big problem for DBAs, because they’re difficult to monitor. We receive desperate calls saying “Everything is slow!” but before we can do anything a second call arrives saying, “Don’t worry, everything’s OK again!”

Most of the time, this happens because a badly-behaved process blocks other… Read more

7 comments, 5,818 reads

Posted in SQLSERVERSdba on 30 October 2015

Untrusted Check Constraints

Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can use them to avoid looking for values that couldn’t possibly be there.

For example, imagine a listprice field with a constraint that keeps the field value over $100. If a… Read more

1 comments, 477 reads

Posted in SQLSERVERSdba on 9 October 2015

SQL Server’s statistics

Again another interesting article from RED GATE …

SQL Server’s statistics provide the query optimizer with the information it needs to retrieve table data as efficiently as possible. If the statistics aren’t correct, query performance will be unnecessarily slow.

So how do you check if your statistics are up to… Read more

0 comments, 662 reads

Posted in SQLSERVERSdba on 14 September 2015

Live Query Statistics

The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option is very useful in troubleshooting and performance tuning because it helps to pinpoint the problematic area in a query by providing detailed information.

We need to Include Actual Execution… Read more

0 comments, 1,823 reads

Posted in SQLSERVERSdba on 19 August 2015

How to find CPU intensive queries ?

HI all

Today received the mail from RED-GATE team on this topic “How to find CPU intensive queries” . It  is an interesting article and with good focus on DMV  and its use to find out expensive query . hence I  thought to share it .

High CPU usage is… Read more

5 comments, 5,096 reads

Posted in SQLSERVERSdba on 17 August 2015

List Out All the SQL servers In domain

HI ALL

In One Of the Group the question was asked that How to list all the Servers in which SQL is installed?

It is genuine query. There are many scenario when you need to Find out how much SQL servers are there in the domain ? many a times… Read more

0 comments, 6,774 reads

Posted in SQLSERVERSdba on 30 July 2015

SQL server 2016 CTP 2.2

Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are now available for download!

This first look at SQL Server 2016 Upgrade Advisor showcases a new platform for the database upgrade tool.  upgrade advisor  also introduces the Stretch Database… Read more

0 comments, 924 reads

Posted in SQLSERVERSdba on 23 July 2015

COLUMNSTORE INDEX… DEMO

COLUMNSTORE INDEX

How data is stored in traditional way

For physical storage of a table, its rows are divided into a series of partitions (numbered 1 to n). The partition size is user defined; by default all rows are in a single partition. A table is split into multiple partitions… Read more

0 comments, 1,710 reads

Posted in SQLSERVERSdba on 11 July 2015

How to Grant limited permissions to create views in another schema?

How to Grant limited permissions to create views in another schema?

In SQL Server 2005 and 2008R2 you can grant permissions at the schema level and, in fact, this is what you’ll need to do to give them the ability to create the views. 


This script below creates an example… Read more

2 comments, 1,773 reads

Posted in SQLSERVERSdba on 1 July 2015

SQL SERVER REPORTING SERVICE MIGRATION

Last week as part of job I had to migrate the Databases and Reporting Service of SQL server 2005 To SQL server 2014 . many of You Already know how to the migration of databases from sql server 2005 to sql server 2014. For better idea read my pervious post… Read more

4 comments, 2,754 reads

Posted in SQLSERVERSdba on 11 June 2015

SQL Server 2016 features to look for -2

In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion about  ALWAYS ENCRYPTED Feature. You can Find That Post Here .

SQL Server 2016 features to look for -1

Now In The Today’s Post we will have look on 2… Read more

1 comments, 4,748 reads

Posted in SQLSERVERSdba on 8 June 2015

SQL Server 2016 features to look for -1

At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously referred to as SQL Server vNext, will officially be SQL Server 2016.

You can download the trial so called evaluation version of MS SQL 2016  Here . try It  your… Read more

2 comments, 959 reads

Posted in SQLSERVERSdba on 3 June 2015

SQL server 2014 Service Pack is available (AGAIN ) !!!!!!!!

Yes after its initial release and  pull out Microsoft  has again made the Service pack 1 for SQL SERVER 2014  available for download.

They have release this (again) exactly after one year from the product launch i.e. on 15th May

enjoy the download at

https://support.microsoft.com/en-us/kb/3058865


Read more

0 comments, 346 reads

Posted in SQLSERVERSdba on 20 May 2015

Editing Table Rows in SQL

When you create a database driven website, you actually write SQL scripts to insert data into the database. You also use SQL scripts to read data, update data, and delete data. These SQL scripts can be placed directly into your website code (PHP, ColdFusion etc), or they can be stored… Read more

0 comments, 385 reads

Posted in SQLSERVERSdba on 10 May 2015

SQL SERVER Interview Questions

All you who wants to pursue professional life as  SQL SERVER DBA, its always hard to crack the interview . But here is a question bank which might come useful.

The questions are useful. But answers may not be as descriptive  but good enough to get a nod from interviewer Read more

0 comments, 812 reads

Posted in SQLSERVERSdba on 8 May 2015

SQL Server Migration Plan

As a DBA , migration  of database is a part of  day to day activities. sometime its a quite hectic task if we don’t have a proper  guidelines or checklist.

here is something useful.

SQL Server Migration Plan

 The migration plan would be executed in 3 phases.

  1. Pre-migration checks
  2. Actual…

Read more

3 comments, 8,006 reads

Posted in SQLSERVERSdba on 5 May 2015

Older posts