Define slightly slow ? Have you benchmarked the performance before and after the migration.

Are you sure the configuration is the same.

In theory a virtual server ( btw which one are...

That's what I meant 😀

It would be nice to get a break from the mundane 9-5 and try something new. Unfortunately most of us can't . I am just happy if I can spend...

A caveat to your above scenario would be a Type 2 SCD which has changed multiple times between the data load.

There is no substitute for doing proper data quality checks during the ETL. While there is a provision to convert to unknown member during processing of the cube and even...

It may not be required to explicitly call a begin tran end tran if there is only one operation being performed. like in a simple CRUD operation.

for example

if your inserting...

General guidelines that apply are :-

Always schema qualify object names

Always list out columns ( not select * , or insert into dbo.tb1 select * from dbo.tb2)

SQL Keywords are in...

Could you post ur code

with cte as (

select 1 as id ,20120101 as dates,123 as username,1 as active union all

select 2,20120102,123,1 union all

select 3,20120103,123,1 union all

select 10,20120104,123,1 union all

select 11,20120105,123,1 union all

select...

why are u using a trigger , there is a performance hit for highly transactional tables where the trigger will be fired frequently. Have you considered simply calling single...

Try to avoid using RULES , instead use check constraints.

RULES are going to be Deprecated in future releases

http://msdn.microsoft.com/en-us/library/ms143729.aspx

A Drop down with a max of 30 values is not unreasonable , but I admit its not easy on the eyes.

I am not sure if your confusing a user defined table data type with a table variable . They are two different things.

A table variable can be reused within the...

Gald you found the answer but I am thinking your customers are connecting using sql logins to the database (assuming they are accessing the database from different domains).

I am not...

Did u specify an options when running CHECKDB