I don't really use DTA, so I cannot comment on that. However, I can tell you that this blog post by Gail Shaw may help you to increase performance...

1. Your format file specifies #bytes, not characters. Since it is nvarchar, you need to double them in your format file.

2. Your row terminator is not "\r", it is...

Rainmaker097 (8/20/2012)

---

I see what you mean thanks. These are config info for several applications and you are right, they don't have to displayed.

But is there any way I can display...

If you are purging more data than you are keeping, and you have a maintenance window... You can move the data that you want to keep to a new table,...

Are you...

Perry Whittle (8/15/2012)

---

as Anthony said above really.

You could also use...

sqlfriends (8/20/2012)

---

Did you try to restore it? That will give you your answer... HINT: Can you restore a backup from 1 instance to a different one even though the backupset...

sqlfriends (8/20/2012)

---

Is it a good practice not to rename existing backup file?

for example I did a full backup of database, later I found out I need to more explicitly name...

Nita Reddy (8/20/2012)

---

I want to upgrade SQL 2005 to SQL 2008 on same server.

Server Name is HYP_Medical.

I installed SQL 2005 using Default Instance name called HYP_Medical 1 year back now...

Lowell (8/20/2012)

---

robert.gerald.taylor (8/20/2012)

---

I've got a schema (Reporting) that I want to grant CREATE, ALTER & DELETE permissions to a group; the T-SQL statements I did are:

GRANT ALTER ON SCHEMA::Reporting TO...

SqlServerTroubleMaker (8/19/2012)

---

Using management studio (10.50.1600 or 10.50.1617.0)

Connecting to named sql server instance (lets call it [DEV-SQL\SqlKing]) version 10.0.4279

--> Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2

New...

Welsh Corgi (8/20/2012)

---

SQLKnowItAll (8/20/2012)

---

Welsh Corgi (8/19/2012)

---

I have a DEV/QA Server with SQL Server 2008 R2 x64 Standard Edition.

I recently upgraded the Production Server from Standard to Enterprise.

When the paperwork was...

Welsh Corgi (8/19/2012)

---

I have a DEV/QA Server with SQL Server 2008 R2 x64 Standard Edition.

I recently upgraded the Production Server from Standard to Enterprise.

When the paperwork was submitted I questioned...

If you don't have the Catalog table in your ReportServer database, something is wrong... Are you sure you are running this on the right server?

guerillaunit (8/16/2012)

---

Hi Kevin,

Is there a reason why you would need to drop the nonclustered indexes after truncating a table and before inserting new data to prevent fragmentation? I am...