bhanf (5/21/2008)

---

I have 2 sql servers (TBServer1 and TBServer2) running and I need to update one database that is on TBServer2 with data on TBServer1

[StateLouisianaOld] is on TBServer1

[StateLouisianaNew] is on...

Yes, it is available and does not need to be turned on. For whatever reason (I have no idea why), it has been changed to:

Ctrl-K-C to comment

Ctrk-K-U to uncomment

Jeff

Because then you can create your own and publish it to your own report server. Or, build a daily process to track growth by table.

And better yet, if you...

You can avoid the cursor and the call to sp_spaceused using the following (stolen 😉 from the standard report 'Disk Usage by Table').

;WITH partitionStats

AS (SELECT

ps.object_id,

SUM(CASE

WHEN (ps.index_id < 2) THEN...

Ah - I see, this is one of those cases where I would have to agree that the use of a cursor is warranted. The only way to avoid...

Since all you are doing is running a cursor over the temp table - I cannot see how having any indexes on the temp table would help.

I would be more...

Are you using any temp tables in the stored procedure? That can cause some problems - as well as multiple resultsets.

How large is this table? How many rows/pages?

Small tables will always show a level of fragmentation, and any table with less than 1000 pages is not going to show...

You need to be at version 9.0.3054 at a minimum (there were problems with SP2 and maintenance plans).

Additionally, you need to make sure your client tools have been upgraded to...

Mike Levan (5/20/2008)

---

TableA ( empid , empname )

TableB ( empid, Emprole,EmpSal)

I wan to look up TableA with TAble B, if TableB...

View | Registered Servers

You are looking at the Object Explorer, which only shows servers that you are currently connected to.

Statistics on indexes are automatically created with full scan and will remain that way unless you update statistics with a sampling after the indexes are created.

Well - that is how...

One question you need to consider also is how large is your maintenance window. In other words, how long do you have each night to perform maintenance?

If you have...

From BOL on UPDATE STATISTICS:

UPDATE STATISTICS WITH RESAMPLE updates all the statistics on a table at the current sampling rate. This means that statistics tied to indexes, which are created...

This sounds like a perfect case for using EXCEPT or INTERSECT. Example:

-- Create the tables

CREATE TABLE #temp (a int, b int, c int);

CREATE TABLE #temp1 (a int, b int,...