T-SQL, SQL Administration and SSRS Articles Link List – March 2011

Here’s a quick wrap up of the articles published on SQLServerCurry.com in the month of March 2011

SQL Server Administration Articles

Repair SQL Server Database marked as Suspect or Corrupted - There can be many reasons for a SQL Server database to go in a suspect mode when you connect to it - such as the device going offline, unavailability of database files, improper shutdown etc. This post shows how to resolve this issue.

SQL Server: SSMS 2008 Intellisense Stops Working after Installing VS 2010 SP1 - After installing VS 2010 SP1, Intellisense stopped working in SQL Server Management Studio SSMS 2008 and R2 databases. This post has some solutions.

SQL Server: Identify Memory and Performance Issues in T-SQL Queries and Fix them - Sometimes you may notice that some T-SQL queries are taking too much time to execute and thus slowing down the performance of SQL Server and other applications. You can find and rectify these queries using the methods shown in this post.

SQL Server: Move Table to a new File Group - This article shows why and how to move a SQL Server Table from one File group to another.

SQL Server: Delete Backup History to reduce MSDB database size – This article demonstrates the use of the sp_delete_backuphistory database engine stored procedure which makes it very simple to delete backup history that is older than the specified date.

T-SQL Articles

SQL Server: Search Non Round Numbers - Here’s a simple query that searches all non round numbers from a table. The following are non-round numbers 20.00, 24.0 and the following are round numbers 20.20, 24.42 and so on.

SQL Server: Combine Multiple Rows Into One Column with CSV output - In response to one of my posts on Combining Multiple Rows Into One Row, SQLServerCurry.com reader “Pramod Kasi” asked a question – How to Combine Multiple Rows Into One Column with CSV (Comma Separated) output. This post explains how to do so.

SQL Server: Insert Date and Time in Separate Columns - If there is a need to store date and times values in separate columns, you can store Date values in the Datetime column and Time values in either the char datatype or the time datatype (Sql Server 2008), as shown in this post

SQL Server: Group By Days and Create Categories - In this post, we will see how to Group records by Days in SQL Server and then create categories.

SQL Server: Return Boolean from Stored Procedure - Sometimes you may need to return a Boolean value from a SQL Server stored procedure. This article explains how to do so.

SQL Server: Handle Delimited String passed as a Parameter to Stored Procedure - In your application, you may need to pass multiple values as a parameter to a stored procedure. This article shows how to pass delimited values to the procedure and get data

SQL Server: Count based on Condition - Many a times, you may want to do a count in SQL Server, based on a condition. The easiest way is to use a combination of SUM and CASE as shown in this article

SQL Server Reporting Services (SSRS) Articles

SQL Server Reporting Services Tutorial: Designing a Basic Report using SSRS 2008 and VS 2008 BI Studio - In this article, we will see how to create a basic SSRS developer report using Visual Studio 2008 BI Studio. We will create a simple drill down report which will contain a total and subtotal. We will also analyze the options for reports in Visual Studio 2008.

Design Parameterized Report using SSRS 2008 - In this article, we will see how to create a SSRS report with parameters. We will create the parameters and then add these parameters to our reports, in different ways. For this demonstration, we will use SQL Server 2008 database ‘AdventureWorks’ for designing the report as well as parameters.

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook