If I switch from sysindexes to sys.indexes, I have no access to information as to how many rows in the index have been modified since the latest update. I need...

bhanf (5/22/2008)

---

I don't have a primary key between systems, but the code and notuniqueid form a key.

Not sure how to create a linked server (so my answer is no i...

Well, I can say that I really do like SSMS a lot better than Enterprise Manager. However, some things that we got use to have either been removed -...

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...