Viewing 15 posts - 1 through 15 (of 83 total)
Thanks a lot.
I already know the "issue" of my problem.
The instance was restarted for 11 times in the same day, as the rollover its done when the instance start i...
May 15, 2013 at 5:21 am
November 16, 2011 at 11:21 am
I've comment the line as you tell me to do it but and uncomment the line select @sSQL but i really dont have any usefull results.
I only want...
June 30, 2011 at 9:30 am
I'm sorry but i'm using your code to test and ......i really dont know if i'm using it in the right way.
I create a table in a specific database...
June 30, 2011 at 8:52 am
I dont understand when you're telling me "conflit between tempdb and youre database".
The server collation its different in both instances and there's an aplication that automatically will create databases. So...
February 18, 2011 at 7:10 am
I'm really but really sorry, but i'm completely lost and hope that anyone explain me what should i do like if i was a donkey :crying:
Sorry but i really...
January 10, 2011 at 10:09 am
I've attached the execution plan and the code of both views, the oldest and the new one.
I've change yet the column names, and the tablename on both views.
January 10, 2011 at 7:40 am
Thanks a lot LutzM.
I'll change the function as u tell me.
January 9, 2011 at 9:10 am
Thanks a lot Koen.
I'll do the right checks and i'll tell you the solution.
Once more thanks.
January 9, 2011 at 7:06 am
Thanks and regards,
December 23, 2010 at 6:09 am
So can you send me a query where i can see in the output the following information.
The spid xxx that is locking spid yyy for x min (for example 5...
December 22, 2010 at 3:59 am
August 1, 2010 at 7:02 am
Sorry for i didn't respond with the solution.
My solution was asa follows.
declare @sd as datetime
declare @sdaux as datetime
set @sd = cast('2010-07-23 07:00:00' as datetime)
set @sdaux =...
July 23, 2010 at 9:43 am
Thanks a lot everybody.
July 23, 2010 at 8:49 am
I think that will be posible to make the change from snapshot replication to transactional............. but i'd like to understand is if the time that the snapshot is running is...
April 9, 2010 at 11:11 am