Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs in getting the list swiftly, they are as follows...

I have shared this code with others in the fourms but I think it is good enough for me to blog. I create a proc that will go through every db on the server or one you sepcify and look through all code object (proc, view, function, etc) for a particular string you give it (@search). This is one of the...

Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required to retrieve a report if the report is large or...

By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain any user related data and schema for these tabls...

Now a days lot of newbie users are posting questions on the SQL Server, which is a good sign that more people wanted to know the SQL Server. But most of them do need a better understanding on SQL Server, so how best you can achieve such knowledge. Certifications in SQL Server are first one to recommend...

During the deployment of new project for an application that is accessed worldwide by one of my client. Ther were looking to implement Full Text Search as well due to the nature of application. For your information SQL-FTS: SQL Server Full Text Search which allows fast and efficient querying when you...