Bajrang (8/2/2013)

---

Hi everyone..

I am getting following error message while adding Clustered Index to my table..

CREATE CLUSTERED INDEX [xIK_Style_ROLLUP_MONTHLYTIMEKEY] ON [dbo].[Style_ROLLUP]

(

[MONTHLYTIMEKEY] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,...

Depending on the type of database, you should probably be monitoring Deadlocks, I/O Wait, CPU Usage, index fragmentation, etc. There are tons of things that you can monitor, it all...

Yes, I'm using temporary tables to grab and record primary keys and I reference those tables for the deletes and inserts. Seems to be working ok. I'm able to do...

mister.magoo (8/1/2013)

---

Are you using a particularly slow system?

Millions of rows shouldn't be a major problem unless those rows are massively wide...for instance, on my PC I can shift 1000000...

NM guys, I got it to work. The import feature is just touchy.

vultar (7/25/2013)

---

Hi,

Getting the log files onto RAID 1, preferably 10 is a must to improve write performance, ideally, 1 file per LUN.

Have you considered trying RAID 1 for the data...

1. Raid 5 Also (which I know is an issue)

2. Yes

Voide is correct, it might be a good idea to research why it's so large.

Copying was an easy way to make a replica of another test database. Because we don't backup every database, if I didn't do a copy, I would have to make...

Lowell (2/15/2013)

---

ok, in that case, it might be that the tempdb is running out of space or something for the import wizards process?

i'd still recommend backup and resotre over the...

Sorry for the confusion, I'm not copying them directly within the server. I am using the SQL Server UI, selecting a database and then running the copy database wizard.

Edit: I...