(Steve Jones) This is the third part in the Beginners series and will start the look at security. This is a basic introduction to people in how they connect to SQL Server and what issues they might have. It’s a lot of common items that DBAs and developers take for granted, but which administrators m
Tag: sql server
Using the Table Data Type in SQL Server 2000
(Mike Gunderloy) SQL Server 2000 has hundreds of advances over SQL Server 7.0. Though it’s been out for a few years now, developers can be pardoned if they still haven’t found time to dig into all of the changed areas; there are just so many of them, and we’ve all got work to do. But it’s worth find
Reading BLOBs from SQL Server and display it in a Windows Form PictureBox
It’s common for modern databases to contain large binary objects, more commonly referred to as BLOB’s (Binary Large Objects). BLOBs are typically graphical images such as photos contained in .bmp, .jpg or .tif files. Although the database is fully capable of storing BLOB data, the potential size of
Understanding Hash Joins
The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so that the smaller of the two inputs is the build input. Hash joins are used for many types of set-matching operations: inner join; left, right, and full outer join; left and right semi-join; i
Implement User-defined Functions in SQL Server 2005 with Managed Code
(Thiru Thangarathinam) One of the excellent features of SQL Server 2005 is its integration with the .NET common language runtime (CLR), which extends SQL Server’s capability in several important ways. The integration enables developers to create database objects such as stored procedures, user-defin
SQL Server 2005 Part 1 Introduction
(Marcin Policht) SQL Server 2000 will be soon reaching its five-year mark, which in terms of software life-cycle translates into fairly advanced maturity. While this is still far from retirement age, the name of its successor, SQL Server 2005, suggests that it might be time for you to start looking
Auditing with SQL Profiler
(Brian Kelley) The first time I touched SQL Profiler was to find out what long running queries were hammering a particular database. That was the moment I fell in love with this tool. I’ve used it to find stored procedure recompiles, infinite program loops on the client-side, and other performance n
Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
(Arun Marathe) This paper explains how batches are cached and reused in SQL Server 2005, and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations.
Migrating from Microsoft SQL Server 2000 Analysis Services to SQL Server 2005 Beta 2 Analysis Services
(Richard Tkachuk) Analysis Services 2005 introduces some powerful new concepts: the UDM, a simpler calculation model and many new features. In most cases, cubes designed with Analysis Services 2000 can be easily migrated to Analysis Services 2005 with little or no manual intervention. This document
The ultimate guide to the datetime datatypes
(Tibor Karaszi) The purpose of this article is to explain how the datetime datatypes work in SQL Server, including common pitfalls and general recommendations.