The first creates a primary key, the second creates a unique clustered index. They're two different structures. Mostly SQL uses them in a similar way, but there are places where...

T.Ashish (6/18/2013)

---

I want to do this because when I check performance of a query and I need to run it again and again, I can't clean everything, because I'm not...

Please tell me I'm reading that last post from the OP wrong.

http://www.sqlservercentral.com/Forums/Topic1464172-391-1.aspx

Profiler, Extended events, plan cache. Many ways to get the queries without needing to see the...

Please post table definitions, index definitions and execution plan.

You can start by removing the nolock hints, not because removing them will improve performance, but because removing them will remove the...

I seem to recall saying not to do that. Often in this kind...

As I said, setting offline is completely the wrong solution. DO NOT try to take the DB offline, detach it or to restart SQL server.

What other messages are there in...

Please don't cross post. It just wastes people's time and fragments replies

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1464819-392-1.aspx

😀

Typically the cause for something like this is non-space whitespace characters. There are a few ascii characters that don't show, but aren't spaces. CR and LF are two that immediately...

Either the database was switched to simple recovery or the log was truncated explicitly (which isn't possible on SQL 2008) or the database was reverted to a snapshot. That's about...

And the exact error you're getting is???

p.s. truncating the log is the incorrect approach. Shrinking the log is the incorrect approach. Setting the database offline is the incorrect approach and...

Details of recovery models:

http://www.sqlservercentral.com/articles/Administration/75461/

http://www.sqlservercentral.com/articles/Recovery+Model/89664/

Someone's run a switch to simple recovery and back to full since the last full/diff backup. It'll be logged in the error log.

p.s. Are you sure you want those DBs...

LTRIM and RTRIM remove spaces. If they're not removing your non-printable characters, then they're not spaced. Identify what they are (use the ASCII command) and then use REPLACE or LEFT...

Depends what you want to...