Also inaccurate. Three years on, and there is still healthy demand for SQL DBA's and good rates - I'm doing OK at the moment.

Why not add a second virtual machine to the cluster, run an instance of SQL on each, and have the virtual machines normally on opposite nodes. This way both physical...

no worries

Any ideas?

Thanks

GilaMonster (5/5/2008)

---

Because fragmentation has very little meaning on such small tables. Logical fragmentation is defined as the number of out of order pages. With only 1 page in the table...

Hi,

The "non-existant" index name is: tIWB0CONT1

The clustered index name is: IWB0CONT1~0

The table name is: IWB0CONT1

It is the database back-end of a SAP system.

Thanks

If you are getting the message "Another log reader is replicating the database" after you have been trying to mark transactions as replicated, a possible cause is that you have...

What I mean is what happens if a user runs a select query that returns a lot of data - will the data set be completely cached on the SQL...

The variable @PKSQL is not used, so just comment it out. Then the script works OK.

DECLARE @IXSQL NVARCHAR(4000) SET @PKSQL = ''

to

DECLARE @IXSQL NVARCHAR(4000) --SET @PKSQL = ''

Then it works...

thabiso_masina (12/14/2007)

---

Having analyzed your query, see what happens when you run it like this (sorry had to trim it down a bit for readability 🙂 )

SELECT D1.SID_0COMPANY AS SID_0COMPANY

FROM ...

TheSQLGuru (12/12/2007)

---

To the OP: You have spent at least 8 days on this now (posted first on 12/4 - probably worked on it for some time prior to that)....

Antares686 (12/10/2007)

---

Just a thought and I don't know why I didn't bring this up before but when was the last time you defragged the indexes, updated the statistics (sp_updatestats in...

Antares686 (12/10/2007)

---

Go to thinking about this and came up with an idea. The reason why it starts the path thru mdp.[/BIC/DZFIGL_C021] is because it has a fixed list to start...

Christian Buettner (12/6/2007)

---

Hi neil,

could you please try to move the joins to where clauses as follows, I would be interested to see what the optimizer does with that:

SELECT[D1].[SID_0COMPANY] AS [SID_0COMPANY]

FROMmdp.[/BIC/FZFIGL_C02]...