(Tom Pullen) In all OLTP environments, virtually all indexes will become fragmented over time. Nearly all UPDATE, INSERT or DELETE activity will cause your indexes to become less well organized than they were when they were first created. There will be more page splits, there will be a greater n

(Vinod Kumar) There are loads of features we can explore in SQL Server 2005. Here is one such feature that I personally would call it as the DBA’s requirement. Here in this article we will take a snapshot to what DDL triggers are and how it can be extended to our needs. DDL Triggers are new in SQL S

(Ramunas Balukonis) In this article I’ll demonstrate how one can learn more about the queries that are sent to analysis services. Every analysis services administrator should know about the table named “QueryLog”. This table contains information about the queries, which are submitted to analysis

(Nirosh) Today, application development paradigm has expanded into many areas. Developers/ architects use many different approaches to keep their phase with the fast moving industry by developing applications rapidly. In all cases, the bottom lines are speed, accuracy, scalability and performanc

(Muthusamy Anantha Kumar) This article examines how to upload multiple files to a SQL Server table. There are many ways to do this. The method I would like to introduce takes advantage of the OSQL.exe utility and the TEXTCOPY.exe utility.

(Rick Dobson) SQL Distributed Management Objects (SQL-DMO) is a set of COM objects that enables the programming of administrative tasks for Microsoft SQL Server. Because SQL-DMO is a collection of COM objects, you can program it by referencing its library and invoking its object’s properties and met

(William Pearson) Most of the measures with which we work in our daily Analysis Services environments are additive, and include various options for easy aggregation, comprised of the ever-familiar SUM, MAX, MIN and COUNT. Most base measures involving transactions, such as sales or direct expenses, a

(Steve Boriotti) Have you ever wanted to publish your organization’s SQL Server data in Exchange so that everyone with Outlook could access it? But perhaps you didn’t have the time or interest to learn how to use Microsoft messaging APIs. The following is an explanation of a suite of extended st

(Srinivas Sampath) In this article we will see how to access a report using its URL and then see an example of embedding a report into a Windows Forms application. I will assume that you are already familiar with using SQL Reporting Services.

(Eli Leiba) SQL Server has several tools for exporting and importing data. The simple utilities like the T-SQL statement BULK INSERT or the BCP utility does the data transfer by using flat text files. In order to deal with any other type of file to be exported or imported we must construct a DTS pac