A technology blog by a self motivated DBA .

This blog is created to add all the information and experiences that I have learnt while working on MS sql server as a DBA. The blog is also updated frequently with the real world problem that I encounter hands on at work and the resolutions to resolve them. I hope this blog will be of some use to you and you will revisit. Thank you for stopping by and you are welcome to leave comments.

Pages

My blog
ToolBox ( scripts)
Helpful SQL links
Performance
Database Healthcheck
Bookmarks from blogauthority

Showing posts with label data converison. Show all posts

Friday, June 29, 2012

Data Conversions

taken from http://msdn.microsoft.com/en-us/library/ms187928.aspx

Posted by mst at 8:28 AM No comments:

Labels: data converison

Older Posts Home

Subscribe to: Posts (Atom)

Subscribe To

Posts

Atom

Posts

All Comments

Atom

All Comments

Blogs to read

SSIS KB
sql server DBA
ETL example
DBA diaries
SQL DBA Diaries
Systems Engineering and RDBMS
Index Fragmentation Report

Handy tips

SQl mag- administration tips
Checklist for analyzing slow running query
Large table cleanup with minimal locks

Labels

.net error (1)
accessing control (2)
Administration (57)
ADO.NET Source (1)
age (1)
alter table (1)
asp.net (5)
assigning control parameters (1)
autogrowth (4)
avoid temp table (1)
Backup database (7)
backup files (5)
backup key (2)
baselining (2)
batch update (1)
benchmarking (1)
BIDS (1)
bottlenecks (1)
cache (1)
catalogs (1)
CDC (1)
change data capture (1)
coalesce (1)
code behind (3)
control parameters (1)
controls (2)
conversion (1)
cool t-sqls (7)
corrupt (2)
CPU (1)
CPU consumption (1)
create database (3)
create sql jobs. move sql jobs (2)
CTE (3)
data (2)
data converison (1)
Data flow task (1)
data import (2)
data transformation editor (1)
database administration (2)
database growth (4)
database lock (1)
database monitor (3)
database name (1)
database recovery (1)
database role (3)
database user mode (2)
datacollector (2)
datafile (7)
dataflow (1)
dataload (1)
date query (1)
datetime (1)
db_excutor (1)
dbcc checkdb (3)
dbcc checktable (1)
Dbmail (7)
default settings (1)
deletion (2)
detach database (1)
diskspace management (3)
drop (1)
DTS (1)
duplicate rows (1)
dynamic sql (6)
error (17)
error handling (5)
excel (2)
exclusive lock (1)
execute (2)
explicit_object_permission (1)
file growth (1)
filename (1)
filesize (3)
foreign key (1)
gridview (1)
index management (4)
installation (1)
key relationship (1)
lag (1)
large file (1)
linked server (2)
listview (1)
lock (1)
locks (1)
login (2)
login failure (1)
mapped drive (1)
master page (2)
master_files (1)
memory (1)
memory management (1)
migrate (2)
model (2)
MODIFY FILE (1)
move data file (3)
msdb (9)
MSDTC (1)
multiple CTE (1)
multithreading (1)
network (1)
notifications (1)
NT AUTHORITY\ANONYMOUS LOGON (1)
objects (3)
offline (1)
orphan users (2)
output paramerer in stored procedure (1)
page splits (1)
page_id (1)
parameter (1)
parent and child SSIS (1)
perfmon (5)
performance (5)
performance counters (3)
performance monitor (5)
permissions (12)
PLE (1)
PVP (1)
query (4)
recovery (2)
relog (1)
Replication (1)
report (1)
resize database (2)
restore database (4)
restore key (2)
revoke (1)
Schedule jobs (1)
schemas (3)
script (26)
securityadmin role (1)
select top (1)
serach (1)
server (1)
server role (1)
serverside trace (1)
single user mode (1)
solved (1)
sp_executesql (1)
sql (6)
sql 2000 (4)
sql 2005 (2)
sql 2008 (4)
SQL Agent Jobs (7)
sql monitoring (2)
sql profiler (2)
sql service (2)
sql users (1)
sql2008 (6)
sqldatasource (1)
sqlerrorlog (2)
sqlfunctions (1)
sqljobs (1)
SSIS (16)
SSIS error (3)
SSIS logging (1)
SSISDB (4)
SSISDB master KEY (3)
start up (1)
startup parameters (1)
stored procedures (5)
stress at work (2)
string manipulation (3)
suser_sname (1)
suspect mode (5)
suspect pages (1)
suspect pages errors (1)
sys.master_files (1)
sys.sp_cdc_enable_table (1)
sysfiles (2)
system database (2)
t-sql (7)
Table data type (2)
table size (1)
Table Value parameter (2)
Tally (1)
tempdb (3)
text (2)
top n (1)
TPV (1)
trace (5)
transaction (2)
transaction lock (1)
transaction log (2)
Transactionscope (1)
transfer (2)
triggers (1)
trouble shoot (5)
try catch block (1)
UDF (1)
union (1)
update (1)
upgrade (2)
user defined functions (2)
users (4)
vb.net (3)
verify database (1)
views (1)
work adventure (6)
work issue (2)
xml (4)
xml path (1)
xmlfile (1)
xmlquery (3)
xp_cmdshell (2)
xp_readerrorlog (2)

New in SQL 2008

DTS --> SSI

Date --> new data type

Time --> new data Type

DECLARE @intCnt INT=1 assign value in variable declaration

Filtered INDEX

To be a DBA

Task roundup

Blog Archive

▼ 2024 (1)
- ▼ July (1)
  - Using multiple CTEs

► 2023 (1)
- ► January (1)

► 2019 (1)
- ► February (1)

► 2018 (6)
- ► November (1)
- ► June (2)
- ► May (1)
- ► April (1)
- ► February (1)

► 2017 (11)
- ► December (2)
- ► August (1)
- ► June (1)
- ► April (1)
- ► March (1)
- ► February (2)
- ► January (3)

► 2016 (17)
- ► October (1)
- ► July (2)
- ► June (4)
- ► May (1)
- ► April (4)
- ► March (2)
- ► February (2)
- ► January (1)

► 2015 (34)
- ► December (3)
- ► November (4)
- ► October (4)
- ► August (1)
- ► July (2)
- ► June (3)
- ► May (2)
- ► March (3)
- ► February (5)
- ► January (7)

► 2014 (19)
- ► October (8)
- ► July (2)
- ► June (2)
- ► April (1)
- ► February (4)
- ► January (2)

► 2013 (8)
- ► December (1)
- ► June (3)
- ► March (1)
- ► January (3)

► 2012 (31)
- ► October (1)
- ► September (1)
- ► August (4)
- ► July (4)
- ► June (3)
- ► May (1)
- ► April (3)
- ► March (3)
- ► February (8)
- ► January (3)

► 2011 (19)
- ► December (1)
- ► October (3)
- ► September (1)
- ► August (2)
- ► July (1)
- ► June (6)
- ► May (4)
- ► January (1)

► 2010 (3)
- ► December (3)

Sql 2008

Configure FILESTREAM
Policy Management ( e.g. not allow Administrators on sql server)

Blog Directory

visits

Awesome Inc. theme. Powered by Blogger.