-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
We had an issue the other day when one of the Sharepoint database logs became extremely large as the server… READ MORE
When a user account is created on SQLServer on 2005 with user account set to “Enforce password policy” and “Enforce… READ MORE
There are 2 types of DBCC TRACEON (session or global). Session trace is turned on that session only and global… READ MORE
|
In SQLServer Managment Studio to the execution plan one can use one of the following SET commands “SET SHOWPLAN_XML ON”… READ MORE
For SQLServer using arthemetic and DATEADD one can modify date select getdate() -- today , getdate() + 1 -- tomorrow… READ MORE
To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @oem_errorlog nvarchar(255) EXECUTE master.dbo.xp_instance_regread… READ MORE
When clicking on Properties, SQLServer could display the following error message “Property Owner is not available for Database ‘[DatabaseName]’. This… READ MORE
http://support.microsoft.com/kb/923247 Using DBCC CHECKDB (0) WITH ESTIMATEONLY will estimate space needed in tempdb when DBCC CHECKDB is run. Sample Output:… READ MORE
|
Article to manage SQL Server 2000 transaction log growth http://www.mssqltips.com/tip.asp?tip=950 READ MORE
|
sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text,… READ MORE
For SQLServer: — Clears all the procedure cache (works on SQLServer 2005 and SQLServer 2008) DBCC FREEPROCCACHE http://msdn.microsoft.com/en-us/library/ms174283%28v=SQL.90%29.aspx — On… READ MORE
|
— Display SQL statement (SQLServer 2005 and SQLServer 2008), it displays creation time, last exeuction time, max time it ran… READ MORE
After scheduling a task through SQLServer Agent it generated the error below when executing the DTS. The DTS package required… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 