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

    Monitoring a Rollback and sys.dm_exec_requests

    The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server. Instead of using Activity Monitor to view the status of a Rollback, use this T-SQL code. Activity monitor is based on window panes and is cumbersome to export any inf......

    Jack Vamvas  Posted on Nov 22 2011 12:00AM
    Profile · Blog · Twitter
  • 1
    Liked

    DBA secrets to stress reduction

    The current DBA trend is increased database management requirements and less DBAs to manage. Many factors are responsible, such as: 1)Global trends and predictions for increased data requirements 2)Automation 3)Economic pressure to decrease size of IT departments You can see why for many DBAs ......

    Jack Vamvas  Posted on Nov 16 2011 12:00AM
    Profile · Blog · Twitter
  • 1
    Liked

    Quotename in SQL

    Quotename() is a SQL Server String function. It accepts an input string of of up to 128 characters. Which is a limitation, although you could easily create a workaround with a UDF Returns a Unicode string of a valid delimited identifier. Why would you use Quotename()? 1) Reviewing for SQL ......

    Jack Vamvas  Posted on Nov 15 2011 12:00AM
    Profile · Blog · Twitter
  • 1
    Liked

    Analyzing a DB2 trap file

    Usually when the DB2 instance ends unexpectedly, trap files are created. There is usually one trap file capturing the root cause. A number of other files are created, supporting data about DB2 processes. The dbdiag.log file indicates which files to analyze. By default, the files are created in &l......

    Jack Vamvas  Posted on Nov 14 2011 12:00AM
    Profile · Blog · Twitter
  • 2
    Liked
    1
    Comments

    DBCC CHECKDB

    Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered? This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague. My approach on DBCC CHE......

    Jack Vamvas  Posted on Nov 14 2011 12:00AM
    Profile · Blog · Twitter
  • 0
    Liked

    DIAGLEVEL db2

    Diaglevel refers to the Diagnostic error capture level configuration parameter. There are 5 levels: 0 - No diagnostic data captured 1 - Severe errors only 2 - All errors 3 - All errors and warnings 4 - All errors, warnings and informational messages The default is at 3. Change the......

    Jack Vamvas  Posted on Nov 12 2011 12:00AM
    Profile · Blog · Twitter
  • 0
    Liked

    How to set dbm cfg to empty value

    To set a DB2 database cfg value to an empty value use NULL. It’s case sensitive. Using “null” will not work. An example: update db cfg for MYDB using HADR_LOCAL_HOST NULL Republished from http://www.sqlserver-dba.com.......

    Jack Vamvas  Posted on Nov 10 2011 12:00AM
    Profile · Blog · Twitter
  • 3
    Liked

    Stored Procedure Checklist

    DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate some ideas you could use For acceptance into the SQL Server environment, I’ve developed some scripts that scan the T-SQL code for some items in this check......

    Jack Vamvas  Posted on Nov 10 2011 12:00AM
    Profile · Blog · Twitter
  • 0
    Liked

    Storage Monitoring: a quick guide

    Storage Monitoring requires an end to end view. Consider the different types of drives and servers connecting to the sub storage system Monitor – Hard Drives Controllers (CPU, Caching ) Controller connectivity Network switch throughput HBA connectivity Network Fabric SAN storage monitori......

    Jack Vamvas  Posted on Nov 7 2011 12:00AM
    Profile · Blog · Twitter
  • 0
    Liked

    ALTER SCHEMA

    Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. “dbo” can be changed to whatever schema name required USE myDb GO SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name FROM sys.Procedures p INNER JOIN sys.Sc......

    Jack Vamvas  Posted on Oct 24 2011 12:00AM
    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]