Problem Inmy last tip, I showed how to validate and protect yourself from user-supplied input ...
Question: As a .NET web developer, I’ve always used SQL Server as my database store because it ...
Question: I want to share a SQL Server in a hosted environment, for Sharepoint and other softwa ...
Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.co ...
In Previous post we have seen the new features of SQL server 2016 in short and had a brief discus ...
Server 2014 saw the introduction of Natively Compiled Stored Procedures . In 2016 we’ll be a ...
Question: I setup dea_ng and Warden server and deployed simple ASP.NET MVC app to Iron Foundry ...
One of the times that you need things to go right is when you are doing analysis and reporting. T ...
Question: I’m doing research into moving an existing asp.net web site with a sql server back e ...
Earlier last week I wrote a blog around, SQL SERVER – FIX – Msg 3702, Level 16, State 3 – ...
64位操作系统在本地安装oracle数据库的情况下,怎么使用plsql连接远程或者本地的oracle数据 目前plsql只支 ...
Question: I am busy migrating to Azure Virtual Machines. Should my SQL Server database MDFs r ...
ColumnStore Indexeswere first introduced in SQL Server 2012, and this created a new way to store ...

关于tempdb的一些注意事项

[ 2015-06-08 08:36:01 | by 店小二05 ]
由于数据库的文件的位置对于I/O性能如此重要,以至于在创建主数据文件的文职时,需要考虑tempdb性能对系 ...
I spent a lot of my early career working with POS data. The irony of Point of Sale data is it is ...

Training, Your Feedback Is Required

[ 2015-06-07 08:36:02 | by 店小二04 ]
Due to commitments to his startup venture Thomas Kejser has given me full access to his prese ...
有个问题:在执行计划里运算符的估计行数是42,但是你知道查询的正确行数不是42。你也听说了SQL Server使 ...

SQL Server 2016 CTP2

[ 2015-06-06 10:36:01 | by 店小二03 ]
If you haven’t been on a month-long holiday to a secluded island with no access to phone, email ...
Some of the simple learnings can come from unexpected places and this blog post is a classic exam ...
There are a gigantic number of tools out there that are free and extremely helpful. Since I’ve b ...
Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQ ...
Yes! This is month you could learn PowerShell and SQL Server Management Object ( SMO ) techniq ...

Indexing Fact Tables in SQL Server

[ 2015-06-06 08:54:01 | by 店小二03 ]
This article applies only to SQL Server as it is using clustered and nonclustered indices. It doe ...
I got a case recently where the customer had a SQL Alias setup but was having issues connecti ...
In any new release of SQL Server, one of the features that I first explore is the DMV enhancemen ...