We recently had an issue where we created all of our log files in a location other than the default location. However, "someone" deleted the actual folder that the...

Roust_m (10/23/2011)

---

jared-709193 (10/19/2011)

---

I still think using sqlpubwiz is the easiest way to do this. It works on 2008R2 (as I've just tested it) and I would run it in a...

Ok. Assuming this is a table for analysis and nothing else we don't split the table. What is zid? Is this a unique id from the main system? ...

So this is only 27 days worth of data? Is that correct? When you say that it grows by 100000 each day, does that mean the main system takes on...

I'm sorry, I don't understand. How many rows are currently in the table? How do these 100,000 rows get inserted into SQL currently (I assume by some of the...

I am assuming that the goal of this is for analysis only. It is not to be used as a transactional database? If so, don't spend so much time...

Yes, well you can't properly analyze data efficiently in multiple ways with simply a table. Mind you, the proper indexes and query optimization will speed it up... but it...

Please go to each table and generate a CREATE script for each one and place the script here. Please also place the script for the compare/insert script.

Thanks,

Jared

How exactly are you going to be presenting your data? For example, if you are looking year over year then you may want to partition on year, not month. ...

Tracing is good, but in my experience you also need to set a cutoff for people. Especially if these databases are running 2 different applications and one is "supposed"...

anthony.green (10/20/2011)

---

please correct me if i am wrong on this sql guru's

when a row is deleted it is actually marked for deletion, then the internal clean up tasks comes along...

Awesome! FYI... I tested the CAST vs CONVERT. Use CONVERT for each one to increase performance over the CAST. So:

ROUND(CONVERT(FLOAT,ColumnName),2)

🙂

Jared

More specifically like this:

USE [EAF]

select

WSHHeatNumberID,

Grade,

Round(CAST(Carbon AS FLOAT),2) AS C,

Round(CAST(Nickel AS...

I'm sorry... Maybe you misunderstand. CAST vs CONVERT would only be for performance.

Do this:

SELECT ROUND(CAST(ColumnName AS FLOAT),2) FROM Table

Thanks,

Jared

However, my first guess is that you are trying to round a varchar. Imagine trying to do this:

SELECT ROUND('jared')

I wouldn't do ROUND until your final calculation. However, for the...