Recently I have been checking all the Dependencies on the Reports in SSRS(Sql server Reporting Services) because of a Major deployment on the ETL. The ETL change was to accomodate the transfer of a few columns from old Table TableA to the new table TableB. Some of the Datasets in the Reports are Stored Procedures [...]
Displaying posts written by
Vivek
who has written 45 posts for Sqlserver007.
Oct
13
2009
13
2009
Oct
6
2009
6
2009
DMV Report for Index Fragmentation and Statistics Update
Recently the ETL load times of my Datawarehouse are increasing and so I decided to check the Indexes status on the tables . I found some fragmentation on the indexes and also some Statistics that are not being updated regularly . I searched online and found this blog by Ben Nevarez(SQL Blog). I decided to [...]
Sep
23
2009
23
2009
Procedure to export text files
Recently I have read a lot of Blog posts on how to export files in different formats. But I use a custom procedure which exports text files in Pipe Delimited format using BCP.This procedure can be used in other processes for Output and Error Handling. Here is the Script for the procedure.You can modify the [...]
Sep
17
2009
17
2009
Reporting Services Date Format
Many Clients have varied Requirements for Dates. You can do the conversions in Date format using T-SQL from the following link in MSDN. In reporting services you can convert datetime using the customs visual basic datetime formats using Expressions. Here are the following links on MSDN for Visual Basic Datetime Formats Predefined DateTime Formats Using [...]
Sep
8
2009
8
2009
Report Server Names for Instances
If the sql server reporting services is configured on the server called “SQLBOX” then the URL is http://SQLbox/reports. If there is a named instance like SQLBOX\VIVEK then the reporting server URL is http://SQLBOX/reports_vivek
Sep
8
2009
8
2009
Problem with SQL Server numeric data : Error converting data type varchar to numeric.
Today I stuck with an interesting problem of converting number data in Varchar fields to numeric datatypes. I have created the following sample data The data in the table contains Decimal and scientific values in varchar format as shown in the figure below. Now when I tried to convert the above values to numeric as [...]
Sep
8
2009
8
2009
Twitter Accounts of BI Experts
Here are the list of Industry BI Experts and their Twitter User accounts http://spreadsheets.google.com/ccc?key=ppfitTGNfaCuf1l9u4Au4JQ
Jun
22
2009
22
2009
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
The Error Occurs when the input is date and the given day values are not in the range of the expected days for a given month(1-31) For eg. You cannot specify the date parameter as Feb 31 2009 since february only has 28 days in a non-Leap year and it throws the above error.
Jun
20
2009
20
2009
Extracting Account Name and Domain from Email using T-SQL
Storing the list of email subscribers is quite often seen in the web based companies. Once the emails are stored they are segmented based on the customer interests and products they have purchased on the website. In this article I will show the simple step of extracting the Account Name and Domain Name using T-sql. [...]
Jun
20
2009
20
2009
Adding Expressions in SSIS – Connection Strings
Expressions are powerful in Integration Services. With Expressions you can dynamically set the servername (based on the environment) or the name of the excel file(if it is a fixed format). Let me give you an example. I have a simple Dataflow task(as shown below) that gets the data from a table and exports it in [...]
