Prashant Mishra
Thursday, June 12, 2014
How to get random dates in a range?
›
DECLARE @D1 DATE = '20000101' DECLARE @D2 DATE = '20141231' ;WITH E00(N) AS (SELECT 1 UNION ALL SELECT 1), E...
Thursday, March 27, 2014
How to empty a SQL Server database transaction log file
›
Sometimes the log file size is more than the db size. In my case, i have 3GB database and 10 GB log files which was occupying all my C driv...
Tuesday, June 25, 2013
Install Samples Database AdventureWorksDW2012 for SQL Server 2012
›
AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced North...
Monday, May 13, 2013
Execution Tree in SSIS
›
Source: http://bidn.com/blogs/KathiKellenberger/sql-server/3097/ssis-transforms-and-execution-trees The majority of the work performac...
Difference between Stored Procedures and Functions
›
Procedure can return zero or n values whereas function can return one value which is mandatory. Procedures can have input/output paramet...
Wednesday, March 6, 2013
Creating SSRS report using SSAS cube data source
›
The creation of an OLAP SSAS report is similar to other SSRS report development once you get to the actual report layout. However, design...
Sunday, February 24, 2013
Report Deployment on Report Server
›
Once the report has been made, next we need to deploy that on the report server. To do so, we need to know the report server name. ...
1 comment:
›
Home
View web version