Articles for SQL

Sql Snippets

good references: http://www.1keydata.com/sql/sqlin.html full text indexing: http://www.kodyaz.com/articles/SQL-Server-Full-Text-Search-Indexing.aspx heaps of awesome scripts, this guy is a genius: http://vyaskn.tripod.com/code.htm Some complicated selection algorithms, unfortunately written f...

Find currently running tsql - current sql requests

Compare two lists for 'same' content

Importing Excel data to SQL insert statements

Ascii art - excel to source code table

If you want to paste an example from excel into your source code - use this

SQL sever recompile all views

Email duplicates

How to find duplicates in sql database

Azure - Creating External Tables

Have troubles creating external tables? Check out these tips...

Find all tables containing column with specified name

SQL Server Recovery Mode

It is best to use SIMPLE because FULL keeps growing the log file

SQL Server Full Text index populating

SQL script to set up a recurring index population.

Searching for tables without an Identity field

SQL statement

Search the database for a certain column

It helps to save time

SQL Server Full Text Search - Quick Setup

The code for setting up fulltext search catalog and index on SQL server using SQL commands.

SQL Server Fulltext Search

How to install SQL Server Fulltext search on an existing SQL Server instance Well after about 4 hours trying to figure this out, I have a solution ... To check if fulltext is already installed go to sql and run this query:select SERVERPROPERTY('IsFullTextInstalled') Download latest installer fo...

How to prevent users seeing all databases in sql server

To prevent users to see other databases you need to: - run this DENY VIEW ANY DATABASE TO public - Remove the user from the db_owner role on the users database. (otherwise you cant set the user as owner on the database) (user -> properies -> user mapping -> database role membership) ...

SQL Backup Scripts

There are a number of ways of running these scripts (in order of easiest to hardest): 1. Maintenance Tasks (uses SQL Agent) - easy GUI for backing up databases, cleaning up backups etc. ** NOT AVAILABLE IN SQL EXPRESS ** 2. SQL Agent Jobs (uses SQL Agent) (if you don't have Maintenance Tasks) all...

SQL Server 2008

1. SQL Server 2008 Database put installation / migration / usage issues here 2. SQL Server 2008 Management Studio For your development machine you do not need to install the full SQL Server 2008 that includes the database engine. You just need the management studio. Installing SQL Server ...

ASP Session State in a SQL database

To install asp sql server session state get the dba to run this on the web server. This is useful when the host starts recycling the app pool every few minutes! Open a command prompt Move to: C:\Windows\Microsoft.NET\Framework\v2.0.50727Run: aspnet_regsql -S dbserverNameOrIP -U dbusername -P p...