sqlbasic.blogspot.com
SQL Server 2005: March 2009
http://sqlbasic.blogspot.com/2009_03_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Wednesday, March 11, 2009. Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can results in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, if you need to perform row-by-row operations. Do not forget to close SQL Server cursor when its result set is not needed. Try to reduce the number of records to process in the cursor.
sqlbasic.blogspot.com
SQL Server 2005: November 2008
http://sqlbasic.blogspot.com/2008_11_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Sunday, November 30, 2008. Click on the text to follow the link to the video, just in case if you find that link is expired please get back to me. How to Replicate Databases in SQL 2005 Servers. Detaching and Attaching a Database in SQL Server 2005 Express. SQL Server Bulk Import Tutorial. How to view a SQL 2005 Error Log. SQL 2005 Reporting Services drilldown. SQL Server Backup Types Explained. Links to this post.
sqlbasic.blogspot.com
SQL Server 2005: September 2009
http://sqlbasic.blogspot.com/2009_09_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Tuesday, September 15, 2009. SSIS Design Pattern - Custom Error Handling. Error logging is crucial to troubleshooting and auditing efforts. If an error occurs in your SSIS package while it is executing production loads, transformations, or transfers; you will want to know as much as possible about it. To demonstrate, create a new SSIS project named ErrorTest:. Always answer this dialog "Yes". Check to be sure the Ex...
sqlbasic.blogspot.com
SQL Server 2005: February 2009
http://sqlbasic.blogspot.com/2009_02_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Monday, February 9, 2009. Stored procedure which were created in last 7days. Following script will provide name of all the stored procedure which were created in last 7 days, they may or may not be modified after that. WHERE type = 'P'. AND DATEDIFF(D,modify date, GETDATE(). Links to this post. To get the row count in a faster way. To get the row count in a faster way , the conventional way would be very slow. Doing...
sqlbasic.blogspot.com
SQL Server 2005: November 2009
http://sqlbasic.blogspot.com/2009_11_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Wednesday, November 4, 2009. Recovery Models and backup. Microsoft, in SQL Server Books Online, defines backups as:. A copy of data that is used to restore and recover data after a system failure. In order to begin working on backups, the business needs define a database recovery model. In essence, a recovery. Defines what you're going to do with the transaction log data. There are three recovery models: Ful. Enough...
sqlbasic.blogspot.com
SQL Server 2005: December 2008
http://sqlbasic.blogspot.com/2008_12_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Saturday, December 20, 2008. SSIS - SQL Server Integration Services. A Preview. SSIS provides data cleansing, extensibility, and interoperability. SSIS comes with a lot of pre-built data-cleansing functionality, including completely integrated functions, such as fuzzy matching and fuzzy grouping, that use algorithms to match or group disparate data to a configurable degree of accuracy. SSIS can also help reduce ETL ...
sqlbasic.blogspot.com
SQL Server 2005: April 2009
http://sqlbasic.blogspot.com/2009_04_01_archive.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Friday, April 24, 2009. SSAS - SQL Server 2005 Analysis Services. Creating a Data Cube. Exploring a Data Cube. Searching for patterns like this and summarizing them is called online analytical processing. Or OLAP. Microsoft SQL Server 2005 includes a separate program called Microsoft SQL Server 2005 Analysis Services to perform OLAP analysis. In this chapter you’ll learn the basics of setting up and us...The basic i...
sqlbasic.blogspot.com
SQL Server 2005: DTS vs SSIS
http://sqlbasic.blogspot.com/2009/09/dts-vs-ssis.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Thursday, September 10, 2009. In today’s blog post, we will give a basic introduction of SSIS (SQL Server Integration Services) and provide a comparison of some of those features with DTS (Data Transformation Services), it’s predecessor. The following steps show how you can launch BIDS:. Go to: Start – All Programs – Microsoft Sql Server 2005 – Business Intelligence Development Studio. B) Data Flows,. B) Data Flow,.
sqlbasic.blogspot.com
SQL Server 2005: Recovery Models and backup
http://sqlbasic.blogspot.com/2009/11/recovery-models-and-backup.html
You see things; and you say 'Why? But I dream things that never were; and I say 'Why not? Wednesday, November 4, 2009. Recovery Models and backup. Microsoft, in SQL Server Books Online, defines backups as:. A copy of data that is used to restore and recover data after a system failure. In order to begin working on backups, the business needs define a database recovery model. In essence, a recovery. Defines what you're going to do with the transaction log data. There are three recovery models: Ful. Enough...