分页: 1/311 第一页9101112131415161718192021222324252627... 311下页最后页[ 显示模式: 摘要 | 列表 ]

SSMS Presenter Mode

[ 2017-02-25 14:44:05 | by 店小二03 ]
All About SQL I am a Senior DBA with interest in MS technology especially SQL Server and Azure. ...
Last night I spent hours debugging a situation where a result from DB['select huge_nvarchar from tab ...
Hold my beer. CREATE DATABASE ;GOALTER DATABASE SET PAGE_VERIFY NONE; /* Normally ...
Have you ever done something that your mother told you to never ever do? Well, we’re going to do th ...
Question:I’ve got a sql backup script which completes a backup of all sql server databases on a SQ ...
If you need to find gaps in a sequence (for example, gaps in an ID column, or in a sort order column ...
Constructing a Transact-SQL query is only part of the process - you must also know where to find the ...
By:Siddharth Mehta || Related Tips: Analysis Services Development Problem Data is not alw ...
sqlserver中输入英文语句出现错误时。 在输入表中‘background’的时候出现错误,误以为以为是values时出现 ...
android之存储篇_SQLite数据库_让你彻底学会SQLite的使用,SQLite最大的特点是你可以把各种类型的数据保存到 ...
SQLServer基础——T-SQL语句。 一. SQL-Server基础前言 1. 几大数据库巨头 Microsoft SQL Server ...
经典SQL语句大全。 1, 创建数据库 create database database-name 2, 删除数据库 drop database dbname 3, ...
sqlserver2008r2查找非中文字母数字出现的第一个位置。 环境: 测试数据库sqlserver2008r2,排序规则Chines ...
SQL性能优化。 1、 查两张以上表时,把记录少的放在右边 2、 SELECT子句中避免使用*号 ORACLE在解析的过程中 ...
By:Cate Murray || Related Tips:More Professional Development Career Planning Problem In ...

Apache Zeppelin 0.7 for SQL Server

[ 2017-02-24 19:28:01 | by 店小二05 ]
During the weekend I’ve updated my SQL Server interpreter for the amazing Apache Zeppelin to be co ...
Undetected database errors are insidious. It can be really bad when an error gets dropped on the flo ...

We Hired!

[ 2017-02-24 17:50:01 | by 店小二04 ]
The response to our most recent job position was incredible, and I’d like to thank all of the folks ...
We’ve finally come to my favorite part of analyzing any new software feature: performance testing. ...
步骤1.TempDB压力诊断 等待类型诊断 TempDB的争用压力在等待篇中已经简单介绍,等待的表现为 pagela ...

SQL SERVER 批量生成编号

[ 2017-02-24 15:30:05 | by 店小二04 ]
开始: 在testing中,为了模拟orders,有个要求给数据库dba,如何通过后台数据库脚本快速批量生成orders。 ...
Data Adventures My personal journey in an intricate world of data and continuous effort to mak ...
在SQL Server中,如何用SQL去实现得到一批字符串的全部组合呢?这个是同事在实际需求当中遇到的一个问题,他 ...
By:Dallas Snider || Related Tips:More Application Development Problem I need to write a J ...
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics h ...
分页: 1/311 第一页9101112131415161718192021222324252627... 311下页最后页[ 显示模式: 摘要 | 列表 ]