hery2002-CSDN博客

原创 PowerShell：Power Shell 安装

Windows Power Shell是微软提供给系统管理员和IT人员的一个外壳工具和脚本运行环境，可以通过编程实现对系统的自动化管理和操作。 Power Shell最初的代号是Monad，也成为Microsoft Shell （MSH），是参考UNIX的SHELL模式，基于Windows平台下的内建脚本语言以及辅助脚本程式的工具。从2003年的第一个beta版本发布开始，微软不断的更新并完善Po

2015-06-17 15:24:21 1974

转载 T-SQL:zz检查文件夹下的文件大小

原文：Check Up Size Of Each Folder In a Path,版权归原作者. 贴过来备用：USE [DB_Maint]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF OBJECT_ID(N'[dbo].[usp_Folder_Size_Check]') IS NOT NULLBEGIN DROP PROCEDUR

2015-06-11 20:38:11 549

原创 SSRS:报表开发中的一些小技巧

1.文本多行显示的处理方法。参考SSRS: Multiple Ways to Split a String into Multiple Lines (1) 使用VB的换行符 VBCRLF (2)使用ASCII码的转换符 CHR(10) (3)使用HTML的转换符 BR 值得注意的是，在使用HTML转换符时，需要该控件支持HTML属性，设置对应的控件的HTML属性，例子：-- VBCR

2015-06-10 22:44:52 1430

转载 T-SQL：[zz]SQL Server NOLOCK Hint & other poor ideas.

今天逛论坛看到问NOLOCK的问题，搜到MSDN上有一篇比较好的文章，转载到这里。留爪！ SQL Server NOLOCK Hint & other poor ideas

2015-05-29 21:03:08 507

原创 T-SQL: GROUP BY

