BTW I am using SQL Server 2005 Standard version.

I did the query on one table .

The result:

index id index_type_desc Alloc_unit index ...

I work for the state government. Everyone's salary is on the state website opening to the public.

Maybe it is good to have the salary going public. Last job...

I am a database developer and my work starts shifting into project management. I am less and less involved in software development. I am afraid sooner or later I...

Manie, I am in the same boat with you. I am a SQL Developer pushing to be a DBA since no company is willing to hire a 'real' SQL...

Emphasis on what you can accomplish than what you can't do.

If something I am not familiar with, I would tell them the truth but I also tell them how quickly...

This is the most ironic thing. Some of the best developers and DBAs did not have a computer science degree. On the other hand some the of worst...

I used to work for companies that had more than 2 production databases and had no DBA. All SQL developers were 'DBA'.

My former employer gave out bonus and it was tied to company performance and my own performance (annual review).

I think that maybe what Jeff meant.

SELECT l.Locationid, l.LocationName,

(SELECT SIGN(COUNT(*))

...

When I design data warehouse, I try to avoid snowflake dimension because it requires an extra join to get the data. Sometimes it is better to de-normalize the database...

I don't trust anyone at work anymore since I had been burnt too many times. I trusted someone and ended up that person stabbed me at the back!!!!

Especially at...

Thanks Phil. It is a big help.

The company that hires contractors just layoff a whole bunch of their own employees. How ironic!!!!

There is a span between fromdate to Todate but I just extract the record where fromdate = todate.

I am trying to figure out how to calculate Sat and Sunday.