Or build dynamic SQL. For a case like this (CREATE DATABASE command), I wouldn't worry about any performance issues.

What is the report doing? Can you run Profiler and try to determine if this is a problem with the db engine or SSRS?

If this is important, production data, call PSS at Microsoft.

DO NOT RUN ALLOW_DATA_LOSS as it's behavior is unpredictable and does not necessarily help.

This is a complex issue, and we can't...

The DTA is not bad, but it depends on the workload you run through it. Like any tool, it's examining the queries and making guesses. You want to be sure...

Rudy,

Have to disagree with you there. I think trust is important because it comes from someone being professional in their job. Process and procedures are the same way. There are...

That appears to be the case here as well. I can use indexing to move the tables to new filegroups, but can't move metadata. Can't use DBCC to get things...

EMPTYFILE should work for NDFs, but not sure it works in MDFs. I thought that error'd out because you can't remove an MDF, nor create a 2nd.

Hmmm, guess I need...

Here, here, Scott!

Once you save the maintenance plan, open it again by double clicking it. You will get a "toolbox" in the lower left.

The History Cleanup task deletes meta data in the...

How is it updating? Is it doing a transformation? Is it an Execute SQL task? You haven't really explained how it works.

If it's just using SQL, why not use a...

Don't think the above will move the mdf. Will get the data and objects out, but system tables, metadata, etc. are stuck until you detach/attach.

CAST is not a translater. Meaning if you have a Japanese kanji character in Unicode, SQL Server has no way to CAST that to varchar. You're asking to somehow translate...

You would need some application to query the database and then stream the image data and view it. These are just bits to SQL Server, it has no idea how...

Richard,

Nice editorial and that's a very interesting SQL product. There are lots of interesting applications for a product just like this and I wish Dr. Hipp the best of luck.

It...

You'd need to post more information about what you are doing or what the code is.

There could be any number of problems. If you run Profiler with your login credentials,...