Update
- Cumulative Update #8 for SQL Server 2008 SP3 is available
http://blog.sqlblog.com/blogs/aaron_bertrand/archive/2012/11/19/cumulative-update-8-for-sql-server-2008-sp3-is-available.aspx
SQL
- SQL Server: Indexes List With Key and Involved Columns Name Alongwith Usage Statistics
http://connectsql.blogspot.kr/2012/11/sql-server-indexes-list-with-key-and.html
컬럼 포함 인덱스 통계사용정보를 보여주는 Script - SQL Server 2012 | Temp Tables are created with negative Object IDs
SQL2012에서부터 temp tables의 objectid 값이 0보다 작게 나오며, 내부적으로 사용하는 알고리즘이 변경되어 있다고 하네요. Object_id 함수 결과값이 IS NULL로 구문 변경 필요.
- Introducing the SQL Server Plan Cache (and a Better sp_Blitz™)
http://www.brentozar.com/archive/2012/11/introducing-the-sql-server-plan-cache-and-a-better-sp_blitz/
플랜캐쉬 역할 및 분석하는 30분짜리 비디오 자료입니다. - 파일 접근 권한으로 인한 DB복원 실패 작업 해결하기(강성욱 MVP)
http://sqlmvp.kr/140173091948 - Automatically Retry A SQL Server Job After A Failed Step
http://www.sql-server-performance.com/2012/automatically-retry-a-sql-server-job-after-a-failed-step/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SQLServerPerformance+%28Latest+SQL-Server-Performance.com+Updates%29 - 5 Reasons You Must Start Capturing Baseline Data
http://www.sqlservercentral.com/articles/baselines/94657/
- SQL SERVER – Removing Leading Zeros From Column in Table
http://blog.sqlauthority.com/2012/11/19/sql-server-removing-leading-zeros-from-column-in-table/
0 문자 제거
SELECT
SUBSTRING(Col1, PATINDEX('%[^0 ]%', Col1 + ' '), LEN(Col1))
FROM Table1
GO
- SQL Server 2012 Integration Services - Implementing Package Security using Access Control
http://www.databasejournal.com/features/mssql/ssis-2012-implementing-package-security-using-access-control.html
- Create SQL Server Analysis Services Partitions using AMO
http://www.mssqltips.com/sqlservertip/2796/create-sql-server-analysis-services-partitions-using-amo/
- Understanding the SQL Server 2012 BI Semantic Model (BISM)
http://www.mssqltips.com/sqlservertip/2818/understanding-the-sql-server-2012-bi-semantic-model-bism/
'SQLTAG Daily Links' 카테고리의 다른 글
2012.11.22 (0) | 2012.11.22 |
---|---|
2012.11.21 (0) | 2012.11.21 |
2012.11.19 (0) | 2012.11.19 |
2012.11.16 (0) | 2012.11.16 |
2012.11.12 두번째 (0) | 2012.11.15 |