Viewing 13 posts - 16 through 28 (of 28 total)
the situation hasn't changed ... The values I posted a while ago are still the same.
I think that this simply requires application code rewrite... which is not really something we...
September 8, 2015 at 11:13 pm
Yep, as I expected when I read your post.. I forgot a FETCH in the first loop ...
An infinite loop is never good except when it's what you want...
June 23, 2015 at 12:09 am
Thanks for the reply.
Instead, I used powershell's Copy-Item command let.
April 1, 2015 at 12:57 pm
Hi, first of all thank you for sharing.
I'm on the way to implement the same kind of thing but all under stored procedures.
I have a problem with the xcopy...
April 1, 2015 at 1:51 am
Yes, it gives you a guideline for implementing database mirroring :
1. you backup your database you need to mirror
2. you restore your database on the off-site server
both FULL and...
March 20, 2015 at 8:57 am
Thanks for your comment.
I would say, it's just a starting point ...
I work on a set of scripts written in perl (I'm not a big fan of Powershell for...
January 20, 2015 at 10:41 am
Hi, thank you for the comment.
I'm primarily an Oracle DBA so, there are kind of things like that I don't know. It's a good idea. I'll update it in a...
December 16, 2014 at 5:18 am
Ok, thank you for your analysis.
March 12, 2014 at 1:27 am
Hi, it's a 64 bits system, Windows Server 2008 R2 SP1.
The memory settings are Min memory = 4Gb, Max Memory = 7Gb.
Index rebuild is done every day. The statistics are...
March 11, 2014 at 1:54 pm
Yes, just before an index creation... But I'm very surprised because it's a script generated via SSMS, and I can't get to it working at once :w00t:
January 10, 2013 at 3:38 am
By the way, I generated the whole database script and suppressed the references to TEXTIMAGE_ON... I now get this error
CREATE INDEX failed because the following SET options have incorrect...
January 10, 2013 at 3:25 am
And I suppose the only way to "sanitize" is to make a clone table, copy data from the currently used table and switch ... There is no way to clean...
January 10, 2013 at 3:21 am
As I said, it's an external DB for an application developped by another company. I just took their .BAK file and restored it. I don't know the history of that...
January 10, 2013 at 1:47 am