However, still you won't get reliable results on how many space your db allocates. TRUNCATE does not compact the database, so that result is skewed.

Yes, it is possible. However, I doubt that it is adviseable. See if these links help

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/dynamic_sql.html

Maybe I didn't express myself clearly. Consider this:

USE NORTHWIND

DECLARE @unit FLOAT

SELECT

 @unit = UnitPrice * Quantity

FROM

 [Order Details]

SELECT

 @unit

SELECT

 @unit = UnitPrice * Quantity

FROM

 [Order Details]

ORDER BY

 OrderID DESC

SELECT

 @unit

                                                     ...

SELECT

 @ExecCharge = Fee * ABS(Quantity) + ExecChargeAdjustment,

 ExecCharge = @ExecCharge,

 NetBroker = RateBroker * Quantity + @ExecCharge,

FROM

 Trades

Separate them into two operations:

1. SELECT .. here goes all variable assignment

2. Calculation

Also, you haven't specified...

Instead of deleting all/several tables, I would rather script all db objects into one file, run this under a different db name against another server and see what size I...

Dates in SQL Server are a pain.

Really?

Lots of useful ideas you can find here: http://groups.google.de/groups?hl=de&lr=&frame=right&th=71fb677afa372736&seekm=Ouo5SydpEHA.3428%40TK2MSFTNGP11.phx.gbl#link1

Hey, you code might be good, but it is *not* necessary to post it to every single forum here. Most members do follow all fora here anyway.

I guess you have a typo in here and you're asking how to move the data from secondary to primary, right?

Probably the best solution here is

CREATE CLUSTERED INDEX....WITH DROP...

Another oddity!

Till now the column is declared NOT NULL. Change this to NULL and run

CREATE TABLE testcase

(

 MyDecimal DECIMAL(2,0)

)

CREATE INDEX ix_test ON testcase (MyDecimal)

INSERT INTO testcase VALUES(1)

SELECT

 *

FROM

 testcase

WHERE

 CAST(MyDecimal AS DECIMAL(2,0))...

I don't know for sure, but I suspect this number to be more or less randomly chosen. When you look at indid in sysindexes you see, that it's data type...

IF OBJECT_ID('test_indexes') > 0

 DROP TABLE test_indexes

GO

DECLARE @stmt NVARCHAR(4000)

DECLARE @i TINYINT

SET @stmt = 'CREATE TABLE test_indexes(c0 INT PRIMARY KEY'+CHAR(10)

SET @i = 1

WHILE @i <= 249

BEGIN

 SET @stmt = @stmt + ' ,...

Counterquestion: Isn't that enough?

See if this helps: http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/sqlclrguidance.asp

Not to sound offending here, but, as Remi has said, have you thought of buying one?

If you however insist of getting a license...