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
“You should lower your expectactions, you know?”
Did you try
Index
Defrag.
Execution Plan
Remove unnecessory joins
Analyze with Tuning Advisor ?
Use IDERA to make Query Results faster
Have you created an index?
Please created an index.
WHAT? I told you, change your RDBMS to SQL Server 2008 and you can use Idera Tools for tunning.
Congratulations
Hello Marlon,
Congrats. Well Deserve.
By the way, this is my favorite too. At-least I know some one who share same thoughts as mine on SQL Server 2008.
~IM.
“My advice is to use SQL diagnostic manager to find and fix the bottlenecks. As simple as that!”
well in order to make query efficient or to speed up the query adopt the following ways:-
1. use different type of indexes.
2. properly locate different DB objects across different tablespaces, files .
3. In last drop all those indexes which are of no use.
Is it SQL Server, or is it just your server?
well in order to make query efficient or to speed up the query adopt the following ways:-
Logical Query Processing
Efficient Join Techniques
Query Tuning Considerations
Avoiding Common Performance Tuning Issues
Statistics and Best Practices
TempDB Tuning
Hardware Planning
Understanding Query Processor
Using SQL Server 2005 and 2008 Updated Feature Sets
CPU, Memory, I/O Bottleneck
Index Tuning (of course)
Wait! Did you check your query first?
Are you sure that your query is optimally written?
Your query might run fast end of the month, but is it optimal for everyday running?
Maybe your indexes are not being used by the query well.
You can use the query accelerator: – But only on the First of April
Let me see …….. mmmmmm …….. what a nice FullScan ……
Hi,
I highly recommend Idera to optimize the databases. It increases performance and optimization rate is good. Infact, I have tried several methods, but My Trainer recommend Idera.
“Got no idea? You need Idera! We’ve got just the right tools for all you SQL fools.Performance tuning, monitoring, backups or development.We’ve got you covered.”
160 exactly :-)
Answer: “No they don´t! I fixed them on the way with Idera SQL mobile manager while on the way to meeting.”
Well, use mssqlblocks, it is a a helpful tool to find blocks
1. Review the query, it is using index or not
2. Create proper index
3. Make query to use proper index
4. Rebuild index, if required and it is using index already
5. Review exectution plan for query, if it is using joins, to get some idea to write better join or another way to write qeury
Thanks, Virul
Oh! those dam indexes, forgot to create them!