You're welcome.

You have 400-million tables, or 400-million values that go into a single table? Or something in between?

A key question here is, are the regions reasonably static? You have Australia in there. How likely is that to go away, or be split in two, or...

Peter Schott (12/15/2011)

---

Important part of Win7 security, which I did not mention in my initial post, is that you cannot install an app on the phone except from the MS...

Right-click the database in Management Studio, go to Reports -> Standard Reports -> Disk Use by Table. That'll give you the disk space used by each table, and the...

What you're looking for isn't an output parameter.

Output parameters look like this:

create stored procedure dbo.Hello

(@YourName_in varchar(100),

@Hello_out varchar(100) OUTPUT)

as

set @Hello_out = 'Hello ' + @YourName_in;

You assign a value to them in...

I always skip the ones with low page counts, and usually skip the ones that don't have any range scans. Fragmentation doesn't really impact single-row seek performance, after all.

What are the page counts on the indexes that don't defrag? (http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-2-size-matters/)

Edit: Trumped while looking for the reference!

valeryk2000 (12/15/2011)

---

Thank you DA, TB & GS!

The reason I asked is that in the past I had a problem with try/catch when parent proc did not catch the error in...

Not really. If you want to have the database store native UTF-8 strings, you need to store the binary represenation in a varbinary or binary datatype column.

Yes.

Try this:

CHECKPOINT 60;

Issue that command from the database you are trying to shrink the log file for.

Once that runs, run DBCC ShrinkFile on the log file you are trying to...

I already replied to that separately.

L' Eomot Inversé (12/15/2011)

---

GSquared (12/14/2011)

---

(Sorry. I consider English a toy. Periodically, I break it and need to get my parents to buy a new one. Or something...

It depends on whether any of the sub-procs will ever be used independent of the parent proc, whether any of them have different error handling needs from others of them,...