Jeff

If the file is being used by another instance, that instance is going to be on the same computer. Are you able to see whether any other instances are...

Agreed, yes, and much has been written about the importance of doing test restores. I still verify my backups as well - after all, there's no point in going...

Best to use sys.sql_modules, since syscomments starts a new row after every 4000 characters (I think) of the definition. ...

Where you have a duplicate, how do you decide which one to throw away? And why do you want to use MERGE? MERGE is used for updating, inserting...

You still haven't shown us what you've tried. But from your required results, it looks as if you need a PIVOT query. If you search for "pivots and...

Sounds like homework to me. What have you tried?

John

Tony

If it's a collation conflict you're suffering from, you can use the COLLATE clause in your query. If the problem is different data types, you can use CAST or...

Please will you post the actual code you're running? If that is it, I would recommend sorting out the typos, syntax errors and undeclared variables before you worry about...

Brandie

Could the second one be from Object Explorer or similar? I think you get the third for linked server queries.

John

Import the XML into a staging table, then the <XMLColumn>.value function to shred it into the individual columns.

John

Chandan

Yes, for simple queries such as the one you posted, that's a good summary. Of course, there are reasons why the query optimizer may not pick the best plan...

Thanks. But the index which is being used is having only 1 column and if the other column is being retrieved internally from clustered index, shouldn't the execution plan show...

A non clustered index consists of the index key column(s) plus the clustered index column(s). That's why your query was covered by the non clustered index.

John

Do what I'd do, and type "xp_cmdshell" into your favourite search engine. If you're not familiar with the command line syntax of whatever zip utility you're using, you'll need...

What do you mean by "allocated memory threshold"? Is it an alert that's generated when a particular process uses more memory than the threshold you set? If so,...