Viewing 15 posts - 1 through 15 (of 219 total)
February 13, 2019 at 4:49 pm
DECLARE @Batchsize INTSET @Batchsize = 50; /* Change to whatever...
February 12, 2019 at 5:10 pm
Thank you, Jonanthan. Very appreciated.
February 12, 2019 at 4:58 pm
I'm reviewing Jonathan T-sql scripts and update shortly with questions.
Many thanks for Jonathan AC Robert and everyone helps. I'm very appreciated.
February 12, 2019 at 8:50 am
I'm not hundred percent sure on the historian data that the business wanted to keep. My best guest is one year.Also, I did some research and some suggested...
February 12, 2019 at 8:44 am
I already setup SQL Audit.There are many pre-existing Audit Action Type.So far, I did not find one that can help me to monitor a user permission changed.
February 20, 2018 at 9:01 am
Is that any existing t-script that I can use to trace?
February 20, 2018 at 8:44 am
Thank you, All for your input. The feedback answered my questions.
September 19, 2017 at 7:39 am
I have a SQL Server 2008 R2 and have 100 SQL Agent jobs listed with different schedule and time stamps.
Now, I needed to add addtion 7 hours to the existing...
May 21, 2014 at 3:25 pm
The best practice should create the database and allocate database size based on proper planning and estimate grow for minimum 3 years.
I won't let the application create the database.
March 13, 2014 at 5:28 pm
Thank you and very appreciated.
March 13, 2014 at 3:31 pm
Personally, when I create the database. I will allocated enough space to grow for minimum 3 to 5 years.
However, this database applications already existed and it was the...
March 13, 2014 at 2:34 pm
I figured out that the DVD software disk was corrupted or error.
May 22, 2012 at 3:39 pm
I created a simple package that consist of a Script Task connected to Send Mail Tak.
There are three variables:
dtFileDate DateTime 2/17/2012
February 17, 2012 at 2:13 pm
Hello SSIS Guru,
I am supputing a SQL Developer who run into problems on SSIS package.
The package returned an error (Please see the attachment) when he tried to execute in DOS...
January 3, 2011 at 9:32 am