You could try a tool such as LogExplorer

http://www.lumigent.com

Also, you could try DBCC LOG to look at the information but as of yet I have not found the details of understanding...

Try DBCC CHECKDB and DBCC CHECKTABLE. Also, try a DBCC DBREINDEX on all the tables to see if may correct. Then do DBCC UPDATEUSAGE and sp_updatestats. Make sure you have...

COuld be a number of things. However, Watson should generate a dump you can look over to see if anything jumps out at you. Also, make sure you look in...

Based on the example Greg put together also try this and compare the execution plans and runtimes to see if there is a difference. Had no idea what you indexes...

Actually unless you want to start at 0 change

select count(*)

to

select count(*) + 1

I agree, only when absolutely needed for a specific reason do. But for the most part try to keep control of the environment and it's quality by only having one...

I have not seen any patches for SQL on Windows Update. That is for Windows OS related updates only. I would do as Don suggest and subscribe to their security...

However you did state this is a devleopement server. So as long as there is nothing mission critical or matter if they mess up then I would say it would...

I understand your issue and have seen many times. You should avoid using views to create views with a deep level as you will take performance hits in many cases.

...

Please read.

http://dictionary.reference.com/search?q=byte

Ok just to add a little more. I found what I was looking for. Unicode is based on the 8bit byte, and is a MBCS (MultiByte Character Set). So...

Thanks Simon, I beleive the answer COALESCE may or may not utilize an index depending on the scenario of involved.

If against multiple values (column or data) compared to a single...

Are are you working in a mixed environment? (SQL7 and 2000)

Also, try the last SP you installed on that machine.

Finally other than scripting the DB is there anything in the...

FIrst, hom much data are you talking abou and is their a primary or unique clustered index on the table? There are a lot of ways to mimic it but...

If you will not be using any of the characters outside the defined 256 use a varchar, char or other non-unicode datatype. If they will then use a unicode type...

How is your network connection to the other server defined in Client Network utility. Make sure to use TCP/IP to make the connection as has fewer overall issues.

Found this...