(db_developer) There are a lot of references to T-SQL Split String function (User-Defined function to split string). It takes line with elements enumarated over comma and returns table with these elements in rows (in table with one column). But I spent approximately 2 hours in search and testing of

(Anu Chawla) One of the tasks that every SQL Server database administrator for TEMENOS T24 needs to accomplish is the performance monitoring of database data and log files. Often, a DBA needs to understand the performance of their disk I/O and needs something that can break down the disk I/O request

(Mike Chapple) SQL Server Integration Services (SSIS) allows you to import and export data from SQL Server databases using an easy-to-navigate graphical interface. It replaces the Data Transformation Services (DTS) found in earlier versions of SQL Server.

(Jason Thomas) The MSDN forum has been the inspiration for most of my blogs, but in all those cases, I was sure that I could attain the end result and my blogs were usually a graphical step by step depiction of what needs to be done, so that I could post it as an answer to the question. But this […]

(Arshad Ali) Performance monitoring and optimization is an inseparable part of a DBA’s activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of th

(Anu Chawla) In theory, you should never need to manually check the integrity of your database, because nothing should ever go wrong with the database, the memory, or the I/O subsystems. However, in practice, checking the integrity of your database will give you confidence and ensure that your datab

(Atif Shehzad) I have changed the password of one of my SQL Server logins used for SQL Server Maintenance Plans. Everything was okay until a SQL Server Agent Job responsible for database backups failed. The SQL Server Agent Job was created by the Maintenance Plan Wizard. When I created the maintena

(Marcin Policht) In our most recent articles, we have explained how SQL Server 2008 Integration Services Import and Export Wizard facilitate the transfer of data between an Excel spreadsheet and a table residing in a SQL Server database. The complexity involved in performing this seemingly straightf

If you’ve done any troubleshooting of T-SQL, you know that sooner or later, probably sooner, you’re going to want to take a look at the actual statements you’re dealing with. In extended events we offer an action (See the BOL topic that covers Extended Events Objects for a description of actions) na

(Jason Thomas) Ok, this post is dedicated to all those zillion questioners asking how to use embedded images on your report based on a condition. Yet again, I will be making use of my favourite dataset from AdventureWorks – Order Count by Product (people who are following me would understand that th