Use '=' or LIKE to compare strings in SQL?

-
o see the performance difference, try this:
SELECT count(*)
FROM master..sysobjects as A
JOIN tempdb..sysobjects as B
on A.name = B.name

SELECT count(*)
FROM master..sysobjects as A
JOIN tempdb..sysobjects as B
on A.name LIKE B.name
Comparing strings with '=' is much faster.

Comments

Post a Comment

Popular posts from this blog

How can I debug PHP cURL sessions?

-
Setting CURLOPT_HEADER and CURLOPT_VERBOSE to 'true' are two of the most important ways to debug PHP cURL sessions.  Detailed Description PHP’s cURL library is widely used by PHP applications to communicate with the eBay API. However, debugging cURL sessions can be problematic.  Since many of eBay’s services require proper information in the HTTP headers, verifying correct header transfer is important. This can be done by setting the CURLOPT_HEADER to 'true'.  Setting CURLOPT_VERBOSE to 'true' will display two-way communication between the PHP application and the server.  You can also use curl_getinfo to get error messages.  Sample Code and Session for CURLOPT_VERBOSE <?php $headers = array ( 'X-EBAY-API-COMPATIBILITY-LEVEL: 507', 'X-EBAY-API-DEV-NAME: ABCD', 'X-EBAY-API-APP-NAME: EFGH', 'X-EBAY-API-CERT-NAME: IJKL', 'X-EBAY-API-SITEID: 0', ); $session = curl_init(); curl_setopt($session, CURLOPT_URL, &
Read more

Free icons

-
It's important to use icons with the same style in your project. So here's a list of free icons you can use. 🆓👇 🔸fethericons. com 🔸iconmonstr. com 🔸freeicons. io 🔸lineicons. com 🔸css. gg 🔸jam-icons. com
Read more

Where is the security section of google analytics? “Security Issues” section.

-
Accessing the securty issues tool is done from within the search properties section that you register. For ease of use you can go to  https://www.google.com/webmasters/tools/security-issues  which will link you directly to the security issues section of GWT however you will have to have added your website as a property already within GWT and gone through the steps to validate the site. You don't mention if you have actually registered the site in GWT or not so basically... Log into Google Webmaster Tools Register your site using all possible validations including http, https (if used), www, and non www versions of your site You will be given several methods of validation and you have to pick one. These include adding a meta tag to your site pages, adding a file with a special filename to the site root, adding a DNS entry to your DNS zone file. You need to choose one of these options and follow the instructions to validate the property to your GWT account. Once validated it
Read more