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
Slow query can be due to
* Poor indexing strategy.
* Out-of-Date / Missing statistics.
* I/O subsystem problem.
* T-SQL code.
* Database/Table Structure/Schema Design.
Get diagnosed by Diagnostic Manger and SQL doctor to cure your slow query disease.
“You can do whatever you want mentioned in comments of some Cartoon Challenge of SQL, but if you don’t use IDERA, you are missing the main point of the solution”
1. “Dedicate more than 256 MB RAM to SQL Server Machine”
2. “Disable defragmenting disc during working hours”
3. “Upgrade from SQL 2000 to SQL 2008 R2”
4. “What do you mean for slow?!!? One hour, one second or two milliseconds?”
Recommend use of some Best SQLServer performance monitoring, alerting, diagnostics & DB tuning tools. Also Consult any MVP to get direction
“goes to the doctor! uh … the SQL Doctor !”
or
“did you try to Idera it ?”
Define “slow”
IDERISE your database !!!
“SQL Server queries always run, but are YOU really helping them to run better?!”
‘Idera’ will make it faster!
if users would stop using the database so much, it’d be a lot faster
Oh no worries! Let me call the SQL Doctor @ Idera who can help us identify where the bottleneck is.
“That should make it easier for us to Try and Catch it :-)”
Did you feed the SQuirreL this morning?
Quick, call the “doctor”, Idera SQL Doctor that is! He’ll diagnosis that slow query in no time!
I have an idera!!
“Use a cursor.”
Why are you asking a cartoon, call Idera
“how many times have I told you, its the where clause that you need to build your indexes off of not the select statement.” :)
Holy shish kabob Pinal, better purchase Idera and sign up for SQL Smarts Enewsletter!