Not much advice we can give you here as you haven't given us enough information to really help you out.

If you could provide details about the query that exploded the...

How about something more like this:

select

product_id as Product_ID,

round(cast(sum(case when purchase_id in (4,5) then 1 else 0 end) as float)/

...

We had our moments, but, overall it was good! Friends went a got Kassondra for a couple days...

There has been several...

I use a SQL account with admin access when working from home. I can't start and stop the SQL Server services using this account. If I need to,...

Well, I can't defend this one. I have to agree, what good is it to create the job if you can't run it?

The more you understand waht a DBA does the better. Not so you can argue with him or her, but so that you understand why they do the things...

For general information regarding BACKUP and RESTORE I'd start by reading BOL (Books Online, the SQL Server Help System). Your question is really quite open and I'm not really...

Thanks Jeff. I fixed the link. 😉

And if you look around this forum, you will also find that for 99.9% of the time that you think you need a cursor, guess what, you don't.

A majority of...

I can probably tell you what she would say, the same thing as the rest of us. When setting the autogrowth it is best to set it in MB...

And, based on the sample data provided, what should our expected results be so we know if our code is correct.

Looking at this:

We have a page that searches for Field Orders. Normally, this search take about 5 seconds. On a bad day it takes about 20 seconds. Now it is...

Curious. A few things if I may ask, can you provide details regarding your server configuration (memory, processors, x64 or x32 (I'm assuming x64), OS and version, SQL Server...

You may want to check both the Share and NTFS permissions for the account on the server the remote file is located.