stevefromOZ (6/29/2009)

---

Hey Mark,

So you have the sub-report set on your main report? It's not clear whether you got the pie slice to relate to 'another report' (ie not a...

Got it... SET FMTONLY OFF is the...

Umm when I do that I get the following error:

Msg 195, Level 15, State 5, Line 1

'FORMAT_ONLY' is not a recognized SET option.

Thanks on that regard.

I'm still having trouble with this sproc though. It's evaluating my SQL in some shape when I tell it to use EXEC usp_rpt_get_supportqueue_piechart as the query...

Is this a limitation of RDL? I come from a crystal background. Crystal ran the procedure and produced the fields that it could report on based on the...

Sadly, it's not a procedure.

I'm not in a position to dictate that all queries on the system will go through sprocs... this is SQL thrown at the server. In...

Jeffrey Williams (6/25/2009)

---

nscott (6/24/2009)I have 400 GB of free disk space on the SQL server. For log properties, initial size = 195 MB; autogrowth = By 10 MB, restricted...

You could try forcing a checkpoint and then doing a tlog backup.

i.e.

CHECKPOINT

BACKUP LOG [databasename] TO DISK=""

If you've got a pretty busy system or one with long running transactions the...

I concur with Jeffrey. With it being a 24/7 operation I'd look at daily fulls, every 4-6 hours doing a differential and 15 minute t-log backups.

Where I'm at I...

Sorry I got to this one late. FWIW sp_attach_db is deprecated in favor of CREATE DATABASE FOR ATTACH.

I wrote this handy dandy sp that I use to basically...

I prefer the maintenance plans. Not wizard driven, I drag and drop the parts I need.

Why? Because awesomely well scripted tasks still run into reporting issues when they...

viji (6/16/2009)

---

hi,

i have a doubt.

PK-FK constraints will improve the performance with respect to speed

or will it slow down while inserting, updating......?

it's going to be single row insert or update not...

I was going to...

gserdijn (6/15/2009)

---

Another one who chose NCHAR(1). The Netherlands, no score.

Amidst the 12 pages of reactions I found this:

What did I miss? Where can I...

peggy.gaines (6/9/2009)

---

I've noticed the book 'Pro SQL Server 2005 High Availability' has been recommended in this thread. Looks like I'm going to have to purchase this one on my...