What do you mean? What blank spaces where?

What precisely do you mean by "columns with space"?

Columns with lots of nulls?

Columns with lots of empty strings?

Columns that have varchar/nvarchar with leading/trailing spaces?

Something else?

If that's clearly explained, I don't want to see what you call a 'brief summary' ;-)....

This is a difficult one and, to be honest, I'm not overly fond of either.

The first, often called Entity-Attribute-Value is not a particularly good design most of the time. It's...

Why not?

Itanium, because someone at Redgate won the lottery. 😉

If they are automatically created statistics then, virtually by definition, they are not...

Good thing that you're not running SQL 2000 (at least I assume you're not) or that could have done nasty things to the database. If you are using SQL 2000,...

Can you save the plan as a .sqlplan file? While I can read the xml, it's tedious.

Are there more rows that have type=4 than for the others?

Does an UPDATE...

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

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

Not quite sure I understand your question. You can use profiler to see what a stats update job is running and how long the various steps take.

Wait just a sec. An nvarchar column with a date in it? Why nvarchar and not datetime? If it's a date,...

SQL 2005/2008

IF EXISTS (SELECT 1 FROM sys.databases WHERE name = <database name>)

-- database exists

SQL 2000

IF EXISTS (SELECT 1 FROM sysdatabases WHERE name = <database name>)

-- database...

Depends.

Do you just want a copy of the database on the dev box? If so, just the full's fine. If you want the opy on the dev box to reflect...