Viewing 15 posts - 1 through 15 (of 19 total)
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
February 13, 2017 at 2:34 am
After increase the number of log files, I use a job to run weekly and create one new file for week.
https://msdn.microsoft.com/en-us/library/ms182512.aspx?f=255&MSPPError=-2147217396
This avoid larger error log...
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
February 10, 2017 at 6:22 am
Perry Whittle (3/6/2015)
FabricioLimaDBA (3/5/2015)
The problems with AVG is that only works with enterprise edition.Then I continue to use database mirroring in clients with SQL Standard.
Yes, but you're limited to synch...
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
March 6, 2015 at 5:14 am
Perry Whittle (3/13/2014)
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
March 5, 2015 at 11:02 am
you're welcome. This whitepaper is really great.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
January 20, 2011 at 1:17 pm
This link has a great whitepaper about that migration. It can help you.
http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
January 18, 2011 at 2:19 pm
This link has a great whitepaper about that migration:
http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
January 14, 2011 at 3:23 pm
This link has a great whitepaper about that migration:
http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx
Fabrício França Lima
MCITP – Database Administrator
Twitter: @fabriciodba
http://fabriciodba.wordpress.com/
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
January 14, 2011 at 6:40 am
I do this daily in all databases that I have.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
August 12, 2010 at 5:09 pm
You can't do this:
SELECT COUNT(TableA.*) FROM TableA
SELECT COUNT(a.*) FROM TableA a
You can only put a column: select COUNT(Nome_Coluna) from TableA
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
August 11, 2010 at 8:17 pm
Do you make what Jeffrey Williams said?
Verified that the lock pages in memory policy has been set for the service account running SQL Server?
If that is not set, AWE...
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
May 23, 2010 at 7:11 pm
Thank you WayneS.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
March 13, 2010 at 12:09 pm
That's OK. I work with Sql Server 2000 and 2005 yet. I will make the upgrade.
Thank you.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
March 12, 2010 at 6:26 pm
This query is very useful for me.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
March 12, 2010 at 4:52 pm
I use this simple query to find this.
select distinct B.name ,
case type when 'P' then 'Stored procedure'
when 'FN' then 'Function'
when 'TF' then 'Function'
when 'TR' then 'Trigger'
when 'V' then 'View'
end
from syscomments...
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
March 10, 2010 at 7:09 pm
Viewing 15 posts - 1 through 15 (of 19 total)