An extensive WordPress plug-in that generates META tags automatically for your posts! Let it be your post or home page, this little plug-in does it job automatically.
The plug-in works in an intelligent manner, META description is generated on the basis of page or post name respectively. Though when you are composing a new post, all [...]
1. Upload “em-tags2meta.php” to the /wp-content/plugins/ directory
2. Activate the plugin through the ‘Plugins’ menu in WordPress
You’re all ready to go!
Q. I just updated my post tags; will my META tags be updated automatically?
A. Yes, that’s the beauty of this plug-in!
Q. What if my post has no tags?
A. In such case, no META tag for “keywords” will be generated. Only META tag for description will be generated on that page.
Q. WordPress does not let you [...]
Here are few tips to tune up stored procedures in SQL Server. I gathered these after doing some search on Google:
Include the ‘SET NOCOUNT ON‘ statement to stop the message indicating the number of rows affected (Reduces network traffic)
Break down the stored procedure in parts and call them from 1, esp. if you know that [...]
Hmm, I’ve finally setup a page ‘about Em’ – yes, that’s about me! It’s a 1 page portfolio that covers my blogs, startups and a little about me. You can view it at: www.axdimensions.com
In SQL Server 2000, you can insert multiple records by using a single INSERT statement. It helps to boost performance a little and the task gets done in a single query.
Sample code:
INSERT INTO MyTable (Col1, Col2)
SELECT 'First', 1
UNION ALL
SELECT 'Second', 2
UNION ALL
SELECT 'Third', 3
UNION ALL
SELECT 'Fourth', 4
UNION ALL
SELECT 'Fifth', 5
GO
Often developers require hiding the stored procedures from end users. In such case, developers can perform a one way encryption using the WITH ENCRYPTION clause. Once the definition of the stored procedure is encrypted, it cannot be decrypted or viewed by anyone.
Sample Code:
CREATE PROCEDURE [SP_Name]
WITH ENCRYPTION
AS
SELECT
[CustomerID], [CompanyName]
FROM
[Northwind].[dbo].[Customers]
If your stored procedure has some parameters, you can [...]
Last week I came across a post on the ‘Adsense Blog’ – and it cleared up my confusion regarding Adsense earning. Google Adsense program is wiser than a layman thinks. You start earning more when you start getting healthy clicks! Quoting from the Adsense Blog:
If your website performs well for advertisers, there may be increased competition [...]
Unable to download the browser? Get the full setup from MediaFire. Click on the filename below to proceed!
chrome_installer.exe (7.35 MB)
Enjoy!
DATEDIFF produces an error if the result is out of range for integer values. For milliseconds, the maximum number is 24 days, 20 hours, 31 minutes and 23.647 seconds. For seconds, the maximum number is 68 years.
Source: Transact-SQL Reference
Subscribe via RSS Feed stay updated with blog articles
Subscribe via email address:
(4 out of 5) (4 out of 5) (4 out of 5) (4 out of 5) (4 out of 5)