I am not very clear about multiple users can register a client. Does it mean a client can have multiple users ? What about the control panel -...

The result you needed CustomerNumber, StoreMostUsed. Is the primary store that you want? Otherwise, if the TableB already aggregated from the transaction data, you can just...

You can generate a format file that has the column and its length of the text file. Then you use bulk insert to copy the data from the table...

Was the person a Microsoft employee or just someone worked with Microsoft for a project?

If the person was a Microsoft employee, I was surprised that Microsoft did not have any...

I think remote DBA would be much better solution and I would trust them to do a good job than some internal DBA, at least they would response much faster,...

I had the same problem. I got the same message when I tried to upload the profile picture too.

It is just an idea.

Date_Table (dateid INT IDENTITY(1,1) PK,

DateMMDDYYYY DATETIME,

...

It created a cartesian product. It acted like a multiplication operation.

For example: TableA (ProductID INT), TableB (customer VARCHAR(10)

TableA

ProductID = 1, 2, 3

TableB

Customer = A, B, C

SELECT *

FROM TableA...

Can you explain a little more? I am not sure I understand your problem. What is the problem that you may think you have of keeping track of...

I always work with recruiters. Some I knew for years. Usually they were pretty good, only one recruiter I did not like so far.

He pushed me to accept...

If I knew earlier, I would sue my former employer - a marketing research company. I was basically verbally abused by the DBA and my manager everyday for two...

When you go to interview, you only see a few people. In my current job, my boss lived in Minnesota and the company was in NY, so I only...

I tried the link to do it and it still not working. So instead of using DTS send mail, I had to install xp_smtp_sendmail and used it to send...

I talked to a labor lawyer, unless when your boss talked to you including sexual or racial slur, then you can sue for harassment, otherwise look for a new job.

What...

Usually only table partition is used in data warehouse. It can be vertical or horizontal partition. Most people use vertical partition. Basically it divided the table using one...