A google like search

A conceptual proof for a google like search procedure

Total Database Information At Your Fingertips Part - II

This article will help to get some basic information from your databases that may help you in different situations.

Table variable vs temp table

Temporary Tables in SQL Server

Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil Factor for advice, thinking that it would be a simple explanation.

How to use temporary table in function

See a short and dirty example how to use temporary table in user defined function (UDF).

insert into temp table

Introduction to Common Table Expressions

Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.

Comparing Table Variables with Temporary Tables

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.

SSIS and Stored procedures using temp tables

SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.

search every database on server from a single sp

i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works