Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked



Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

  • 0
    Liked

    SQL Server - Grant execute on all stored procedures

    Granting execute rights to all stored procedures used to be a cumbersome problem up to before SQL Server 2005. You either had to give elevated rights to the user or run a script to GRANT EXECUTE on every stored procedure. I still see plenty of databases where a DBA has granted db_owner rights, sim......

    Jack Vamvas  Posted on Apr 22 2011 7:05AM
    Profile · Blog · Twitter
  • 0
    Liked

    Sys.dm_os_memory_clerks and AWE memory allocation

    This useful DMV Sys.dm_os_memory_clerks produces a recordset of SQL Server memory clerks currently active. Being aware of memory pressure is critical to managing SQL Server performance. I use this DMV as part of a suite of queries which track external memory pressure and VAS pressure e.g caused by O......

    Jack Vamvas  Posted on Apr 21 2011 7:09AM
    Profile · Blog · Twitter
  • 0
    Liked

    Perfmon, Waits and Queues

    It is important to differentiate between Waits and Queues, when applying the Waits and Queues performance analysis methodology. Even though they are two sides of the same problem, they are approaching resource usage in a different manner. Waits, refers to any time spent waiting on resources by any......

    Jack Vamvas  Posted on Apr 18 2011 7:19AM
    Profile · Blog · Twitter
  • 0
    Liked

    Recover from a Suspect database

    --Recover from a Suspect db on SQL Server 2005 Standard Service Pack2 ---Error: 3414, Severity: 21, State: 1. --During redoing of a logged operation in database 'MY_DB', an error occurred at log record ID (5006:4238:75). --Typically, the specific failure is previously logged as an error in the ......

    Jack Vamvas  Posted on Jul 31 2009 6:12AM
    Profile · Blog · Twitter
  • 0
    Liked

    Quick uninstall of SQL Server 2005 instance

    The following command line brings up all instance names and asks to select an instance and then a few button clicks. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe" /Remove Ensure you have backed up registry settings PRIOR to running the code. For more information, chec......

    Jack Vamvas  Posted on Aug 19 2009 6:10AM
    Profile · Blog · Twitter
  • 0
    Liked

    Performance Tuning series – Performance Stack

    From tomorrow, I’m posting a series of articles on Performance Tuning overview. The focus is not specific configurations or platform specific techniques. It’s a summary of general techniques, which DBAs can apply to most systems. In most cases the DBA weighs up the cost versus benef......

    Jack Vamvas  Posted on Jul 18 2011 2:00AM
    Profile · Blog · Twitter
  • 0
    Liked

    DB2 process model

    There’s a good article on http://www.ibm.com/developerworks/data/library/techarticle/dm-0807kharche/ outlining the DB2 9.5 process model. Key Points New memory model Increased automatic configurations. According to the article, less is required of the DBA. Based on my experience since D......

    Jack Vamvas  Posted on Sep 3 2011 2:27AM
    Profile · Blog · Twitter
  • 0
    Liked

    SET SHOWPLAN ON

    Use SET SHOWPLAN_XML instead of SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL. Microsoft announced at the SQL Server 2008 release, SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL are deprecated. The advantage of using SET SHOWPLAN_XML ON is that the code is not executed. Executing the t-sql returns the exec......

    Jack Vamvas  Posted on Jul 19 2011 7:56AM
    Profile · Blog · Twitter
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]