I think this is what you are looking for:

DECLARE @d1int = 1,

@v-2 varchar(2);

DECLARE @table1 TABLE

(

idint,

col2varchar(2)

);

DECLARE @table2 TABLE

(

idint,

col2varchar(2)

);

INSERT INTO @table1

VALUES (1,'aa'),(2,'bb'),(3,'d*')

INSERT INTO @table2

VALUES (1,'xx'),(2,'yy'),(3,'zz')

SELECT @v-2 = col2 FROM @table1 WHERE...

You mean 128. Yes, that is correct. Thanks!

To get the number in MB:

value * 8 / 1024

Example:

Selectname,

size*8/1024

from sys.master_files

Everything except for the DB name can be found in sys.database_files. You can get db name with DB_NAME(). The procedure below will get you all this information for every DB...

Beginning with SQL Server 2005, they included the INFORMATION_SCHEMA which is a better way to access this kind of information.

For columns you can use INFORMATION_SCHEMA.COLUMNS which, unlike sys.columns, provides the...

I also concur with Richard Warr's post. Redgate has a great tool for searching databases and the contents of databases (something worth noting, especially on SQLServerCentral.)

If we are talking about searching for tables specifically here then you could use these:

The first one, usp_findColumn_thisDB, takes a parameter and searches all tables with a column matching that...

With a couple very rare exceptions (not relevant for this conversation) I have never had any issues with disabling indexes.

Based on what you've said I cannot see any use for them but I would I would disable them first for a little while to be on the safe side...

Determining the performance impact of removing these unused indexes is important; understanding the impact of leaving them there is also important. In the past 14 years I cannot recall a...

I started with the first few:

Create Sample Data:

CREATE table x(Value varchar(20))

INSERT INTO x VALUES

('a'),

('A'),

('NULL'),

('NULL xxx'),

('113Y'),

('111Y'),

('1')

-- 1. string starts with 3 digit same number Example 111Y,333Y, 555 H etc

-- a....

This is a very interesting quandary indeed. I am sure this can be done using a little less code but here is what I came up with:

SET NOCOUNT ON

GO

/***********************************************************************

1) Create...