- 博客(10)
- 收藏
- 关注
转载 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 206
转载 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 82
转载 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 77
转载 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=e240GlAUp5kDetail steps and analysis on the following links: (How to genera...
2013-03-11 11:05:00 117
转载 Varchar2 vs Nvarchar
OracleAL16UTF16:Varchar2(N char) == Nvarchar(N) in SQL ServerVarchar2(N) ==Nvarchar(2*N) in SQL ServerOracleAL32UTF8:Varchar2(N char) == Nvarchar(3*N) in SQL ServerVarchar2(N) ==Nva...
2013-03-08 10:52:00 62
转载 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 72
转载 database table column name
-- To find all database names;select name from sys.databases;-- To find all table names under a databaseuse DBName;goselect name from sys.tables;-- To get column name, data type...
2013-03-07 18:00:00 107
转载 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 70
转载 FileStream with SQL Server
Some concept:http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspxvarbinary(max) is used to store small object within table, filestream varbinary(max) is used to store big objec...
2013-03-06 15:20:00 51
转载 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.aspxhttp://blogs.msdn.com/b/ssma/archive/2011/07/12/announcing-sql-server-migration-assi...
2013-02-26 15:04:00 88
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人