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

    Database size in DB2

    Database size in DB2 - Find 3 methods I use to find the database size in DB2 METHOD 1 - GET_DBSIZE_INFO ============================ db2 connect to db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)" METHOD 2a (in MB) snapshot_tbs_cfg =============================== db2 connect to db2 "select (sum(......

    Jack Vamvas  Posted on Jun 23 2011 1:30AM
    Profile · Blog · Twitter
  • 0
    Liked

    SQL Server xp_msver

    SQL Server xp_msver is a SQL Server system stored procedure, returning general sql server information I find it useful for gathering basic server build and server information. Run it as EXEC master..xp_msver I use it when I need gather information for a SQL Server Inventory audit. I use the process......

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

    SQL Server Database Size and Free Disk Space Daily Report

    SQL Server Database Size and Free Disk Space reporting is critical in high volume databases. One of the modelling applications I manage, maintains a large SQL Server database inventory on one SQL Server 2005 Enterprise Edition instance. The application generates a database per modelling request. An......

    Jack Vamvas  Posted on Jun 21 2011 6:48AM
    Profile · Blog · Twitter
  • 0
    Liked

    DB2 manager status and get snapshot for dbm

    DB2 get snaphshot for dbm displays the database manage level information. Scanning the information available, you’ll notice instance monitor switches. I use the Database manager status value to get the status. If no value is returned, then I assume the instance is unavailable. Repu......

    Jack Vamvas  Posted on Jun 20 2011 11:34AM
    Profile · Blog · Twitter
  • 0
    Liked

    SQL Server DBA Top 10 automation tasks

    SQL Server Automation is one of the best ways for a DBA to achieve more in less time. If a task is repeatable – then why run it manually? A word of warning! There are automated jobs out in the SQL Server world that are causing more damage then help. I have seen plenty of Daily Shrink Databas......

    Jack Vamvas  Posted on Jun 20 2011 6:54AM
    Profile · Blog · Twitter
  • 0
    Liked

    What is SQL Server Query Tuning?

    I suggested to a client last week ,Query Tuning is required to troubleshoot some SQL performance issues. He wanted a definition of Query Tuning. I sent him an email, defining a Query Tuning approach .These are notes from the email What is Query tuning? In practise, there are predeployment qu......

    Jack Vamvas  Posted on Jun 19 2011 6:59AM
    Profile · Blog · Twitter
  • 0
    Liked

    Reorg table DB2

    Reorg table DB2 Step 1 run reorgchk: ------CODE START--------------- db2 reorgchk update statistics on table all > output.out ------CODE END------------------</b> Running the command this way will run across all tables rather than RUNSTATS across every table. The reorgchk update statistics r......

    Jack Vamvas  Posted on Jun 19 2011 6:41AM
    Profile · Blog · Twitter
  • 0
    Liked

    Top 10 DBA mistakes

    DBA is a demanding job. Expertise is required at different levels – hardware, OS , Database Server and Application Layer. As pressure increases to give input at an operations and architecture level, remember the two primary tasks of the DBA is to maintain availability and performance. These a......

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

    Windows Server Uptime and Net Statistics Server

    Windows Server Uptime and the last time a Windows Server restarted, on a database server is useful information. As well as SQL Server I do also manage some DB2 Server on Windows - which has different information available for server level information. Net Statistics Server displays the details.......

    Jack Vamvas  Posted on Jun 17 2011 10:09AM
    Profile · Blog · Twitter
  • 0
    Liked

    Powershell for SQL SMO

    Powershell for SQL SMO has fantastic potential. Robert Matthew Cook left me some code on SQL Server xp_msver - seeing if I was interested on expanding. The Server Object offers SQL Server Instance Information [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null $S......

    Jack Vamvas  Posted on Jun 17 2011 7:07AM
    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]