A Tiny Trauma

Unexpected issue with a hidden calculation on TinyInt

Reclaiming Space After Column Data Type Change

A brief overview of how to reclaim storage space after altering the data type of a column.

IsNull and Coalesce

RE: Need a bit of help

why not    GST =(Sum(Fields!Valuation.Value * 65/100) * 125/1000) 

RE: Problem with delete query across two databases

Is column oid indexed in database 1 ? If so, it might run better as an EXISTS subquery:DELETE FROM database2.dbo.transactions del WHERE EXISTS (SELECT * FROM database1.dbo.transactions TR WHERE del.oid = TR.oid)Also, are there any foreign key constraints that reference the table being deleted from ? That can seriously impact performance if SqlServer has to ensure […]

Maintenance plans

We have Veritas' Backupexec running in our Enterprise and the Veritas Install actually installs MS SQL Server MSDN on each Server in the Enterprise. It looks like it also sets up a default Maintenance plan within each of the MSDN Instances. I guess my question is.. Can I manage the Maintenance Plans on these MSDN […]

Looking for White Paper or resource on Physical Architecture for partitions and such

Machine HP ML57012 * 143 g hd 3 g ram2 xeon 3.0 prOS W2k RAID 5 Need help with how to determine how I partition the space for a data warehouse? Thanks

RE: Select where name has an apostrophe

try itselect * from table1 where name like '%''%'