I personally have Windows Phone and I love it. The user friendliness and integration with social media is remarkable. My wife Nupur is big fan of Windows Live tools and Windows Phone as well. Well, this blog post is not about our preference of Windows Phone but about YOU a unlocked Windows Phone. The Windows Phone will be directly sponsored by Idera.
If you want to win Windows Phone. Just do one thing, complete following cartoon. Every day queries go slow and we think it is SQL Server but the reality is that it is us who need to know the right technology. Idera provides tools for Microsoft SQL Server, SharePoint and PowerShell management and administration.
Contest Rules:
- Answer must be of maximum 140 character.
- Winner will get Windows Phone or USD 500 Gift Card from Idera.
- No purchase is required.
- This contest is open to all SQL enthusiasts in the world.
- Recipient will be responsible for local taxes.
- Idera has all the rights to alter, or modify the competition.
- To participate please a comment to this blog post.
- One person can participate multiple times.
- The contest is open till April 20th, 2011.
- Winner will be announced on April 25st, 2011.
- Phone image is for illustration purpose.
Note:
- Promote at one more social media place the answer to the question.
- Comments are moderated for spams and SEO marketers, if your comment does not appear, please send me email.
- Mentioning Idera in answer is encouraged but not necessary.
Reference: Pinal Dave (https://blog.sqlauthority.com)
209 Comments. Leave new
Idera – Winning Duh!
Better see the doctor. The SQL Doctor!
Define slow!
I’m confused, is that a rhetorical question, because your queries never perform well!
Answer: Use SQL diagnostic manager v6.6 and get rid from your problems.
Did you feed them with indexes?
I know you like to use your star power, but you shouldn’t use * power in your queries. Let Idera ‘s SQL Doctor take a look.
Don’t run them then ;)..are you living in a stone age or wht?? ever heard of SQL Doctor???
Idera will give you ideas, to query away, your slowness today.
For Human We need Doctor For Sql We need Idera SQL Doctor that is diagnosis that slow query in no time!
Analyze Indexes/Conditions/Joins/Exec Plan/Profiler/DMV/Stat
if Applicable,
Add,rebuild,defrag index
Use Partition/AWE
Indexes on Diff FileGroup
1. Use SQL Diagnostic Manager (Idera) to diagnose performance issues and identify server resource bottlenecks.
2. Use SQL Defrag Manager (Idera) to manage SQL Database and index fragmentation.
3. Use SQL Diagnostic Manager (Idera) to track query performance over time.
It’s because you are using that ghetto MySQL. You need to switch to SQL Server.
Answer should be we should analyze on the below points.
– use samll result sets
– dont use Select * instead limit the number of columns
– try with highly restrictive condition in the WHERE Clause to only get required data
– Avoid Cursors and try temp tables
– Avoid using arithmetic operators on the where clause
– Avoid using Function on where clause
– Avoid using Exlusion conditions in the where clause
– use Set Nocount on
– Check indexes required for the columns and drop unwanted indexes.
– Check with the profiler on the table scans
– Check for the outdated UPDATE Statistics.
– Check for all the Joins and try to avoid if un necessary by using sub queries.
– If joins are required check for the correct join type and correct order of joins
– check for the feasibility of Parallelism if using a Multi processor computer.
– Check for the network connection failures or its slow
– Check for the partioning of the data.
Charge with Idera!!
You need to optimized query by checking where it’s taking long time to execute and why? Even need to check locking. Apply index if needed.
Common man !! Why you so worried when there is Idera !!
Install Idera, idera will decide.
Dear, Queries will never slow if you follow SQL best practices and avoid worst mistakes. Check Idera too!
Queries are slow?? Impossible! You can get the results by 100 ways, but choose the best one.