GROUP BY的用法：GROUP BY (Transact-SQL) -- Declare Table variable.. DECLARE @tbA TABLE ( ID INT NOT NULL IDENTITY(1,1) ,

2015-05-26 11:42:29 1079

原创 SSRS：按月汇总的动态表头实现-Matrix Control

前言: 工具是为实现需求服务的。不同的工具提供了不同的方式，在选择过程中，选择最优最快的实现方式，这是一个成熟的码农必备的技能。本篇参考了CodeProject上的这篇文章：Using SSRS - Matrix Control to Generate Columns Dynamically 场景：SQL Server 2012 AdventureWorks2012 数据库。目的：实现按照用

2015-05-15 12:19:34 1294 1

原创 SSRS：如何消除SSRS报表导出EXCEL出现的合并列和隐藏列

在SSRS报表开发中，经常会遇到报表导出为EXCEL格式的文档。而SSRS导出过程中，由于报表本身设计的问题，导致导出的EXCEL文档中会出现合并列或者隐藏列。本文将介绍几种常见的消除SSRS报表导出EXCEL出现的合并列和隐藏列的方法。文中的方法参考了MSDN的Blog:How to eliminate merged and hidden Cells issue from Excel Export

2015-05-13 20:33:28 3374 1

原创 T-SQL: JOIN的几种关系

SQL Server提供了多种JOIN机制，在联机丛书FROM (Transact-SQL)中列举了四种JOIN操作.1.INNER JOIN（交集） INNER JOIN在数学上是指两个集合的交集，数学符号∩。如下图所示，图中红色部分则为INNER JOIN的结果。例如： {1, 2} ∩ {1, 2} = {1, 2}. {1, 2} ∩ {2,

2015-04-23 00:31:25 1063

原创 T-SQL:取最值的几种方式的简单比较.

通常情况下，都会遇到取最值的情况，T-SQL提供了多种方式实现最值比较，简单罗列几种。 1. NOT EXISTSUSE [AdventureWorks2012];GODBCC FREEPROCCACHE;GOSET STATISTICS PROFILE ON;SET STATISTICS IO ON;SET STATISTICS TIME ON;SELECT DISTINCT

2015-04-19 01:13:11 651

原创 T-SQL:提取第一次出现的数字组合

问题：提取任意字符串中第一次出现的数字组合。USE [AdventureWorks2012];GODECLARE @t_TB TABLE( ColVal VARCHAR(20));INSERT INTO @t_TB VALUES ('ABC123'), ('ENA329'), ('EEE22W33'), ('F1W2C3E8'), ('DDDDDDD'

2015-04-19 00:32:33 543

转载怎么判断某个库中的某张表在某个时间段有没有被使用过

今天逛论坛，遇到一个经常问的问题，怎么判断某个库中的某张表在某个时间段有没有被使用过？记得以前在Aaron Bertrand的Blog上看到过，去翻一翻，找到了转过来.When was my database / table last accessed? 里面提到了几种方法，列举如下： 1.使用SQL Server审计功能，通过审计功能的记录看判断对应的数据库对象的最后访问时间。USE mas

2015-04-18 20:38:36 725

转载学习SQL Server推荐的10本书

今天在sqlmag上闲逛，看到了这篇一年前写的文章，正好在看其中的一本，推荐给大家。原文地址:Top 10 Highly Recommended SQL Server Books.

2015-04-17 23:28:32 19849 3

原创怎样在报表中显示HTML/RTF内容系列之二-将HTML内容存储为RTF格式

首先声明，本系列从本节开始，没有特别说明的情况下均是以SQL Server 2005和Reporting Service 2005为基础展开的讨论。将HTML内容存储为RTF格式，在基于.NET架构下有很多免费和付费控件可以参考，有基于JavaScript编写的，也有基于WinForm下的RichTextBox集成的。如下简单介绍几种常见的Web页面下使用的RichTextBox.1) F

2009-10-21 10:58:00 2243 1

原创怎样在报表中显示HTML/RTF内容系列之一-SSRS 2008中显示HTML内容

怎样在报表中显示HTML/RTF内容系列-SSRS 2008中显示HTML内容SSRS 2008中显示HTML内容? 在一些报表项目中需要使用到对HTML内容的展示,本系列主要阐述SSRS 2005中怎样显示HTML/RTF内容的主要步骤和实现方式。但是对于SSRS 2008已经支持的技术而言，本文将简述针对SSRS 2008对HTML内容的显示，在后续的系列中将重点阐述SSRS 2005

2009-10-15 11:48:00 1592

转载 zz 0ffice 2007 something.....

1.安装 Office 2007时勿输入序列号； 2.安装完成，不要运行 Word、Excell 等任何 Office 程序组件； 3.进入目录：C:/Program Files/Common Files/Microsoft Shared/Office 12/Office Setup Controller/Proof.en；找到此 xml 文件，用记事本打开编辑：将语句中的 AlwaysInst

2009-06-09 00:01:00 716

翻译 Reporting Services 2005 for the DBA – Reporting Services Encryption 2 of 2

Author: Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/08/28/reporting-services-2005-for-the-dba-reporting-services-encryption-2-of-2.aspx This is the second part of my t

2008-05-24 11:42:00 2206

翻译 Reporting Services 2005 for the DBA – Reporting Services Encryption 1 of 2

Author:Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/08/14/reporting-services-2005-for-the-dba-reporting-services-encryption-1-of-2.aspx If you understand how Reporting

2008-05-22 23:47:00 1780 1

翻译 Reporting Services 2005 for the DBA – IIS Security

Author:stevechowleshttp://sqlblogcasts.com/blogs/stevechowles/archive/2007/06/08/reporting-services-2005-for-the-dba-iis-security.aspx This is the second part of my IIS article which today covers II

2008-05-20 21:45:00 1402

翻译 Reporting Services 2005 for the DBA – IIS

Author:stevechowleshttp://sqlblogcasts.com/blogs/stevechowles/archive/2007/06/08/reporting-services-2005-for-the-dba-iis.aspx One of the most misunderstood aspects of Reporting Services is how it fi

2008-05-20 19:52:00 1616

转载 Sarbanes-Oxley compliance checklist: IT security and SQL audits

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312646,00.html?track=NL-416&ad=637013&asrc=EM_NLT_3610732&uid=6118215Michelle Gutzait05.07.2008Problem: My company needs to meet Sar

2008-05-10 09:06:00 2782

转载 Using Reporting Services to Search the SQL Server Log

http://www.sqlservercentral.com/articles/Reporting+Services/62934/By Carolyn Richardson, 2008/05/06 Total article views: 4172 | Views in the last 30 days: 4172 Rate this | Join the discussio

2008-05-10 09:02:00 915

转载 Create DDL table in SQL Server 2005 to audit DDL trigger activity

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312369,00.html?track=NL-417&ad=638703&asrc=EM_NLT_3593059&uid=6118215Robert Sheldon05.05.2008Prior to SQL Server 2005, you could define

2008-05-10 08:59:00 2035

转载 More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions

http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/More-SQL-Server-2005-Solutions.aspx#38351Jeff Smith I previously wrote about a few of the new features in SQL 2005 and how they can be used to s

2008-05-09 12:58:00 1317

转载 Importing Excel data with SQL Server Integration Services and dealing with unicode and non-unicode data issues

http://www.mssqltips.com/tip.asp?tip=1393 SSIS中关于Unicode和Non-Unicode的转换,主要是添加Data Convertion 控件来转换即可,注意CodePage的属性,需要设置启用默认的codepage为True.

2008-05-03 11:11:00 1114

翻译 Reporting Services 2005 for the DBA – Changing Application Pool Identity

http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-changing-application-pool-identity.aspxAuthor:Steve Chowles报表服务DBA系列之应用程序缓存池身份更改 By default

2008-04-29 22:39:00 1328

翻译 Reporting Services 2005 for the DBA – Connectivity Issues

Reporting Services 2005 for the DBA – Connectivity Issues 报表服务之DBA系列 –关于连接 http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-connectivity-issues.a

2008-04-27 22:36:00 1361

翻译 Reporting Services 2005 for the DBA – Double Hop Authentication

By : Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/03/reporting-services-2005-for-the-dba-double-hop-authentication.aspx One of the issues which crop up time and time agai

2008-04-16 00:21:00 2565 2

转载 Concatenating row values in Transact-SQL

http://www.projectdmx.com/tsql/rowconcatenate.aspxBy Umachandar Jayachandran, Linda Wierzbecki, Bruce Margolin, Roy Harvey, Eugene Kogan, Vadim Tropashko, Anub Philip.

2008-04-13 12:07:00 1220

转载 Custom Auto-Generated Sequences with SQL Server

http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-serverBy Jeff SmithThis article by Jeff Smith covers different ways to create sequence numbers. It starts with the basic id

2008-04-13 11:37:00 1267

转载 Find Nth maximum value in SQL Server

http://www.sqlteam.com/article/find-nth-maximum-value-in-sql-serverBy Guest Authors on 11 April 2004 | 13 Comments | Tags: SELECT This aritlce is written by Hariharan Velayuthan. He writes

2008-04-10 21:52:00 1577 2

转载 To SP or not to SP in SQL Server: an argument for stored procedures

http://www.simple-talk.com/sql/t-sql-programming/to-sp-or-not-to-sp-in-sql-server-an-argument-for-stored-procedures/The database-as-API approachBy Adam MachanicThis article is adapted from Ada

2008-04-09 21:10:00 890

转载 How to check Fragmentation on SQL Server 2005

http://blogs.msdn.com/jorgepc/archive/2007/12/09/how-to-check-fragmentation-on-sql-server-2005.aspxAuthor: jorgepc I have been asked this question several times: Is there a tool in SQL Server whe

2008-04-09 21:07:00 1579

转载 Document Sarbanes-Oxley compliance with SQL Server 2005

http://blogs.techrepublic.com.com/datacenter/?p=323&tag=nl.e046 Author: Tim Chapman As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Ox

2008-04-08 21:03:00 787

原创 Batch update table name using sp_rename

扩展存储过程sp_rename的使用方法:sp_rename [ @objname = ] object_name , [ @newname = ] new_name [ , [ @objtype = ] object_type ] USE [DATABASENAME]GODECLARE @i intDECLARE @count intDECLARE

2008-04-08 14:11:00 629

转载 SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained

http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspxSQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explainedThe dust has n

2008-04-02 10:32:00 2395 2

转载 Stored procedures: Find columns and tables

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1109458,00.htmlthe author: Brian Walker is a senior database architect in an IS department that uses SQL Server 2000 and the .NET Framewor

2008-03-28 21:55:00 835

转载 [转贴]How do I find a stored procedure containing ?

http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.htmlI see this question at least once a week. Usually, people are trying to find all the stored procedures that

2008-03-28 21:33:00 870

SSRS: 动态表头的Matrix实现的源代码

EliminateMergedAndHiddenCells

空空如也