#title SQL References [[TableOfContents]] ==== SQL References ==== * [Unix Timestamp] * [MySQL Linked Server 버그] * [T-SQL 템플릿] * [LCS] * [모든 테이블에서 샘플 데이터 뽑기] * [openrowset] * [utf8 to unicode] * [url encoding] * [코딩 스타일 변경] * [isnull 사용시 주의사항] * [https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/12/20/transitive-closure-clustering-with-clr-and-json/ Transitive closure clustering with CLR and JSON] * [Script Backup] * [https://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/ Reading and Writing Files in SQL Server using T-SQL] * [https://www.simple-talk.com/sql/t-sql-programming/introduction-to-sql-server-spatial-data/ Introduction to SQL Server Spatial Data] * [https://www.mssqltips.com/sql-server-tip-category/81/powershell/ SQL Server PowerShell Tips] * [Math expression] * [Tempdb and transaction log IO latencies] * [OpenQuery만들기] * [UnixODBC세팅] * [대충만든 sql jitter 함수] * [SQL Server에서 HTTP Call하기] * [https://www.jitbit.com/maxblog/17-sql-server-how-to-convert-datetime-to-utc/ datetime to UTC] * [http://www.sqlservercentral.com/articles/JSON/128550/ JSON Select - Easily query values from JSON] * [클라이언트 별칭 백업-레지스트리] * [파일명 및 확장자 뽑아내기] * [http://www.symantec.com/connect/downloads/sql-stored-procedure-convert-sql-table-html-v10 SQL Stored Procedure to Convert SQL Table Into HTML (v1.0)] * [http://sqlblog.com/blogs/kalen_delaney/archive/2013/01/18/accessing-distribution-statistics.aspx Geek City: Accessing Distribution Statistics] * [http://www.sqlservercentral.com/articles/RegEx/88586/ RegEx for DBAs] * [http://www.sqlservercentral.com/articles/Policy+Based+Management+(PBM)/88486/ Standardization with PBM(Policy Based Management)] * [http://blogs.msdn.com/b/psssql/archive/2012/04/06/sql-server-2012-rml-xevent-viewer-and-distributed-replay.aspx SQL Server 2012: RML, XEvent Viewer and Distributed Replay] * [세션의 임시테이블명 리스트] * [http://www.sqlservercentral.com/articles/HTML/88605/ Parsing HTML to SQL using SQLDOM] attachment:SQLReferences/SQLDOM_core_923.sql * [http://www.sqlmag.com/article/sql-server-management-studio-ssms/generating-charts-drawings-sql-server-management-studio-141994?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+windowsitpro%2FPtva+%28SQL%3EArticles%3ETop+Stories%29 Generating Charts and Drawings in SQL Server Management Studio] attachment:SQLReferences/141994.zip * [http://www.sqlservercentral.com/scripts/Coalese/72471/ Column Headers To Row Headers] * [http://www.sqlservercentral.com/scripts/DISK/72323/ Disk Capacities] * [http://www.sqlservercentral.com/scripts/Permissions/72199/ Retrieve Database Object permission scripts and Role members scripts] * [http://www.sqlservercentral.com/scripts/Data+Dictionary/72048/ SQL SERVER 2008 Data Dictionary] * [http://www.sqlservercentral.com/articles/Recursive+function/76077/ A simple math expression solver] * [테이블의 값에 대한 기본 통계] * [isnumeric함수] * [관계 끊고 truncate] * [통계정보 갱신] * [각종 날짜계산] * [테이블 전환] * [쿼리가 끝나려면 얼마나 남았을까] * [SQL Azure] * [AD계정조회] * [3자리마다 콤마찍기] * [인덱스 없는 테이블 인덱스 만드는 쿼리만들기] * [객체의 메모리 및 디스크 사용 모니터링] * [각 로우 값 사칙연산] * [SQL Server 2008 R2 가격 및 제한사항] * [쿼리 결과를 html로 만들기] * [Partition Switch] * [리틀 엔디안 vs 빅 엔디안] * [테이블의 인덱스 및 파티션 정보보기] * [재귀쿼리를 이용한 Dumy테이블 만들기] * [http://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf 진실과 오해] attachment:SQLReferences/CommonSQLServerMyths.pdf * [시스템 구성] * [Bulk Insert] * [http://www.sqlservercentral.com/articles/Monitoring/71390/ How to centralize your SQL Server Event Logs] * [http://www.simple-talk.com/sql/t-sql-programming/sql-server-crud-generation-from-system-views/ SQL Server CRUD-Generation from System Views] * [http://www.codeproject.com/KB/database/blob_compress.aspx Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005] * [http://msdn.microsoft.com/ko-kr/library/ MSDN 라이브러리] * [기수변환] * [Trace Flags] * [CPU정보 알아내는 cscript] * [http://www.geocities.jp/maru3128/wmi.html VBS for WMI] * [http://msdn.microsoft.com/en-us/library/aa394173(VS.85).aspx WMI Class] * [http://www.databasejournal.com/features/article.php/3898591/article.htm Hierarchical Data Structure Transformation in SQL] * [http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-cursor-workbench/?utm_source=simpletalk&utm_medium=email-main&utm_content=Workbench-20100920&utm_campaign=SQL SQL Server Cursor Workbench] * [URL Encoding 함수] * [2진수 변환과 재귀쿼리] * [SQL Server Browser Service] * [날짜형 데이터의 BETWEEN] * [주민번호7번째 자리로 연령구하기] * [YYYYMMDDHHMISS_TO_DATETIME] * [YYYYMMDD로 만나이 구하기] * [숫자의 그룹화] * [TCP Port 알아내기] * [SQL Server 시작 매개변수] * [DB전체에서 코드 데이터 찾기] * [http://www.sqlservercentral.com/articles/Crosstab/65048/ Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs] * [http://rusanu.com/2010/03/26/using-tables-as-queues/ Using tables as Queues] * [종속성 레벨로 테이블 보는 방법] * [http://www.simple-talk.com/sql/t-sql-programming/exploring-your-database-schema-with-sql/ Exploring your database schema with SQL] * [open transactions with text and plans] * [빌링의 차감 및 선입선출 방법] * [동적쿼리의 따옴표의 압박에서 벗어나는 방법] * [날짜가 해당 월의 마지막 날짜인지 판단하기] * [중복 데이터 삭제하기] * [비트연산] * [페이징 방법1] * [계층형 게시판] * [랜덤추출] * [Output절의 사용] * [세제곱근 구하기] * [데이터베이스의 모든 테이블의 크기] * [옵션에 따른 백업 성능 테스트] * [OpenRowSet-Bulk] * [DBCC 명령들] * [attachment:MicrosoftSQLServer/ANSI_SQL99.pdf ANSI-SQL99] * [Script to Export Permissions] * [페이지 복원 예제] * [확장속성] * [트랜잭션 로그에서 DROP된 테이블 찾는 방법] * [클라이언트IP(Client IP) 남기는 방법] * [디스크사용량] * [잡다구리] * [OpenQuery예제] * [http://bug.gd/ 버그 찾아보기] * [attachment:checksum_io.docx 체크섬 I/O 유효성 검사(페이지 손상검색 및 치료, http://sqlnote.com/zbxe/869#0)] * [SP부하테스트 스크립트 만들기] * [계산된 컬럼 만들기] * [참조되는 참조당하는 테이블 알아내기] * [DB에서 현재 Identity값 알아내기] * [조회결과 실행하기] * [주차 구하기] * [모든 테이블에 대한 TableDiff 명령어 만들기] * [SSMS에 등록해서 쓰면 유용한 SP] * [attachment:SQLReferences/cursor.docx 커서에 대한 정리] * [스키마 간에 보안 개체 이동하기] * [T-SQL Trace] * [로그인/사용자/스키마/권한 예제] * [DateDiff함수의 구현] * [작업을 스크립트로 설정하기] * [Plan Guide 예제] * [SP 템플릿] * [CRUD 코드만들기] * [SP 자동 실행] * [Code성 데이터 수집] * [동적쿼리의 결과를 아웃풋으로 받아오는 방법] * [SQL2005 서버 설정] * [Create Snapshot] * [mssqlsystemresource 데이터베이스 내용 확인하기] * [Partitioned Table Info] * [DDL Trigger] * [Batch Window] * [다른 DB의 테이블에 대한 Synonym 만들기] * [DB의 모든 SP 재컴파일하기] * [Binary(HEX) 자체를 문자열로 나타내기] * [저장 프로시저 및 작업에서 특정 문자열 찾기] * [TempDB 옮기기] * [IP관련 함수] * [인덱스 정보 수집] * [인덱스 유지보수(재생성 or 조각모음)] * [OpenDataSource] * [테이블 및 컬럼 설명 확인(확장프로시저)] * [fn_hexstrTovarbin] * [세션의 SQL문 보기] * [데이터베이스 메일 보내기] * [SP 매개변수 데이터 타입 알아내기] * [SQL Server 2008 New features] * [attachment:DBPricing_kr.docx 데이터베이스 가격 책정 및 라이선싱에 대한 이해] * [네트워크 드라이브 설정] * [인덱스 재생성(2000버전)] * [attachment:SQL2008_vs_Oracle11g_KO_(2).docx SQL2008 vs Oracle11g(MS입장)] * [Job Script] * [테이블 한 번만 읽기1] * [파워빌더에서 SQL Server DB Library를 배포하는 방법] * [0으로 나누기 오류 무시 방법] * [SQL Server 2008R2 Edition] * [http://www.sqlservercentral.com/articles/Certificates/70170/ Using Certificates to Sign Stored Procedures] * [http://support.microsoft.com/kb/162361/ko SQL Server 외부에서 DLL 기반 COM 개체 사용] * [Dinamic Pivot] * [매일 월초부터 현재일까지 월 데이터를 처리한다면] * [배치파일] * [랜덤한거] * [SQL Server 2012 Diagnostic Information Queries] ==== 링크 ==== * [http://www.google.co.kr/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0ahUKEwiJ8sDQhurJAhVRTI4KHQHZDBgQFghMMAU&url=http%3A%2F%2Ftroels.arvin.dk%2Fdb%2Frdbms%2F&usg=AFQjCNE8NVVvGx9yt4UIg_V-s8QbSTGvbg&sig2=M5NgmubWCM7itkpoIGmOZA&bvm=bv.110151844,d.c2E Comparison of different SQL implementations] * [http://www.sqlservercentral.com/articles/Data+Types/95761/ Exploring the Varbinary Type] * [http://www.microsoft.com/en-us/download/details.aspx?id=36434 Microsoft® ODBC Driver 11 for SQL Server® - Windows] * [http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/11/07/sql-server-2012-sp1-is-now-available.aspx SQL Server 2012 SP1 Is Now Available!] * [attachment:MicrosoftSQLServer/sql-server-hardware-ebook.pdf] * [http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx Free e-Book] * [http://www.microsoft.com/ko-kr/download/details.aspx?id=30437#instructions SQL Server 2008 R2 SP2] * [http://msdn.microsoft.com/ko-kr/library/bb500435 SQL Server 2012 새로운 기능(도움말)] * [http://foreign.aladin.co.kr/shop/wproduct.aspx?ISBN=0735658366 Microsoft SQL Server 2012 High-performance T-sql Using Window Functions (Paperback)] * [http://support.microsoft.com/kb/2567616 SQL Server 2008 R2 서비스 팩 1 용 누적 업데이트 패키지 4] * [http://technet.microsoft.com/ko-kr/hh531242 TechNet SQL Server Seminar 2011-11-17(통합, 고가용성, 보안)] * [http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx SQL SERVER 2012 LICENSING OVERVIEW] * [http://technet.microsoft.com/ko-kr/library/ms143760(SQL.110).aspx SQL Server 2012 RC0 도움말] * [http://sqlblog.com/blogs/davide_mauri/archive/2011/11/24/execute-a-ssis-package-in-sync-or-async-mode-from-sql-server-2012.aspx Execute a SSIS package in Sync or Async mode from SQL Server 2012] * [http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx What’s New in SSIS for SQL Server 2012 RC0] * [http://www.microsoft.com/download/en/details.aspx?id=28145 Microsoft® SQL Server® 2012 Release Candidate 0] * [http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27721 SQL Server 2012 Developer Training Kit Web Installer Preview] * [http://blogs.technet.com/b/uktechnet/archive/2012/03/28/free-e-book-introducing-sql-server-2012.aspx Free ebook: Introducing Microsoft SQL Server 2012] * [http://www.microsoft.com/download/en/details.aspx?id=347 Denali CTP3 Books Online 다운로드] * [http://sqlblog.com/blogs/aaron_bertrand/archive/2010/11/16/sql-server-v-next-denali-contained-databases.aspx SQL Server v.Next (Denali) : Contained Databases] * [http://feedproxy.google.com/~r/technet/DeepFat/~3/HxEBItnVRRk/beyond-relational-semantic-search-with-sql-server-filetable.aspx Beyond Relational– Semantic Search with SQL Server FileTable] * [http://feedproxy.google.com/~r/technet/DeepFat/~3/ZXWF9o-cLFg/beyond-relational-fulltext-indexing-with-sql-server-filetable.aspx Beyond Relational– FullText indexing with SQL Server FileTable] * [http://msdn.microsoft.com/en-us/data/hh297027 Get Started with SQL Server Developer Tools Codename "Juneau"] * [http://www.microsoft.com/download/en/details.aspx?id=27194 Microsoft SQL Server Connector for Apache Hadoop] * [http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/24/master-data-services-what-s-new-in-sql-server-code-name-denali-ctp3.aspx Master Data Services – What’s New In SQL Server Code Name “Denali” CTP3] * [http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/18/alwayson-new-in-sql-server-code-name-quot-denali-quot-ctp3.aspx AlwaysOn - New in SQL Server Code Name "Denali" CTP3] * [http://support.microsoft.com/kb/2527041 SQL Server 2008 R2 SP1] * [http://support.microsoft.com/kb/2528583 SQL Server 2008 R2 서비스 팩 1에서 수정 된 버그 목록] * [https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/ SQL Server Code Name "Denali" CTP3] * [http://sqlblogcasts.com/blogs/simons/archive/2011/07/12/sql-server-2008-r2-sp1-new-table-hint-options-for-forceseek-and-forecscan.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SimonsSqlServerStuff+%28SimonS+SQL+Server+Stuff%29&utm_content=Google+Reader SQL Server 2008 R2 SP1–new table hint options for FORCESEEK and FORECSCAN]