Lowell (8/10/2009)

---

Adi I read the requirement as he alreyad changed the columns from char to varchar, and now wanted to remove trailing spaces:

Note, the length of the data type should...

If you want that your code will continue to run in case of a runtime error instead of getting to the catch block, you’ll have to delete the catch...

You can run the select statement bellow that will produce the alter table statements for you. Notice that this will do only part of the job. For example...

I don’t think that you can use contains to get the same information that you got on your other query that used the like operator. The main problem is...

This changes the picture completely:-). Express edition doesn’t have DTE as part of the installation. Unfortunately I don’t know about a free tool that does the same...

The database engine tuning advisor is also called DTE and it is installed with the server. You can activate it from management studio. From the menu you have...

Jeff Moden (8/9/2009)

---

Ordinarily, I'd agree with getting the OP to present data in a more readily consumable format according to the link provided above. However, this is Nica's first...

How do you connect eventide to MeasuerID? Is it only by inserting order? Also how did you get the values for EventMeasureID?

Adi

I’m sorry, but I can’t understand your request. Pleas take the time to read the article in my signature. The article explains how to post a question...

You can do it with a comibnation of string functions such as charindex and reverse, but the question is why do you want to do it in the database? ...

You can shrink the file by using the command DBCC shrinkdb or DBCC shrinkfile (You can read about it in BOL). You can also do it with the GUI...

I didn’t know that I can get to an element that is not part of the XML that the nodes method produces. Although I’m not the original poster, this...

If the table is a small table (less then 8 pages), then it is located on shared extent. Shared extent stores pages of few small tables that each one...

It also depends on the place of living. For example in Israel there is a need to store Hebrew characters without using Unicode, so you can find servers that...

As far as I know, there isn’t any DBCC REPAIR_ALLOW_DATA_LOSS command. The REPAIR_ALLOW_DATA_LOSS is one of the possible instructions to the server of what to do in case...