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...

Perry Whittle (3/6/2015)

---

Yes, but you're limited to synch...

Perry Whittle (3/13/2014)

---

Database mirroring will be removed in a future version, for this reason it would make sense not to use an exiting technology, but use the option that has...

you're welcome. This whitepaper is really great.

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

This link has a great whitepaper about that migration:

http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx

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/

I do this daily in all databases that I have.

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

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...

Thank you WayneS.

That's OK. I work with Sql Server 2000 and 2005 yet. I will make the upgrade.

Thank you.

This query is very useful for me.

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...