all groups > sql server programming > june 2007 >
You're in the

sql server programming

group:

What do you do when queries are running?



What do you do when queries are running? Pat
6/28/2007 9:23:33 PM
sql server programming: Hi Friends,
I am it's happening to most of you that while a query is running,
let's say for 4-5 min, you don't have anything else to do just waiting
till it is finished.

most of the times it's becoming very boarding and frustrating to wait,
specially if the data size is big enough to cause that type of delays.

My question is that, what do you usually do between those times while
you are waiting for queries to execute?

Your SQL Friend,
Pat
Re: What do you do when queries are running? Erland Sommarskog
6/28/2007 10:15:53 PM
Pat (PatrickAlexander.email@gmail.com) writes:
[quoted text, click to view]

It does happen that I go into the newsgroups to answer a post or two...


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
Re: What do you do when queries are running? Will Alber
6/28/2007 10:41:04 PM
I'd usually run up profiler against a production server, and look for long
running queries / high I/O etc. etc., and optimize the heck out of them...
:)

Either that, or have a ciggie!

[quoted text, click to view]

Re: What do you do when queries are running? TheSQLGuru
6/29/2007 12:00:00 AM
I am usually doing umpteen things at once, especially when onsite at a
client, so I don't will just flip over to the next task in my queue.

Like Erland I may answer a forum post or two as well. I don't play guitar
nor smoke, but I do occassionally surf and also look for bad queries to
optimize. :)

--
TheSQLGuru
President
Indicium Resources, Inc.

[quoted text, click to view]

RE: What do you do when queries are running? ML
6/29/2007 1:56:03 AM
I keep a guitar close to my server. Then, sometimes, the server has to wait
for me.


ML

---
RE: What do you do when queries are running? Bob
6/29/2007 3:34:00 AM
Surf dude! Read Books-Online to learn something new.

You can write CTEs from your head can't you? Have you seen the new OVER()
clause?

Seriously tho, if you're just doing a bit of analysis, maybe you should
limit your queries to say TOP 100, or TOP 1000, your brain can't possibly
understand more rows. Also, ask yourself should your queries be taking that
long to run? Do you have the right indexes? You're not using CURSORs are
you!? ; )

wBob

[quoted text, click to view]
AddThis Social Bookmark Button