Sql Server - Collation

How to know the collation of a database?

Execute the following sql statement by changing the DataBase_Name.


SELECT DATABASEPROPERTYEX( 'DataBase_Name' , 'Collation' ) AS DatabaseCollation

How to know the collation of Sql Server?


SELECT SERVERPROPERTY('Collation') AS ServerCollation


Job Sites and Consultants Information

Job Sites

http://www.dice.com/
http://www.simplyhired.com/
http://www.careerbuilder.com/
http://www.jobdhundo.com/ (Seattle Area Job Site)
http://www.careercup.com/
http://www.monster.com/

Consultant / HR Information

iGate
mrudul.godavarthi@igate.com
Mrudul.godavarthi@mastech.com
Direct: 412-894-8001

ExcellData

Tanuta.Singh@excell.com
Neha.Jha@excell.com
Sangeeta.Halepet@excell.com

Aditi

anuradhab@aditi.com

yashodhrar@aditi.com

SolutionIQ

Alycia

Abeck@solutionsiq.com

Adaequare

Gokul

gksaride@adaequare.com

Daniel M. Lee
IT Recruitment
Rydek Professional Staffing
Tel 310-641-9800 x22
TOLL FREE: (888)222-2934 X 22
Cell: 310-892-2125
FAX: 310-641-9804
DLEE@RYDEK.COM
WWW.RYDEK.COM

Nancy Wojack
Technical Staffing Consultant
VisionIT Inc.
313.664.5661 - Direct
313.664.5650 - Main
313.664.5652 - Fax
Nwojack@visionitinc.com
http://www.visionitinc.com

Prateek Gattani
IDC Technologies Inc.
Campbell, CA
Tel: (408) 891-2184
Fax: (408) 608-6088
Email: pat@idctechnologies.com

Kelli Upton
Bradson Technology Professionals
425-456-8900 office
253-350-5491 cell
kupton@bradsontech.com
www.bradsontech.com

Nina Schindler Work: (408) 739-4900 Ext. 123 Fax: (866) 996-9977
Maxonic 1230 Midas Way Suite 220 Sunnyvale, CA 94085-4068 www.maxonic.com
nina@maxonic.com

sreelu@swinsoft.com

SQL Server -- Shortcuts

SQL Server Management Studio:

• Ctrl + Alt + G -- View Registered Servers
• Ctrl + Alt + T -- View Template Explorer -- This is helpfull when creating objects using sql script.
• Ctrl + R -- Toggle Result Pane (Message Window) -- This will help to display more space while writing Sql script.
• F8 -- To open Object Explorer

SQL SERVER 2005: Partitions

Two Type of Partitions:
1. Horizontal Partition
Saving rows into different tables based on data range.
2. Vertical Partition
Splitting the table into smaller tables (columns). Scattering the columns into multiple tables

Process to implement Horizontal Partition:

• Create partition function
• Create partition scheme
• Create the table/index

SQL Server -- Acronym

• DMX -- Data Mining Extension
• DSV -- Data Source View
• MDF -- Master Data File -- Primary data file for the database in SQL Server.
• MDX -- Multidimensional Expressions
• NDF -- -- Secondary data file for the database.
• OLAP -- Online Analytical Processing
• OLTP -- Online Transaction Processing
• RDL -- Report Definition Language
• SAC -- Surface Area Configuration -- Used to manage Sql Service / features by SQL Server Administrators
• SMDL -- Semantic Data Modeling Language
• T-SQL -- Transact SQL -- Microsoft Proprietary Language for writing SQL statements.
• XMLA --

Different ways to move database from one server to another server

There are different ways to move database from one server to another server

1. Detach/Attach
2. Backup/Restore
3. Copy database Wizard
4. Import/Export
5. Manual script