自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(3)
  • 资源 (10)
  • 收藏
  • 关注

转载 在SQL Server中使用Hints测试索引(Using Hints To Test Indexes in SQL Server)

通过使用Hints语句强行指定查询使用指定索引来测试索引的性能 语法: select * from table with (index(idx_a)) select * from table with (index(idx_b)) 通过查看执行计划就可以比较idx_a和idx_b两个索引的效率

2010-06-29 13:57:00 876

原创 在Windows2008的Windows防火墙(Firewall)中配置SQL Server2008

If you installed SQL Server using its default instance thengo A else please follow B.A.1. In Win2008 FireWall, right click Inbound and click NewRule. 2. select rule and chose Port and click next. 3. Select TCP and input 1433 in port textbox and click next4

2010-06-29 12:46:00 1713

原创 SQL Server中有关登录信息的系统表

<br />--login user信息<br />select * from syslogins<br />--存储增强密码认证信息<br />select * from sys.Sql_logins<br />--SQL Server服务的角色信息<br />EXEC sp_helpsrvrolemember 'sysadmin'<br />--数据库的角色信息<br />exec sp_helprolemember 'db_datareader'<br />--从Server级别列出所有的登录信息,包

2010-06-13 10:31:00 1515

关于SQL注入的资料-3

关于SQL注入的资料-3,讲解常见的sql注入攻击及其防范

2009-05-08

关于SQL注入的资料-2

关于SQL注入的资料-2,讲述sql注入高级技巧

2009-05-08

关于SQL注入的资料-1

关于SQL注入的资料-1,讲述如何通过sql注入操纵SQL Server

2009-05-08

一个Windows界面的TableDiff表比较工具

一个Windows界面的TableDiff表比较工具,可比较表记录差异

2009-04-16

SQL Server DBA best practice

SQL Server DBA best practice by EMC2

2009-04-14

SQL Server 执行计划详解

SQL Server 2005 执行计划详解

2009-04-10

戏说面向对象程序设计C#版.pdf

戏说面向对象程序设计C#版,语言幽默风趣很适合初学者入门面向对象编程。

2009-04-03

SQL Server2005微软认证教材

MCTS Self-Paced Training Kit (Exam 70-431) - Microsoft SQL Server 2005 Implementation and Maintenance

2009-04-03

C# 多线程编程 详解

This book provides an introduction to writing concurrent programs with “threads”. A threads facility allows you to write programs with multiple simultaneous points of execution, synchronizing through shared memory. The paper describes the basic thread and synchronization primitives, then for each primitive provides a tutorial on how to use it. The tutorial sections provide advice on the best ways to use the primitives, give warnings about what can go wrong and offer hints about how to avoid these pitfalls. The paper is aimed at experienced programmers who want to acquire practical expertise in writing concurrent programs. The programming language used is C#, but most of the tutorial applies equally well to other languages with thread support, such as Java.

2009-04-03

C# 技术面试 宝典

C# 技术面试 宝典 What methods are fired during the page load? Init () When the page is instantiated, Load() - when the page is loaded into server memory,PreRender () - the brief moment before the page is displayed to the user as HTML, Unload() - when page finishes loading.

2009-04-03

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除