Viewing 15 posts - 1 through 15 (of 16 total)
About previous error, I changed the extension of the file and I'm trying to upload it again.
December 4, 2019 at 3:53 am
I'm not very familiar with pull request process in GitHub.
I want to submit a modification to readme.md page of sqlserver-kit/Utilities/README.md to add a decent explanation of what YourSqlDba is...
December 4, 2019 at 3:51 am
Update (SQL2016-SQL2017) about CROSS APPLY and optimization:
CROSS APPLY aren't necessarily optimized with nested loop.
The optimizer now optimizes them like any joins if possible.
CROSS APPLY is the best tool created ever...
October 21, 2019 at 3:09 am
March 13, 2019 at 11:05 pm
You have to take into account, that this is the SQL Server database engine service account that must have the right to access this share. The account under which...
March 13, 2019 at 11:01 pm
YourSqlDba: There is a free maintenance tool that is described in the readme portion of this page at his adress. https://github.com/pelsql/YourSqlDba
It covers the five basic maintenance...
June 29, 2017 at 1:17 pm
This approach needs some more improvements. Updating all columns is problematic for trigger that test "if update()" because if there is no necessarily a real change. You put the...
May 23, 2009 at 10:35 am
I use the following strategy : At full backup time, two new file name are generated (including a timestamp in the name): one for full backups, one for log...
January 13, 2009 at 2:21 pm
Be careful how you grant your permissions, there is share permissions, and there is ntfs permissions. I got this problem some day because I forgot share permissions.
October 15, 2008 at 7:08 am
By checking more how index are created by my developers, if found that one method for index creation is setting page level locking...
April 30, 2007 at 9:59 am
The problem is that I have also this porblem that appears spuriously from differents index on my development box.
I suspect a bug in the...
April 30, 2007 at 9:25 am
Oups.. "as if the row hold more than 8096 bytes"
November 9, 2005 at 4:05 pm
You should specify that varchar(max) and nvarchar(max) are new features specific only to SQL2005 and that they make appears as if the row hold more that 8096 rows.
Varchar(max) and nvarchar(max)...
November 9, 2005 at 4:01 pm
Just try to do all this in one single batch. All theses statements can be put together in one single execute like this.
strSQL = "IF EXISTS (SELECT * FROM sysobjects...
July 29, 2005 at 3:01 pm
Well you should have a BUILIN/Administrators account defined. It is the default setup. You can add it by hand using as a standart user, and you must set it to...
July 18, 2005 at 1:57 pm