'Brain Trainning > DataBase' 카테고리의 다른 글
버전 호환성 Upgrade 작업 후 해야할 작업 (0) | 2010.08.12 |
---|---|
SP_Helpindex2 (0) | 2010.08.11 |
MSSQL 2008 설치 Video (Microsoft) (0) | 2010.07.23 |
[SSRS] Microsoft Video (0) | 2010.07.23 |
[SSAS] Microsoft Video (0) | 2010.07.23 |
버전 호환성 Upgrade 작업 후 해야할 작업 (0) | 2010.08.12 |
---|---|
SP_Helpindex2 (0) | 2010.08.11 |
MSSQL 2008 설치 Video (Microsoft) (0) | 2010.07.23 |
[SSRS] Microsoft Video (0) | 2010.07.23 |
[SSAS] Microsoft Video (0) | 2010.07.23 |
SQL Server 2008 설치 비디오를 사용하여 다음과 같은 목표를 수행할 수 있습니다.
SQL Server 2008 설치(SQL Server 비디오)
SQL Server 2008 단일 노드 장애 조치(Failover) 클러스터 설치(SQL Server 비디오)
기존 SQL Server 2008 장애 조치(Failover) 클러스터에 노드 추가(SQL Server 비디오)
기존 SQL Server 2008 장애 조치(Failover) 클러스터에서 패시브 노드 제거(SQL Server 비디오)
기존 SQL Server 2008 장애 조치(Failover) 클러스터에서 액티브 노드 제거(SQL Server 비디오)
SP_Helpindex2 (0) | 2010.08.11 |
---|---|
DB 파일 사용상태 쿼리 (0) | 2010.08.06 |
[SSRS] Microsoft Video (0) | 2010.07.23 |
[SSAS] Microsoft Video (0) | 2010.07.23 |
[SSIS] Microsoft Video (0) | 2010.07.23 |
SQL Server 2008 Reporting Services 비디오를 통해 달성할 수 있는 목표는 다음과 같습니다.
DB 파일 사용상태 쿼리 (0) | 2010.08.06 |
---|---|
MSSQL 2008 설치 Video (Microsoft) (0) | 2010.07.23 |
[SSAS] Microsoft Video (0) | 2010.07.23 |
[SSIS] Microsoft Video (0) | 2010.07.23 |
디스크공간 / 여유공간 (0) | 2010.07.18 |
Analysis Services 비디오를 통해 달성할 수 있는 목표는 다음과 같습니다.
MSSQL 2008 설치 Video (Microsoft) (0) | 2010.07.23 |
---|---|
[SSRS] Microsoft Video (0) | 2010.07.23 |
[SSIS] Microsoft Video (0) | 2010.07.23 |
디스크공간 / 여유공간 (0) | 2010.07.18 |
디스크 여유공간 체크 및 메일보내기~ (0) | 2010.07.18 |
Integration Services 비디오를 통해 달성할 수 있는 목표는 다음과 같습니다.
Excel로 SQL Server 데이터 내보내기(SQL Server 비디오)
방법: SQL Server 에이전트를 사용하여 SSIS 패키지 실행 자동화(SQL Server 비디오)
방법: 웹 서비스 태스크를 사용하여 웹 서비스 호출(SQL Server 비디오)
방법: 전체 캐시 모드에서 조회 변환 구현(SQL Server 비디오)
방법: 데이터 프로파일링 태스크 사용(SQL Server 비디오)
문제 해결: SQL Server 에이전트를 사용하여 SSIS 패키지 실행(SQL Server 비디오)
SSIS: 성능 디자인 및 튜닝 SQL Server 비디오 시리즈엔터프라이즈의 SSIS 패키지 성능 측정 및 이해(SQL Server 비디오)
엔터프라이즈의 SSIS 패키지 데이터 흐름 튜닝(SQL Server 비디오)
[SSRS] Microsoft Video (0) | 2010.07.23 |
---|---|
[SSAS] Microsoft Video (0) | 2010.07.23 |
디스크공간 / 여유공간 (0) | 2010.07.18 |
디스크 여유공간 체크 및 메일보내기~ (0) | 2010.07.18 |
Categories of DMOs (0) | 2010.07.16 |
use master go if object_id('dbo.usp_fixeddrives') is not null drop procedure dbo.usp_fixeddrives go create procedure dbo.usp_fixeddrives as /* ********************************************************************* Author : Bouarroudj Mohamed E-mail : mbouarroudj@sqldbtools.com Date : March 2005 Description : xp_fixeddrives wrapper Note : you can add handling error as following (see BOL): exec @hr = sp_OAMethod @ObjectToken,'GetDrive', @odrive OUT, @drive if @hr <> 0 begin -- Obtains OLE Automation error information exec sp_OAGetErrorInfo ... handle error end ********************************************************************* */ set nocount on --------------------------------------------------------------------- -- Declarations --------------------------------------------------------------------- declare @ObjectToken int, @drive char(1), @odrive int, @TotalSize varchar(20), @MB bigint --------------------------------------------------------------------- -- Initializations --------------------------------------------------------------------- set @MB = 1048576 create table #Driveslist ( Drive char(1) NOT NULL, FreeSpaceMB int NULL, TotalSizeMB int NULL ) --------------------------------------------------------------------- -- Processing --------------------------------------------------------------------- insert #Driveslist(Drive, FreeSpaceMB) exec master.dbo.xp_fixeddrives exec sp_OACreate 'Scripting.FileSystemObject', @ObjectToken OUT --Creates an instance of the OLE object on an instance of SQL Server. declare DriveslistCur cursor local fast_forward for select Drive from #Driveslist open DriveslistCur fetch next from DriveslistCur into @drive while @@FETCH_STATUS = 0 begin -- Calls a method GetDrive exec sp_OAMethod @ObjectToken, 'GetDrive', @odrive OUT, @drive -- Gets a property TotalSize exec sp_OAGetProperty @odrive,'TotalSize', @TotalSize OUT update #Driveslist set TotalSizeMB = @TotalSize / @MB where drive = @drive fetch next from DriveslistCur into @drive end close DriveslistCur deallocate DriveslistCur exec sp_OADestroy @ObjectToken select drive, TotalSizeMB as 'Total(MB)', FreeSpaceMB as 'Free(MB)', CAST(TotalSizeMB/1024.0 as decimal(10,2)) 'Total(GB)', CAST(FreeSpaceMB/1024.0 as decimal(10,2))'Free(GB)', CAST((FreeSpaceMB/(TotalSizeMB * 1.0)) * 100.0 as int) as 'Free(%)' from #Driveslist order by drive drop table #Driveslist return go exec dbo.xp_fixeddrives go exec dbo.usp_fixeddrives go
이런 좋은 쿼리가 있네요... 출처는 주석에~
[SSAS] Microsoft Video (0) | 2010.07.23 |
---|---|
[SSIS] Microsoft Video (0) | 2010.07.23 |
디스크 여유공간 체크 및 메일보내기~ (0) | 2010.07.18 |
Categories of DMOs (0) | 2010.07.16 |
SQL Server 2005 DBCC Command Quick Reference (0) | 2010.07.16 |
[SSIS] Microsoft Video (0) | 2010.07.23 |
---|---|
디스크공간 / 여유공간 (0) | 2010.07.18 |
Categories of DMOs (0) | 2010.07.16 |
SQL Server 2005 DBCC Command Quick Reference (0) | 2010.07.16 |
Top 10 SQL Server 2008 Features for ISV Applications (1) | 2010.07.14 |
The DMOs are divided into different categories and named accordingly to be easy to find and distinguish. All DMO names start with the prefix dm_ (no difference between DMVs and DMFs). Next follows a prefix identifying the category a DMO belongs to. For instance, the prefix dm_io_ is used for dynamic management objects that return information regarding disk and network I/O. Another category is dm_clr_ which is used for DMOs that return information regarding the hosting of the CLR (.NET Common Language Runtime) in SQL Server. Below is a listing of the complete set of categories of dynamic management objects.
디스크공간 / 여유공간 (0) | 2010.07.18 |
---|---|
디스크 여유공간 체크 및 메일보내기~ (0) | 2010.07.18 |
SQL Server 2005 DBCC Command Quick Reference (0) | 2010.07.16 |
Top 10 SQL Server 2008 Features for ISV Applications (1) | 2010.07.14 |
SQL Server 2008 T-SQL Enhancements (0) | 2010.07.14 |
Seven new DBCC commands have been introduced by Microsoft's SQL Server development team.
Unfortunately little or no documentation is available on the new commands listed below, though some of them may be documented in the RTM release.
Those that are listed as being documented do not require a trace flag to be set before using them.
However, to use the undocumented commands, you will need to turn on trace flag 2588.
This has changed since SQL Server 7.0/2000, where the trace flag was 2520.
Please note that the following is a result of investigations with the beta 2 release of SQL Server 2005, the final RTM release may differ slightly.
As always, never use an undocumented DBCC command on a production server unless advised by Microsoft, and never use a documented one unless you understand how it may affect the performance of your server.
Documented new commands
Undocumented new commands
The following is presented as a list of pairs of commands. The first command is the old syntax, as used in SQL Server 2000. The second of each pair is the altered syntax new to SQL Server 2005. In most cases the commands have been extended to take advantage of passing an object ID instead of a name, but if your scripts use any of these commands, it's probably worth checking them out before you migrate to SS2K5.
2000 : checkalloc [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, ESTIMATEONLY]]
2005 : checkalloc [('dbname'|dbid[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[,ALL_ERRORMSGS][, ESTIMATEONLY]]
Changes : SQL Server 2005 now accepts the dbid as well as the dbname
2000 : checkdb [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]
2005 : checkdb [('dbname | dbid'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[,ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]
Changes : SQL Server 2005 now accepts the dbid as well as the dbname
2000 : checkident ('table_name'[, { NORESEED | {RESEED [, new_reseed_value] } } ] )
2005 : checkident ('table_name'[, { NORESEED | {RESEED [, new_reseed_value] } } ] )
Changes :
Although the syntax is identical for SQL Server 2000 and 2005, there is a subtle change in the behaviour of this command.
In SQL Server 7.0 and 2000, running checkident would cause the identity column to be re-seeded, even if the table was empty.
In SQL Server 2005, if the table is empty when dbcc checkident is run, the reseed value will be ignored.
2000 : dbrepair ('dbname', DROPDB [, NOINIT])
2005 : dbrepair ('dbname', markdirty | {dropdevice, int} | {repairindex, int, int})
Changes : dropdevice syntax changed ; markdirty and repairindex options added
NB : It seems odd that this command has been extended with this release, as in the SQL Server 2005 setup help file, setupsql9.chm, it states that DROP DATABASE should be used instead of this command. It was included in SQL Server 2000 for backward compatibility only.
2000 : indexdefrag ({dbid | dbname | 0}, {tableid | tablename}, {indid | indname})
2005 : indexdefrag ({dbname | dbid | 0}, {tableid | tablename} [, {indid | indname} [, partition_number]])
Changes : An extra optional parameter has been added, partition_number
2000 : inputbuffer (spid)
2005 : inputbuffer (spid, [batchid])
Changes : An extra optional parameter has been added, batch_id
2000 : outputbuffer (spid)
2005 : outputbuffer (spid, [batchid])
Changes : An extra optional parameter has been added, batch_id
2000 : proccache
2005 : proccache ([compplan_ticks_threshold])
Changes : An optional parameter has been added, compplan_ticks_threshold
2000 : sqlperf (LOGSPACE)({IOSTATS | LRUSTATS | NETSTATS | RASTATS [, CLEAR]} | {THREADS} | {LOGSPACE})
2005 : sqlperf (LOGSPACE | IOSTATS | NETSTATS | RASTATS [, CLEAR]} | [THREADS] )
Changes : As for 2000, but LRUSTATS has been removed as an option.
NB : Microsoft only document the LOGSPACE parameter of this command - use any others at your own discretion.
2000 : updateusage ({'database_name'| 0} [, 'table_name' [, index_id]]) [WITH [NO_INFOMSGS] [,] COUNT_ROWS]
2005 : updateusage ({'dbname' | dbid | 0} [, {'table_name' | table_id} [,{index_id | 'index_name'}]]) [WITH [NO_INFOMSGS] [,] COUNT_ROWS]
Changes : Can now specify db_id, table_id, or the index name as parameters, instead of just the db/table/index name.
Also note that there is a problem with the output generated by the dbcc showcontig command under certain conditions in the beta version of SQL Server 2005, where more than one block of information per index is generated for tables that contain text columns.
Many of us have used them at one time or another and a few might even depend upon them. However, we can't say we have not been warned, and Microsoft have finally retired a whole raft of dbcc commands in SQL Server 2005.
Most of these were not particularly useful, but thoughtfully retained right up to SQL Server 2000 for backward compatibility with SQL Server 6.5 and earlier scripts.
The following dbcc commands are now dead and buried from SQL Server 2005 onwards:
adduserobject (name)
balancefactor (variance_percent)
bufcount [(number_of_buffers)]
cacheprofile [( {actionid} [, bucketid])
checkdbts (dbid, newTimestamp)]
des [( {'dbname' | dbid} [, {'objname' | objid} ])]
dropuserobject ('object_name')
getvalue (name)
iotrace ( { 'dbname' | dbid | 0 | -1 }, { fileid | 0 }, bufsize, [ { numIOs | -1 } [, { timeout (sec) | -1 } [, printopt={ 0 | 1 }]]] )
lockobjectschema ('object_name')
matview ({'PERSIST' | 'ENDPERSIST' | 'FREE' | 'USE' | 'ENDUSE'})
memospy
memusage ([IDS | NAMES], [Number of rows to output])
monitorevents ('sink' [, 'filter-expression'])
newalloc (previously retired, use of checkalloc recommended instead)
perflog
pglinkage (dbid, startfile, startpg, number, printopt={0|1|2}, targetfile, targetpg, order={1|0})
procbuf [({'dbname' | dbid}[, {'objname' | objid}[, nbufs[, printopt = { 0 | 1 } ]]] )]
rebuild_log (dbname [, filename])
row_lock (dbid, tableid, set) - Not Needed
shrinkdb (previously retired, use of shrinkdatabase recommended instead)
tab ( dbid, objid )
tape_control {'query' | 'release'}[,('\\.\tape
textall [({'database_name'|database_id}[, 'FULL' | FAST] )]
textalloc ({'table_name'|table_id}[, 'FULL' | FAST])
upgradedb (db)
usagegovernor (command, value)
wakeup (spid)
dbreindex
This will be replaced with the REBUILD option of the ALTER INDEX statement.
indexdefrag
This will be replaced with the REORGANIZE option of the ALTER INDEX statement.
showcontig
This command will be replace by the system function fn_indexinfo
SQL Server 2005 Express Edition
Except where noted below, the above investigation was carried out on the Beta 2 release of SQL Server 2005 Express Edition.
At the time of writing (November 2004) this product was available as a free download at http://www.microsoft.com/sql/
SQL Server 2005 Setup Help (c) Microsoft Corporation 2004.
The information about future discontinued DBCC commands was sourced from Microsoft's SQL Server 2005 setup help file.
It is recommended reading for anyone who writes commercial database software that depends upon the lower-level functionality provided by SQL Server, as it includes details of discontinued commands and configuration options.
This document can be found at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Help\1033\setupsql9.chm, after installing SQL Server 2005 Express Edition to the default installation directory.
Search on "dbcc" to find this information.
디스크 여유공간 체크 및 메일보내기~ (0) | 2010.07.18 |
---|---|
Categories of DMOs (0) | 2010.07.16 |
Top 10 SQL Server 2008 Features for ISV Applications (1) | 2010.07.14 |
SQL Server 2008 T-SQL Enhancements (0) | 2010.07.14 |
SQL Patch 정보 (0) | 2010.06.18 |
Sessions with titles in bold are available for smooth streaming playback
If you’d like to download all of the keynote and session content, download a recent build of cURL (~250K), and extract it to your folder-of-choice. Then, download PDC09Downloader.zip (1.49KB) and extract the PDC09Downloader.bat file to the same folder. From a command prompt, start PDC09Downloader by passing it one of the following parameters: WMVHIGH, WMV, MP4, PPTX. Then wait. For files that aren’t available, cURL will download a file that is around 221 bytes in size (if you change the extension to .htm and open it, you’ll see that the file is simply an HTML "not found" error page).
To rename the files, first, download the PDC09 Renamer batch file (4.52KB). Then, extract the PDC09Renamer.bat file to the folder that contains your downloaded files, and from a command prompt, type PDC09Renamer WMV to rename all of the .WMV files to the full session title. By changing the parameter, you can also rename your PPTX and MP4 files.
[MAC] Keynote 사용설명서.... (0) | 2012.02.23 |
---|---|
MS 워드를 활용한 블로그 글올리기 (1) | 2011.01.09 |
가상화 관련 링크 (0) | 2010.11.18 |
Shift-Space 로 한영전환 Reg (0) | 2010.06.07 |
각 나라별 사용 IP대역 (0) | 2010.05.06 |