Table Access Order

Execution plans

Plans

Showplan Operator of the Week – SORT

Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates why it is important to be aware of these operators when getting queries to perform well.

DMVs for Query Plan Metadata

Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits.

Queries, Plans, and Indexes

Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.

Dynamic Management Views

RE: UDF in computed column of Temp table fails

it seems you cannot reference a udf in a computed col from any other database not just tempdb. You would have to create the function in tempdb. i.e - this does not work either:use pubs gocreate function udf_isblank(@n varchar(20) = null, @ret varchar(20)) returns varchar(20)as begindeclare @null int set @null =  case when isnull(@n,'') = […]

RE: Converting Float to decimal(5,1)

The use of float aside, I think there is a problem with your statement.If you are converting numeric(5,1) to float then you will get either an exact value or an approximation with a lot of decimal digits. The problem you stated with 100.1 is not a problem as 100.1 in a numeric(5,1) will be converted […]

RE: DTSRun: Cannot create COM Server to load and execute DTS Package

didn't work.I even tried:master..xp_cmdshell 'DTSRUN /S "MyServer" /E /N "test_dtsrun"'with same results.