There is not big difference between 2005 and 2008, however there is very huge difference between 2000 and 2005.

Besides, 2008 is still very raw. So learning 2005 is good enough...

For me, goals for this year would be learning and improving my skills in:

1. BI

2. Replication

3. C#

4. CLR procedures.

Besides, finish the migration of company legacy databases (19 in total) to...

I have seen even longer lists, but it does not mean that they want them ALL. Put Or between the lines, not AND.

If you posess about 7 out of...

Many companies have too loose definitions for DBA role. I've been on some interviews where all they wanted from a "DBA" is to write stored procedures and stuff like that....

I checked in our system ecid is always returning 0. What is CreateDate, is it date and time when your script is runnning every 10 min ? If so, it...

Maybe this:

select

name,

create_date,

modify_date

from sys.views

will help you to figure out what has happened to the view

Did you update statistics on all tables / indexes after migration ?

I did not quite understand "...in which transaction...", but SQL Srever default isolation level is READ COMMITED.

Answering your second question: They renamed bookmarks to joins in 2005, but essensially it's same thing.

About your execution time: did you compare the number of records, availability if indexes,...

Thanks for your inputs.

This is really odd. I tried to run both CONTAINS and CONTAINSTABLE, it took the same 45 sec. But after I cleaned my buffer cache with DBCC...

Try this:

SELECT *

FROM your_table

TABLESAMPLE SYSTEM (1 PERCENT) ;

Get execution plan for each of them. Compare them. If execution plans are very different, check when statistic was last updated for all indexes for all these tables. If not...

Yes, I am also trying to create a dynamic function, but how to return the value from dynamic execution to a variable which is "non-dynamic", declared in the functiuon, not...

Thanks Grant, this is smart trick.

Put batch separator GO after dropping the second temp table, it ensures that the temp tables are dropped prior to executing your DML statements.

If you don't separate them, they are...