分页: 1/311 第一页891011121314151617181920212223242526... 311下页最后页[ 显示模式: 摘要 | 列表 ]
CREATE OR ALTERis one of the new Transact-Sql DDL statement supported in Sql Server 2016 SP1 . This ...
Continuing my series on SSDTbased deployments, in this part, I’m going to look into something that’ ...
― by Lori Brown @SQLSupahStah I recently ran across a data warehouse that did have the largest tab ...
Tobias Zimmergrenis a 9 year Microsoft MVP and works as a product manager for Rencore cloud offerin ...
By:Ben Snaidero || Related Tips:More Auditing and Compliance Problem Database and data s ...
By:Vitor Montalvao || Related Tips:More SQL Server 2016 Problem On a SQL Server 2016 inst ...
What is the Reason why installing R creates 20 User IDs? If you have installed SQL, you may have ...
What is the difference between COALESCE and ISNULL is one of the frequently asked Microsoft SQL Ser ...

Friday Reading 2017-02-24

[ 2017-02-28 14:39:01 | by 店小二05 ]
I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and adm ...
A very old client of mine yesterday pinged me with this question about error related toQUOTED_IDENT ...
In this puzzle, we’re going to learn how to query the data dictionary using SQL Server. Knowing how ...
By:Aaron Nelson || Related Tips:More SQL Server Agent Problem SQL Server Management Studi ...
You’re using the new One Designer cross-versioning in SQL Server Integration Services, and everyth ...
Problem Two very popular tools we've used for tracking data, logging and configuration changes ar ...
Trace Flag: -1 Function: Sets trace flags for all client connections, rather than for a sin ...
MariaDB ColumnStore is a massively parallel scale out columnar database. Data loading and modificati ...
It is very common for people to move databases now a days to the cloud. The very first question I o ...

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 ...
分页: 1/311 第一页891011121314151617181920212223242526... 311下页最后页[ 显示模式: 摘要 | 列表 ]