Does it matter what order you join tables in an SQL Server query? Not unless you use the command SET FORCEPLAN ON. If you use FORCEPLAN SQL Server will join the tables in the order you specify regardless of Query Optimizer calculations. If you do not specify that you wish to override the query optimizer, by setting FORCEPLAN on, which […]
Other News
SSWUGtv: SQL Server Versions and Migrations
Video Programming for IT Professionals
General facts of SQL SERVER – part 2
General facts of SQL SERVER – Part 2 Three – tier (3 – tier) structural design As soon as one starts executing difficult commercial way outs in a two – tier (2 – tier) structural design, the tier that implements the corporate guidelines turns out to be overloaded. As an outcome, it needs extra period of time to accomplish the...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Setup a Memory Quota for SQL Server Memory Optimized Databases
(Daniel Farina) You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip I will explain how to proceed.
Database Build Automation – The First Step to Continuous Integration
(Grant Fritchey) So you’re keen to take the first steps to the continuous integration of your database. You have to start by getting your database into source control. You can then begin to automate your build processes in order to generate and test a database. By doing this regularly, you’ll be muc
SSRS Issue with Microsoft OLE DB for DB2 v3.0
(Bob Pearson) I ran into a perplexing problem on one of my SSRS servers. This server handled the reporting for internal users, and had a lot of reports that read from our source system, on iSeries DB2 (V6R1), and some reporting from our SQL Server data mart.
WCF Security – How do I restrict user access to methods in WCF?
(Ramani Sandeep) Authentication verifies that a users is who he claims to be. This can be done in a couple of ways: certificates, username/password, windows credentials. Authorization will decide what an authenticated user is allowed to execute.
Software Localization Part 1: Introduction
(Marcus Efraimsson) In this multipart series I will discuss the challenges, difficulties and different strategies of adapting multi-language support in software, mainly targeting an existing product built on the .NET platform. In this first part there will be an introduction to the basic concepts of
More With Arrow Functions in ES6
(K. Scott Allen) In a previous post we took a first look at arrow functions in ES6. This post will demonstrate another feature of arrow functions, as well as some additional scenarios where you might find arrow functions to be useful.
The DB2Night Show #145: db2pd Party with Melanie Stopfer, IBM
(Scott Hayes) 99% of our audience learned something! Who knew that there were so many options for the powerful and popular “db2pd” command? Not only did Melanie share dozens of db2pd command examples and tips, but she also compared and contrasted to various MON_GET function calls and SQL commands.