This book takes its readers one level above the existing ones including profes- sional and reference texts and online docs; a majority of these techniques have been implemented successfully in real-world projects involving Oracle and PL/SQL. The aut
For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and
This is our fifth year of producing a book that covers the best articles of the past year. With SQL Server 2005 now on it’s second full year of deployment, the amount of knowledge, tips, and techniques for working with this SQL Server paradigm has g
Once again SQLServerCentral.com had another fantastic year and we decided to reprint some of the best articles, the most popular, and the most read in dead tree format. We wanted to give all our authors a chance to see their names in print as well a
最近服务器执行收缩日志文件大小的job老是报错
我所用的一个批量收缩日志脚本
USE [master]
GO
/****** Object: StoredProcedure [dbo].[ShrinkUser_DATABASESLogFile] scr ipt Date: 01/05/2016 09:52:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[ShrinkUser_DATA