-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Why Logdump Matters Every Oracle GoldenGate deployment depends on trail files, the immutable record of changes moving between systems. While… READ MORE
Over the years, GoldenGate has become the gold standard for real-time, reliable, and mission-critical data replication. But what are the… READ MORE
We had an issue the other day when one of the Sharepoint database logs became extremely large as the server… 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
|
Article to manage SQL Server 2000 transaction log growth http://www.mssqltips.com/tip.asp?tip=950 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
After scheduling a task through SQLServer Agent it generated the error below when executing the DTS. The DTS package required… READ MORE
Using the following SQL one can find tables that contain a column name. In SQLServer SELECT table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS… READ MORE
In SQLSever 2005 msdb.dbo.sp_send_dbmail is the new way of sending email and it replaces xp_sendmail. Below are the steps how… READ MORE
— List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like ‘SQLAgent%’ spid program_name… READ MORE
|
Run the following SQL to find permissions granted on users on the database select case when p.protecttype = 205 then… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 