Having taken a cursory look at GSquared's code, I'd give it a try.

Gift, he is trying to look at the code behind the system views which is not possible by right clicking on the view in the Object Explorer in SSMS.

Okay, so let us take another tact. Let us start with a table of customers across the US. You want a list of customers in California, for instance.

Here...

Bru Medishetty (12/1/2009)

---

dmoldovan (11/30/2009)

---

Also if you do bulk data import / inserts, change the recovery model to "bulk logged" or "simple". BOL will guide you through the steps you need...

Will STARTUP_TIME always be greater than SHUTDOWN_TIME, SLEEP_TIME or HIBERNATE_TIME?

You could try looking up CONVERT in BOL (Books Online).

select convert(varchar(10), getdate(), 108)

Do you mean DDL (Data Definition Language) or DLL (Dynamic Link Library)?

Double posted, please reply here.

It is obvious that this procedure has not been run on a regular basis on the DEV system. You are going to have to modify the procedure there to...

RCC-JAXDBA (11/30/2009)

---

The best way to handle this in a production environment is to cap the size of the log file so it does not fill up the entire disk or...

My thanks to you also, Steve. Keep up the great work, you are a terrific steward for this community. I have learned more about SQL Server since becoming...

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...