Matt Miller (6/23/2008)

---

My first title sounded a little...

amdavis (6/23/2008)

---

<-- new at sql

I'm trying to run a query on time but my date and time are in the same field.

Example I'm trying to get the rows between 6/22/2008...

Dfalir (6/23/2008)

---

Guys Hi,

I have a table with articleid and article_data as columns. Article_data is a column of ntext(4000) type.

Inside it contains xml code of a page containing articles. I...

I have to disagree with your statement "again". The fact that BIGINT is the datatype does not by any means implies that the values are going to be very different....

@@ROWCOUNT, @@IDENTITY and @@ERROR should be all read at ONCE.

IF you have two rows and no triggers is definitely because you call it twice 😉

The cost shows as 14.7% higher (a clear win), but the page reads and amount of data put through the CPUs is identical. The only difference in the plans...

You will need a "last_updated" column on all your tables. Do you have that ?

You could use TOP and a while loop to control the number of rows updated. No matter what you should be either taking transaction log backups frequently or ensure you...

use:

cast ( field as varchar(max) )

posting what your proc does and some sample tables (and indexes on those tables) could help us help you 😉

TheSQLGuru (6/23/2008)

---

noeld (6/23/2008)

---

TheSQLGuru (6/20/2008)

---

This is being done. The combination of top...

This is funny 🙂

TheSQLGuru (6/20/2008)

---

This is being done. The combination of top 100 and...

dbirchok (5/21/2008)

---

The triggers I talk about are not part of replication. These triggers are put on a replicated table in the subscriber database to do some business logic after...

schwizzla (6/23/2008)

---

An important point to note, if one publications fails with dodgy data then this affects the other Publications if using Shared Distributor! Is this alone a valid case for...