banfei1920-CSDN博客

转载 Add a filegroup

create database TestPrimaryDb on primary ( Name='TestPrimaryDb', FILENAME ='D:\data\TestPrimaryDb.mdf' ) ,filegroup fg1 ( Name='TestPrimaryDbfg1', FILENAME ='D:\data\TestPrimaryDbfg...

2013-03-14 10:49:00 252

转载 Tuning Performance

1. OS level: SELECT wait_type, waiting_tasks_count, wait_time_ms, max_wait_time_ms, signal_wait_time_ms FROM sys.dm_os_wait_stats ORDER BY wait_type;-- The DMV accumul...

2013-03-12 14:51:00 111

转载 Full Text Search

-- Refer to http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ /* the following command is to change the UI method to codes. */ use AdventureWorks2008R...

2013-03-11 14:29:00 98

转载 install SQL server with configuration file

We can following the following video with the installation file on the current drive: http://www.youtube.com/watch?v=e240GlAUp5k Detail steps and analysis on the following links: (How to genera...

2013-03-11 11:05:00 154

转载 Varchar2 vs Nvarchar

OracleAL16UTF16: Varchar2(N char) == Nvarchar(N) in SQL Server Varchar2(N) ==Nvarchar(2*N) in SQL Server OracleAL32UTF8: Varchar2(N char) == Nvarchar(3*N) in SQL Server Varchar2(N) ==Nva...

2013-03-08 10:52:00 81

转载 Statistics with index

1. After creating index, there will be a statistics generated. 2. After dropping the index, the statistics will be dropped together. When the clustered index of an indexed view is dropped, all...

2013-03-08 10:07:00 93

转载 database table column name

-- To find all database names; select name from sys.databases; -- To find all table names under a database use DBName; go select name from sys.tables; -- To get column name, data type...

2013-03-07 18:00:00 142

转载 database file modification

Create database SplitDBFile on primary ( Name='SplitDBFile', filename='D:\SharedFolder\SplitDBFile.mdf', SIZE=50MB, FILEGROWTH=10% ) use SplitDBFile; go -- [primary] must incl...

2013-03-07 14:19:00 96

转载 FileStream with SQL Server

Some concept: http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx varbinary(max) is used to store small object within table, filestream varbinary(max) is used to store big objec...

2013-03-06 15:20:00 72

转载 SSMA migrate data from Oracle to SQL Server

1. Related documents: step by step to configure SSMA: http://msdn.microsoft.com/en-us/library/hh313179.aspx http://blogs.msdn.com/b/ssma/archive/2011/07/12/announcing-sql-server-migration-assi...

2013-02-26 15:04:00 109