分页: 1/317 第一页1234567891011121314151617181920... 317下页最后页[ 显示模式: 摘要 | 列表 ]
During recent SQL Server Performance Tuning Practical Workshop I receive following question aboutQu ...
SqlServer Powershell Cmdlets 2017 - Initialize Look Diving into the Sql Server Management Objects ...
Over last 18 months, I’ve given several SQL Saturday (and a PASS Virtual DBA) presentations on inde ...

IT/Dev Connections 2017

[ 2017-08-15 09:06:01 | by 店小二03 ]
I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in Sa ...
Introduction This is my fourth article about SQL Server system databases. In previous articles of ...

SQL Server vs Oracle: Top [n] rows

[ 2017-08-15 01:07:01 | by 店小二04 ]
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different t ...

SSIS Web Service Task Download WSDL

[ 2017-08-15 01:08:01 | by 店小二05 ]
This short blog shows you where to get the wsdl file for the Web Service Task in SSIS. Once you cre ...
Back in the article How Redgate Helped Define our Process , there was this small blurb about SSD ...
It has been quite a long time since I stopped posting about various SQL downloads available on the i ...

TSQL Tuesday 93: Interviews

[ 2017-08-14 07:27:01 | by 店小二05 ]
This month ‘s event is hosted by the fabulous DBA/SQL-consultant ( part time cartoonist) ...

TSQL Tuesday #93: 2 Job Interviews

[ 2017-08-14 07:28:01 | by 店小二04 ]
T-SQL Tuesday #93 I decided to join the T-SQL Tuesday blog series that Kendra Little is leading ...
One of the challenges with any SQL Server business continuity strategy is backing up your databases ...
一、问题 最近在一个系统的对外接口中,经过测试人员测试,发现登录接口中输入的用户名不区分大小写,经 ...
今早开机发现,打开SQL Server 2008 的 SQL Server Management Studio,输入sa的密码发现,无法登陆数据库? ...
最近突然发现我们部署在数据库上面的告警(Alert),当错误日志里面出现错误时,并不是每个错误日志都会发送 ...
SQL Server执行动态SQL的话,应该如何实现呢?下面就为您介绍SQL Server执行动态SQL两种正确方式,希望可以 ...
1 :普通SQL语句可以用exec执行 Select * from tableName exec('select * from tableName') exec s ...
此文章主要向大家讲述的是非动态SQL ServerSQL语句执行动态查询,在实际操作中我尝试在一个存储过程中,来进 ...
SQL Server 在处理存储过程的时候,为了节省编译时间,是一次编译,多次重用。当第一次运行时代入值产生的执 ...
SQL Server 2005开始,我们可以直接通过CTE来支持递归查询,CTE即公用表表达式 百度百科 公用表表达式(CT ...
一、错误描述 1.群集服务未能使群集服务或应用程序“Alwayson22”完全联机或脱机。一个或多个资源可能处于 ...
很久之前用到的,现在整理在这,里面一些代码来源于网上,不过有些bug已被我修改了。 1.查询结果转XML ...

MSSQL批量插入数据优化详细

[ 2017-08-11 08:45:01 | by 店小二04 ]
需求 现在有一个需求是将10w条数据插入到MSSQL数据库中,表结构如下,你会怎么做,你感觉插入10W条数 ...
一、需求 需求很简单,就是需要查询一个报表,只有1个表,数据量大约60万左右,但是中间有些逻辑。 先说明 ...

分享一个简单的sql注入

[ 2017-08-11 08:47:01 | by 店小二03 ]
所谓SQL注入,就是通过把SQL命令插入到Web表单提交或输入域名或页面请求的查询字符串,最终达到欺骗服务器执 ...
分页: 1/317 第一页1234567891011121314151617181920... 317下页最后页[ 显示模式: 摘要 | 列表 ]