Archive

Archive for the ‘INDEXES’ Category

SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison

August 10, 2013 Leave a comment

Difference Between Union vs. Union All
Great Post by Pinal Dave ..
Enjoy 🙂

Advertisements
Categories: INDEXES

Book Review – DBA Survivor: Become a Rock Star DBA

July 22, 2013 Leave a comment

Hi there,Review_book

check out Garland MacNeill’s review of Thomas LaRock’s

new book called “DBA Survivor” … which targets all aspects of

DBA’s duties …and  Thomas own journey as a DBA ….

should be on your MUST READ list for the year …as its on mine !!!!!!! 🙂

http://www.nyteshades.com/dba-survivor-become-a-rock-star-dba/

Thomas LaRock’s link

http://thomaslarock.com/

Categories: INDEXES

corrupt allocation pages

July 9, 2013 Leave a comment

Hi There ,

                its heck of a pain to restore ,recover or do page level restore allocation pages and you have no other option other then doing a clean restore of your database ..

              some people can do a HEX editing on the file ,but that’s not recommenced

             for more info Check out DAVIS site .. and his 30 day series on Disaster and recovery

        http://www.sqlsoldier.com/wp/sqlserver/day6of31daysofdisasterrecoverydealingwithcorruptioninallocationpages# 

          Enjoy 🙂

 

Installing SQL Server 2014 CTP1 – Step by Step

June 30, 2013 Leave a comment

Getting Started 2014 CTP1 ..

SQLSailor

Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your fresh copy from here.

SQL2014Install16

Here is the official announcement with some high level details.

In this post we will do a quick step by step walk through of the whole install process and see if there are any changes from the prior installs.

* Note  – The below point from the download page should be noted

Microsoft SQL Server 2014 CTP1 is pre-release software and should be installed only on a clean machine. It does not support upgrade from or side-by-side installations with any previous version of SQL Server, including SQL Server 2012.

Below is the step by step install process –

[Please click on the images for a better resolution]

Step 1 –  

We will run the setup.exe to get the regular install screen.

SQL2014Install1

Step…

View original post 215 more words

Categories: INDEXES

Amazing SQL server tools every DBA must have!!! – Part 2

June 25, 2013 Leave a comment

Amazing SQL server tools every DBA must have!!!

Categories: INDEXES

SQL SERVER – List All Objects Created on All Filegroups in Database

June 19, 2013 Leave a comment

List All Objects Created on All Filegroups in Database

Categories: INDEXES

How to move table to particular file in database

June 19, 2013 Leave a comment

moving Tables from one filegroup to another filegroup ENJOY 🙂

Sql And Me

Well, it can’t be done. You cannot move a table to a particular file in database.

 

What you can do is move the table to a particular file group. A FILEGROUP contains one or more data files. If the FILEGROUP contains more than one data file, SQL Server uses a proportional fill algorithm to make use of all data files in the FILEGROUP. On the other hand, if the FILEGROUP contains a single data file, then you can say that you have moved the table to a particular file without any doubts.

To move a table to a particular file file group, you need to re-create the clustered index on the table. Recreating an index effectively moves the table to the new FILEGROUP. The example below demonstrates the same.

 

Let’s create a test database to work with:

USE   [master]

GO

 

CREATEDATABASE [TestDB]

View original post 715 more words

Categories: INDEXES