May 2011 – NetTrax.Net

23 Nov, 2024

Latest News

5 Ways to Spring Clean Your Security

Type conversion in expression CONVERT_IMPLICIT may affect “SeekPlan” in query plan choice.

Insert if missing, example of joining tables to exclude duplicates.

PDF viewer window caption

Datalogic Devices on Windows 10 and issues with Windows Mobile Device Center (WMDC) 6.1

SQLCMD: MS SQL Server’s Command Line Interface

2011-05-262020-06-15 Brad Arnold

I know what your thinking. Why in the world would I want to manipulate the complex workings of MS SQL Server using the archaic command line? Before today I would have been thinking that right […]

SQL Server Linked Server

2011-05-252020-06-15 Brad Arnold

Often you need to access data on a server that lives on a separate server. Fortunately SQL Server lets you create a Linked Server to join Server A to Server B. Once linked you can query against the […]