RSS Feed
Archive for the ‘Database’ Category
RegEx-Based Finding and Replacing of Text in SSMS
February 14th, 2011 
wiseinn
So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about. The Find/Replace feature of SQL [...]
Posted in 
Showplan Operator of the Week – Merge Interval
February 14th, 2011 wiseinn
When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting ways that the series helps to understand how the query optimizer works. With the Merge Interval, Fabiano comes up with some insights about the way that the Query optimizer handles overlapping ranges efficiently. Merge Interval [...]
BIT of a Problem
February 14th, 2011 wiseinn
Once upon a time, long, long time ago, programming languages were tied to the hardware. Obviously, assembly and machine languages were designed for one particular family of computers. But even the higher level languages still clung to the hardware. FORTRAN and COBOL standards were defined on the assumption that files were sequential, main storage was [...]
SQL SERVER 2008 Data Dictionary
February 13th, 2011 wiseinn
This is a comprehensive script for generating data dictionary for your database, shows the tables, columns, descriptions for each table and column as well as the data types of the columns and if columns are PK/FK, Null Allowable, Identity generated as well as the name of foriegn table if column is FK. SELECT [...]
Targeted Index Performance Improvements
February 13th, 2011 wiseinn
Introduction When T-SQL code is run, information about which indexes it uses and how it uses them (i.e. updates, seeks, scans, lookups) is stored. Additionally information about the number of rows affected by the running code is also recorded. Using this information, we can target our performance improvements to those specific indexes, leading to better [...]
Automatically Generate Stored Procedures
February 13th, 2011 wiseinn
Introduction So you have added a number of new tables to your database and you now need to create stored procedures to insert, update, and delete from them. Now, depending on how many tables you have added,this can be a very time consuming task but fear not, as I will show you an automated solution [...]
SSIS: Custom Folder in your Package Store
February 13th, 2011 wiseinn
Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store. I promised to provide the steps in my blog on how to do this. So, here you go. First, open the MsDtsSrvr.ini file, which is stored here by default: C:\Program Files\Microsoft SQL Server\100\DTS\Binn With the [...]
SEQUENCE in SQL Server 2011
February 9th, 2011 wiseinn
By : Dinesh Asanka Jan 05, 2011 SQL Server 2011 (or Denali) has now arrived CTP. In this article I will look at a core new feature of SQL Server 2011 which is SEQUENCE. Well, if you are familiar with Oracle, you will already know all about this feature since it has been standard [...]
Automating SQL Server Management with WMI (part 5)
January 19th, 2011 wiseinn
In this article, I will continue with the topic of performing common SQL server maintenance tasks using Windows Management Instrumentation. In the part 4 of the series, I described methods that allow rebuilding indexes and updating statistics on the table level. These operations can take a considerable amount of processing power and time, in the [...]
Automating SQL Server Management with WMI (part 4)
January 19th, 2011 wiseinn
This fourth article in "SQL Server management with WMI" series provides examples of using WMI in common maintenance tasks, such as truncating the database transaction logs, or updating statistics and rebuilding indexes on database tables. Truncating the database transaction logs removes the inactive portion (containing transactions committed to the database). This typically happens as the [...]
