Archive for June, 2013

What’s my OS bit LEVEL 32 or 64

June 30, 2013 3 comments

recently I needed to check OS level of few servers   most servers in my environment , I was looking for query I could run from

CMS .. to get a consolidated CentralManagementServerdata from all servers .

I got an initial idea from link .. A big Thanks to Thomas LaRock

I had few servers where DMV or 2005 + onwards features or tables where

not available .. so I have modified Thomas’s script a bit to suit my needs

below script can be RAN on CMS or individual SQL server

output will have Servername, OS bit level,SQL bit level and whether Server

is VM (works for Hypervisor or VM) or Physical


@@servername ‘Servername’,


when RIGHT(SUBSTRING(@@VERSION,CHARINDEX(‘<‘,@@VERSION), 4), 2)like ’64’ then ’64’

else ’32’



when RIGHT(SUBSTRING(CONVERT(varchar,SERVERPROPERTY(‘Edition’)),CHARINDEX(‘(‘,CONVERT(varchar,SERVERPROPERTY(‘Edition’))), 3), 2)like’64’ then’64’

else ’32’

end ‘SQL TYPE’,

case when substring(@@version,CHARINDEX(‘Hypervisor’,@@version),10)like’Hypervisor’ then ‘VM’

when substring(@@version,CHARINDEX(‘VM’,@@version),2)like’VM’ then ‘VM’
else ‘physical’ END ‘SERVER TYPE’


let me know if you are facing any issue with this script ..

enjoy 🙂


Installing SQL Server 2014 CTP1 – Step by Step

June 30, 2013 Leave a comment

Getting Started 2014 CTP1 ..


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.


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.



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]




View original post 715 more words

Categories: INDEXES

Windows Azure pay per minute – Time is money !

June 17, 2013 Leave a comment

Windows Azure pay per minute – Time is money !


One of the most exciting news which got announced yesterday was related to Windows Azure. When Scott Guthrie mentioned that billing model for Windows Azure is going to be per minute basis from now on, then there was a great cheer from the crowd.

Time is money

This is indeed a game changing announcement. I definitely foresee great amount of Windows Azure usage in the future, and this announcement is a great deal for the cloud adopters.

Earlier if I had used my cloud service for 20 minutes,and then turned that off I was charged still for the full hour. Lot many cloud providers still operate with this policy.

Going forward I will be charged for what I useI will be charged for just 20 minutes, no questions asked.

Another super news which was really exciting for me was related to no charge for stopped VMs.

Think about a situation –

Your Dev/Test folks works from…

View original post 109 more words

Categories: INDEXES

free SQL server books for download

June 16, 2013 Leave a comment

download some of the BEST SQL server books ALL for FREEE … books on more then 10 topics …

available for free download ..

1> execution plan

2> profiler

3> security

4> SQL hardware and many more ..

JUST click on —– Download eBook (PDF): Free —— beside the book you are interested in ………….