Archive
What’s my OS bit LEVEL 32 or 64
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 
data 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
SELECT
@@servername ‘Servername’,
case
when RIGHT(SUBSTRING(@@VERSION,CHARINDEX(‘<‘,@@VERSION), 4), 2)like ’64’ then ’64’
else ’32’
END ‘OS TYPE’,
case
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
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.
Step…
View original post 215 more words
Amazing SQL server tools every DBA must have!!! – Part 2
Amazing SQL server tools every DBA must have!!!
SQL SERVER – List All Objects Created on All Filegroups in Database
List All Objects Created on All Filegroups in Database
How to move table to particular file in database
moving Tables from one filegroup to another filegroup ENJOY 🙂
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
Windows Azure pay per minute – Time is money !
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.
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 use. I 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
free SQL server books for download
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 ………….
http://www.sqlservercentral.com/books/
ENJOY 🙂
what the service pack of my SQL server
Hi all,
you may required to check your SQL service packs .. use below template to compare the same as of JULY 2013 …
use query as
1> select @@version
output ::
Microsoft SQL Server 2008 R2 (SP2) – 10.50.4000.0 (X64)
Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
2>
SELECT SERVERPROPERTY(‘productversion’)‘productversion’,SERVERPROPERTY(‘productlevel’)‘Servicepack’,SERVERPROPERTY(‘edition’)‘Product Edition’
use below chart for your reference
chart referred from –> http://sqlserverbuilds.blogspot.in/
Enjoy 🙂
how to Slipstream SP2 or SP1 for SQL 2008 R2 – part 2 – installing reporting services along with database engine
Hi all,
as promised in my last post .. that I will test a scenario were in .. if we try to install reporting services using a Slipstream SP2 of SQL
server 2008 R2 .. then we may hit issues and installation may fail .. all together for reporting services ..
Nicolas Cain has covered more on this at this site –> http://sirsql.net/blog/2012/11/15/issues-with-slipstreaming-service-pack-2-on-to-sql-2008-r2.html
you may refer the post over here how to Slipstream SP2 or SP1 for SQL 2008 R2
below are the step followed for installing SQL reporting services along with DB engine (using Slipstreamed SP2 of SQL server 2008 R2)
my OS was windows 7 SP1 64 bit ..
1> selected reporting services and database engine on feature selection page ..
2> update setup media compatibility test PASSED .. signifying slipstream installation
3> Giving a named instance for this particular instance ..
4> choosing to install NATIVE mode Default installation for Reporting services
5> verified that our installation is a SLIPSTREAMED installation of SP2
6> confirm the features selected
7> summary log file .. shows success for reporting services feature installation ..
Notes:
I was able to connect to reporting services using SSMS server name as –> http://machinename:8080/ReportServer_SQL2008R2_INST3
I have tweaked the port no. from 80 to 8080 .. as I have trouble connecting to the same using reporting configuration
also I have recreated the reporting databases using reporting configuration GUI ..
all in all I did not face any particular issues with installation and this issue can be specific to windows OS
do share details .. if you are facing any issues for installation of reporting services using Slipstreamed method ..
Enjoy 🙂
Related articles
- how to Slipstream SP2 or SP1 for SQL 2008 R2 (sqlcurve.wordpress.com)
When statistics was updated?
script to find the LAST update stats by KARTHICK ..
Statistics are used by the SQL Server optimizer to choose the efficient plan. When we don’t have up to date statistics
it may end with SQL server optimizer choosing inefficient query plan. We can use below query to identify when SQL Server
statistics were last updated.
SQL DBA learning curve 