Tags » Tips And Techniques

Sql Server : Why is a query with literals performs faster than a query with variables (parameter sniffing)

Quick one today:

Let’s look at an Interesting, albeit, seemingly anomalous behavior with in Sql Server.

Question

  • When does a query with literals perform faster than query with variables?
  • 340 more words
DBA

Long Exposure Photography by Matt Kloskowski

Have you ever wondered how people create these amazing pictures where you think the cloud is still moving around the stage, where flowing water turns into a ghostly fog, or where the stars in the sky seem stripes? 118 more words

Tips And Techniques

Travel Photography and Post Processing Techniques

Travel Photography is a new trend among amateur photographers but many of them actually don’t understand the things and techniques to be a travel photographer. So we have a video that will help people to know more about travel photography. Hope you will love it..!!

Photography

How to Become a Successful Travel and Adventure Photographer, with Lucas Gilman

Lucas Gilman takes you on a visual adventure around the world sharing vibrant images ranging from kayaking in India, Brazil, and Costa Rica, to extreme skiing in Alaska, Wyoming and South America. 36 more words

Tips And Techniques

Tips for Zooming in on Wildlife and Improving Your Macro Photography with Roman Kurywczak

Ever wonder how the pros capture those stunning, action packed wildlife images? Roman will share with you his settings, tips and tricks for capturing high impact wildlife images, whether out in the Serengeti, or photographing birds in flight closer to home. 24 more words

Tips And Techniques

Work the Subject: You Keep Shooting with Bryan Peterson

How many times have you taken a quick photo of something only to later wish you had taken an extra moment to photograph it differently? In this episode Bryan teaches you to consider varying viewpoints and lens choices before moving on! Work the subject!

Tips And Techniques

Sql Server Performance Metrics (perfmon) : What is the difference between PhysicalDisk and LogicalDisk

Quick one today:

As a Sql DBA, we need to continuously monitor different performance metrics to make sure the system is performing as expected and within acceptable limits. 238 more words

DBA