mulder's it blog

SQL서버에서 페이징을 고민 하시는 분들이라면 한번쯤 아래의 포스트를 참조 하기 바랍니다. SQL Server Paging ISSUE.http://www.mssqltips.com/sqlservertip/2696/comparing-performance-for-different-sql-server-paging-methods/ --SQL 2000 Paging Method DECLARE @Start INT DECLARE @End INT SELECT @Start = 14000,@End = 14050 CREATE TABLE #employees (RowNumber INT IDENTITY(1,1), LastName VARCHAR(100),FirstName VARCHAR(100), EmailAddress VARCHAR(..

sqlserver 에서 각 테이블이 어느정도 차지 하고 있는지를 알오보기 ...Get Table and Index storage size in sql serverhttp://stackoverflow.com/questions/15896564/get-table-and-index-storage-size-in-sql-server select * from (SELECT t.NAME AS TableName,p.rows AS RowCounts,SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKBFROM sys.tables ..

sqlserver datetime to string example :) select GETDATE() basedate,convert(varchar, GETDATE(), 1) basestring ,left(convert(varchar, GETDATE(), 1),2) month,right(left(convert(varchar, GETDATE(), 1),5),2) day ,right(convert(varchar, GETDATE(), 1),2) year select GETDATE() basedate,convert(varchar, GETDATE(), 8) basestring ,left(convert(varchar, GETDATE(), 8),2) hour,right(left(convert(varchar, GETDA..

이번에는 URL 로부터 리턴 텍스트를 구한다. (HTML) SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:mulder -- Create date: -- Description:URL Tester -- OLE Automation in SQLServer -- http://forums.asp.net/t/1425747.aspx -- pre-work-start -- EXEC sp_configure 'Ole Automation Procedures'; -- sp_configure 'show advanced options', 1; -- RECONFIGURE; -- sp_con..

SQLServe 에서 HTTP GET 호출하는 예제 입니다.급한경우 잘 쓰면 좋을것 같습니다. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:mulder -- Create date: -- Description:URL Tester -- OLE Automation in SQLServer -- http://forums.asp.net/t/1425747.aspx -- pre-work-start -- EXEC sp_configure 'Ole Automation Procedures'; -- sp_configure 'show advanced options', 1; -- RE..