For the DR site, I'd go with log shipping. If you use HA mirriorring (automatic fail over), and you have a node failure in your cluster, the mirrior will...

The problem here is that we haven't seen the entire execution plan, only what we have been told. Again, the cost is relative to the batch its self, and...

Read BOL (Books Online), it will provide you all the info you are asking.

😎

Just throw them some prok chops!

:w00t:

But this has been a fun and entertaining thread where people have been open, honest, and shown a great deal of humor.

A great distraction from the mundane aspects of work.

😎

Sarvesh Kumar Gupta (3/13/2008)

I have a table there are three columns:

1. Id_Pk

2. Emp_Name

3. Salary

Some Salary fields have Null, Now i want to select table data in such a way that...

I think the threads about Bankers Rounding (I know of two threads on this topic) may be longer.

😎

Here is the output from having STATITISTIC IO ON:

SELECT -

Table 'studemo'. Scan count 1, logical reads 5674, physical reads 2, read-ahead reads 5717, lob logical reads 0, lob physical reads...

Also, remember that the query cost is relative to the batch. The in the faster query, the relative cost is 73%. In the slower batch, the cost you...

Don't think so. If that were the case, the first query when run again should have been quicker. It was consistantly 27 seconds.

Honest, all you wizards out there...

But that doesn't change the PK/FK relationship.

I know, I told the person who told me what our former employer paid, and he was SURPRISED!

Which means in dimensional table, if it is type2, it gets a new set of PK with every update. Thus, comes with the need of remapping the fact table's FK...

We may know it, but some newbies may not...:w00t:

Heck, would you like to know what we paid? I'll PM you if you do.

Not sure this is exactly what you are looking for but it has helped me and my co-worker with developing SSIS packages: Professional SQL Server Integratin Services 2005 (I...