分页: 1/311 第一页1234567891011121314151617181920... 311下页最后页[ 显示模式: 摘要 | 列表 ]
SQLAUTOINCREMENT字段,Auto-increment 会在新记录插入表中时生成一个唯一的数字。 AUTO INCREMENT 字段我们 ...
SQLServer2014远程访问,无法连接问题。今天进行SQL Server2014的安装,按照网上的方法开通权限后和配置IP后 ...
sql语句中where和having的区别。(1)HAVING是先分组再筛选记录,WHERE在聚合前先筛选记录.也就是说作用在GR ...
整理navicat遇到的问题(navicatdesignquery.sql.bak系统找不到指定路径)。 原因: navicat 的每个连接,有个 ...
腾讯云数据库团队:SQLServer数据加密功能解析。数据加密是数据库被破解、物理介质被盗、备份被窃取的最后一 ...
SQL Server is used widely for the management of database. It is possible that the data gets corrupt ...

Schedulers To Rule Them All

[ 2017-03-21 18:46:02 | by 店小二03 ]
Sometimes things just don’t make sense. One of our productionservers has 4×8 (4 sockets, 8 core) ...
This blog post is a short observation on assumptions that Oracle and SQL server optimizers make to e ...
SQL Server数据库实例间迁移Login 1. 流行的方法:T-SQL 老式的方法是,准备好CREATE LOGIN脚本,填 ...

Defending Invoke-SqlCmd

[ 2017-03-19 17:47:01 | by 店小二04 ]
Twitter. It can be annoying, it can be frivolous, but you’d be surprised at how many times it gives ...

Interview Paul Randal

[ 2017-03-19 15:39:02 | by 店小二05 ]
I decided to start a series of blogs where I interview key people in the SQL Server community. Inst ...

Summary of my Container Series

[ 2017-03-19 15:40:04 | by 店小二03 ]
I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and adm ...

Enable Trace Flags in SQL Server

[ 2017-03-19 15:41:01 | by 店小二03 ]
Trace flags are switches that adminstrators or developers can use to change the behavior of SQL Ser ...
Problem The SQL Sever ORDER BY clause is commonly used in T-SQL scripts, if used properly, it can ...
By:Andy Novick || Related Tips:More Stored Procedures Problem After a couple weeks spent e ...
One of my client was unable to modify the maintenance plan using SSMS. When we did various tests, w ...
Yep, I remember deploying a trace flag on a production server for the first time. Trace flag 8048, t ...

The Guru (T-SQL Tuesday #089)

[ 2017-03-18 19:03:01 | by 店小二03 ]
I became a consultant a bit earlier in my career than was probably wise. The going was rough at fir ...
Today I needed to backup a single database table, then test a change to the data, then if the change ...
There is something about high performance tuning that I find very fascinating. Performance tuning yo ...

T-SQL Tuesday #88 WTF

[ 2017-03-18 19:15:01 | by 店小二04 ]
It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan , ...
A financial service software provider needed to upgrade their customer facing applications with a ne ...
Join MariaDB ColumnStore Use Cases Webinar on March 23, 2017 10 a.m. PT Introduction MariaDB ...

GUI or CLI

[ 2017-03-18 19:18:02 | by 店小二05 ]
There’s a debate over on Scott Hanselman’s blog about the GUI v CLI in the comments for his ...
It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted byKennie Nybo ...
分页: 1/311 第一页1234567891011121314151617181920... 311下页最后页[ 显示模式: 摘要 | 列表 ]