11 Ways to Use Video in Your Content Marketing

CCO_Video

Are you considering allocating budget to video? Whether it’s a one-time production in the tens of thousands or a long-term capital investment that may reach hundreds of thousands, video investments are often hard to evaluate and approve because they rarely generate a direct response.

Your video project is likely top or middle of the funnel activity, meaning ROI is hard to prove. No matter how enthusiastic your team is about video or how much you hear in digital media circles that video is the next great tactic, you need some plain talk about what type of videos to consider based on different circumstances.

read more

CTE with Option Recompile not working

If I do,

declare @Q varchar(10) = 'ab1';
SELECT * 
FROM   MyTable
WHERE  EXISTS(SELECT TOP 1 't' InnerTable O WHERE O.TId = P.Id)
AND (P.Name_EngLIKE @Per_Name + '%' OR P.PER_NAME_ARB LIKE @Per_Name +'%') 

Then the query become very slow. If I comment EXISTS(SELECT TOP 1 't' InnerTable O WHERE O.TId = P.Id) then it will be fast or if I add OPTION(RECOMPILE) then it will be fast. The problem is that I am using this SQL in CTE(Common Table Expression) which don’t allow me to put OPTION(RECOMPILE)

Edit:
Here is my CTE,

WITH CTEPage AS
(
    SELECT  Top(@PageSize * @PageIndex)
            ROW_NUMBER() OVER (ORDER BY P.Id) AS RowNumber
    FROM    MyTable(NOLOCK) AS P
    WHERE   EXISTS(SELECT TOP 1 't' FROM OtherTable O WHERE O.PId = P.Id)
            AND (@Name IS NULL OR @Name = '' OR P.NAME_ENG LIKE @Name + '%' OR P.NAME_ARB LIKE @Name + '%')
)

SELECT  TOP(@PageSize) 
        *
FROM    CTEPage AS P

WHERE   P.[RowNumber] > (@PageIndex - 1) * @PageSize
        ORDER BY P.[RowNumber] ASC;

read more

The Deadliest On-Page SEO Mistakes That Everyone Does

deadliest mistakes

This article aims to point out you with on page seo mistakes – the aspect of SEO focused on the pages you create, not the links from other areas or how many clicks you’re getting.

This is by far the easiest part of SEO to control, and by checking each page you make for these elements, you’ll be setting yourself up for the best initial results. These are the basic you should know about:

read more

Image file types indexed by Google: is TIFF part of it or not?

The image file types indexed by Google are defined:

  1. On the Google Webmaster / Search Console Help where the TIFF format is not present (latest update 2015):

Google can index the following image types:

BMP
GIF
JPEG
PNG
WebP
SVG
  1. But on the Google Search Appliance Documentation the TIFF format is present (latest update 2013):

TIFF Group 5 & 6 – tiff – Versions through 6

TIFF CCITT Group 3 & 4 -tiff – Versions through 6

Can someone confirm that TIFF is part or not part of the supported image file types that Google can index or not? Or give me a hint how I could verify this in a simple, fast and efficient way?

For now my reference is the first link with the Search Console Help (which was updated in 2015), but the second link (from 2013) has given me doubts… Or am I mixing two different things?

read more

Image file types indexed by Google: is TIFF part of it or not?

The image file types indexed by Google are defined:

  1. On the Google Webmaster / Search Console Help where the TIFF format is not present (latest update 2015):

Google can index the following image types:

BMP
GIF
JPEG
PNG
WebP
SVG
  1. But on the Google Search Appliance Documentation the TIFF format is present (latest update 2013):

TIFF Group 5 & 6 – tiff – Versions through 6

TIFF CCITT Group 3 & 4 -tiff – Versions through 6

Can someone confirm that TIFF is part or not part of the supported image file types that Google can index or not? Or give me a hint how I could verify this in a simple, fast and efficient way?

For now my reference is the first link with the Search Console Help (which was updated in 2015), but the second link (from 2013) has given me doubts… Or am I mixing two different things?

read more