The FQDN is only validated by the GUI, so you can use an IP address if you stick to TSQL to set the partners. You can use the hosts...

I work with a similar environment albeit not at the same scale, and I'd certainly be interested in anything on this topic - I'm sure I'll hit a lot of...

The estimated stats are not representative of the actuals ... the topmost nested loop join estimated 1 row but actually returned 36773. Outdated stats or parameter sniffing are the...

http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/09/25/387.aspx

The first and second articles offer the bulk of the argument. Good reading regardless of whether you agree.

Hmm, was editing as you posted ... I'll have to profile. Thanks for your time.

That query returns GET_NEXT_INC_BLOCK as expected.

That is the entire content of the proc after I strip out the parameters and the comments.

It's possible that this was part of a larger...

You could also look at Hyperbac.

Thanks Gail, I see how you are reading the graph now (the articles I looked at were not entirely clear).

The proc is executing the following code

DECLARE @LastValue...

You could try using the IP address, ALTER DATABASE MyDB SET PARTNER = N'TCP://127.0.0.1:5022';

I'm not entirely clear on your problem, it sounds like you add the file that you want to restore from but it doesn't display any valid backups in the list....

Robert Davis (9/24/2008)

---

matt stockham (9/24/2008)

---

Re. inserts ... wouldn't it have to write an entire page of null bytes, so still the same data size?

Logically it shouldn't need to...

Re. inserts ... wouldn't it have to write an entire page of null bytes, so still the same data size?

Logically it shouldn't need to do anything at all...

Depends on the situation, but if this is in-house and you aren't sending the SP out to anyone then just grant execute rights on it. If you don't want...

To do that requires that you have a list of email addresses ... hardly seems worth doing this in SQL. If you are trying to alert users that the...

Nice article. I have a few questions:

1) why do inserts scale so much better than updates and deletes on a workstation? A page is a page, assuming that...