Viewing 15 posts - 8,881 through 8,895 (of 13,876 total)
Jason-299789 (12/4/2014)
to get round...
December 4, 2014 at 2:42 am
manju.ccc (12/4/2014)
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...
December 4, 2014 at 2:39 am
manju.ccc (12/3/2014)
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...
December 4, 2014 at 12:13 am
Sure.
Take a look here for an example.
Unfortunately, it's heavy on CPU and slows things down quite a lot.
December 3, 2014 at 5:30 am
Debbie Edwards (12/2/2014)
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....
December 2, 2014 at 6:34 am
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...
December 2, 2014 at 6:07 am
May I ask what you mean by 'IS' in this:
f I run it in IS it always records every file name.
Could it be a permissions issue?
December 2, 2014 at 5:46 am
True, but that does not demonstrate the 30 character problem.
December 2, 2014 at 1:44 am
Jason-299789 (12/2/2014)
When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is...
December 2, 2014 at 1:14 am
BI_NewBie (12/2/2014)
Below is the way i am following :
1 Created three variable Query, Sdate, Edate
a. Query = SELECT * FROM Table where date<=...
December 2, 2014 at 12:35 am
select @variable
December 1, 2014 at 10:32 am
princessthedba (12/1/2014)
hostname last_backup
c ...
December 1, 2014 at 6:26 am
uravindarreddy (12/1/2014)
I am curious to know about how data is migrated?
The code can be changed but how the existing...
December 1, 2014 at 5:12 am
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...
December 1, 2014 at 4:54 am
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...
December 1, 2014 at 2:39 am
Viewing 15 posts - 8,881 through 8,895 (of 13,876 total)