Ramy,

The full range of skills needed to become a proficient Senior DBA do not appear in any book that I have read so far.

The basic skills you should have been taught during your BSc. Refine...

Ramy,

Without being facecious -
1) Remember you NEVER STOP LEARNING!
2) Buy Books on the subject and on the tools you are using. READ them all from cover to cover. Make notes in the margins and...

I am making an assumption or two here, such as LOGID, your primary key, is an IDENTITY column or similar, so try this


SELECT e.logid, e.eventid, e.description, e.logtime,
l.logid, l.eventid,...

You have two options, both explained in books on line.
1) UPGRADE the server. This will upgrade your server from 2000 to 2005. It is a one way move and the whole server is changed. There is no...

Ramy,

What you have described is CLIENT / SERVER architecture. Distributed Database Program Development "sounds" like something else.

Sarah,

Please could you expand your definition of...

I think that it needs to be pointed out here that the MASTER database should NEVER be used to hold user entities. Niether sould ANY of the other SYSTEM databases (MSDB, TEMPDB).

MS often changes...

Ramy,

I tried this and it does not run.

You cannot just concatonate local variables and literals and expect them to combine into another literal.

The best that you could do is to set a char...

I can see why there is confusion about what you want from your data and precisely what is in the tables.

Possibly a different way of looking at the data could be -

SELECT...

You might like to have a look at MSSQLs MAKEWEBTASK function. Using this you can create the whole MySQL insert code for each table. It could save you the bother of having to reprocess the data from...

XML has a huge overhead in the textual naming of the entities. Also it is not meant to be humad readable, it is a transport medium. Store the data in a database, the DB overheads will be trivial...

And have a word with the company solicitor with regard to prosecuting the previous database manager under the computer misuse act.

From a SQL client point of view there is very little difference.
The management side is completely changed. The Data Transformation Service (DTS) system has been replaces by the SQL System...

tuukie,
The syntax for the update statement is incorrect. Have a look in BOL to find the correct statement syntax.
You have the right idea with the [DB_Name].[dbo].table_name. I have used this...

RamyMahrous' solution doesn't work. Use this instead. select min(s.column) from (SELECT TOP 3 (column) FROM table ORDER BY column desc) s

There are a number of areas to look at here.
1) Check the execution time of the SQL code in a query window. If the time is large look at providing indexes to speed up the query.

2) When you have...

Hmoner,

OK,

Back to basics.

You need to split the code I gave you down to its component parts.

First try this section

Well you are going to have fun with this one.
1) Only use NOT NULL when there MUST be an entry in a field. People are not yet forced to have email addresses, even in the USA.

2) You don't need a...

In cases like this I find that having a look at the SQL code generated for the table will often turn up some remarkable facts about the table / column in question.

To get this code go into...

Views work VERY well in MS SQL and can do some very detailed and complex discrimination and manipulation. Have a good look at Books-On-Line and play with them for a while.

Sounds like work for a stored procedure.
The problem being that the easiest way to do this is to have a sub-query select the documents grouped on the parentfolder and documentnumber, and use a 'TOP...

This query depends upon the format that the time is stored in. MS SQL doesn't have a TIME data type.The DATETIME format can store both dates and times (obviously). The next point is that you cannot...

Well where to start.
Your query may work but it is dificult to check without all of the other stuff around it (tables, data, stuff like that).

To check the code I expanded it to use a UNION ALL...