Jason-299789 (12/4/2014)

---

IN SQL server if you do a divide an Integer by an integer you get an integer, and a count will only ever produce an integer.

to get round...

manju.ccc (12/4/2014)

---

Hi spaghettidba,

Thanks for your reply.

Ok I got your point.

But I have two servers with same environment.

This problem occurs only a database of one server other one is ok

One...

manju.ccc (12/3/2014)

---

Dear friends,

I have a table which is using merge replication.

So when I update the table by simple update query then i'll take more time.

Then I run same query by...

Sure.

Take a look here for an example.

Unfortunately, it's heavy on CPU and slows things down quite a lot.

Debbie Edwards (12/2/2014)

---

Integration Services.

Hmmmm I shouldnt think its permissions. I have all the right permissions set on all the folders the job needs to access. But I could be wrong....

Both Redgate SQL Compare and VS Schema Compare provide the ability to preserve data in the case where object renaming has taken place.

In the case of SQL Compare, this is...

May I ask what you mean by 'IS' in this:

Could it be a permissions issue?

True, but that does not demonstrate the 30 character problem.

Jason-299789 (12/2/2014)

---

MS don't make it easy for people from BOL

When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is...

BI_NewBie (12/2/2014)

---

OK!!

Below is the way i am following :

1 Created three variable Query, Sdate, Edate

a. Query = SELECT * FROM Table where date<=...

select @variable

princessthedba (12/1/2014)

---

I mean this. Assume I have 2 backup dates for hostname "c" and 3 backup dates for hostname "d". And the table is like that:

hostname last_backup

c ...

uravindarreddy (12/1/2014)

---

Oh wow! Thats a nice use of Regular Expressions! Never tried before.

I am curious to know about how data is migrated?

The code can be changed but how the existing...

You are on the right track, it seems.

But you should note that the PK does not have to be clustered.

So you could easily convert your PK to nonclustered and introduce...

If so, you could use a FOR loop with an increment of 4 and use an expression to set your source SQL which references the loop variable in its WHERE...