I reckon they're gonna send a dba into space with an ipad, to show how easy it is to manage your sql servers remotely.

I'll volunteer if I get to keep...

Thanks for the article. As has been pointed out, the stored procedure is not required, as there is a better way. (And I'm sure Olga will agree.)

However, if...

Firstly apologies, Mohammad, for the obscenely long reply.

Before we look at the results, let me just say that the test data, and code that I used are those that I...

Looks like a very innovative and interesting approach.

_ms65g_ (4/12/2011)

---

Can you demonstrate your technique for matching current rows with previous and next values is faster and more efficient as my best...

Hi Jeff.

I'm aware of the consequences of changing these settings.

Actually I'm not even changing them - the question relates more to scripting the existing setup. I know...

Steve Jones - SSC Editor (4/5/2011)

---

David McKinney (4/5/2011)

---

Hi Steve,

I agree with you on the overall. However, I didn't quite understand your specific reference to the "brilliant" duplicate indexes...

Hi Steve,

I agree with you on the overall. However, I didn't quite understand your specific reference to the "brilliant" duplicate indexes note.

Could you expand on this?

Thanks and regards,

David.

...and if you can't be bothered to click all those links....

SELECT so.name, schema_name(so.schema_id) FROM sys.sql_dependencies sd

INNER JOIN sys.objects so on sd.object_Id=so.object_id

where is_select_all=1

I believe I have what I'm looking for in why-you-cant-trust-sysdepends by Thomas LaRock.

I found it thanks to a an article By Aaron Bertrand on PBM who directed me to todays...

Raghuram (AJ) (11/30/2010)

---

I just thought I should share an article[/url] by Thomas LaRock (SQLRockstar) on possibly a better & way more practical option to avoid SELECT *. Keywords: sysdepends &...

crazy thought....I don't suppose looking at query plans, instead of query defintions is going to get me anywhere useful? Any thoughts?

Thanks, guys.

I think I'll make a suggestion to Redgate as an enhancement to the refactoring functionality in sql prompt. It can already identify the * as it proposes the...

Are the collations the same on all of the sql databases? If not, you will have trouble with things such as temporary tables, which use the collation from the...

It's not a hidden partition, per chance.

If you go to Disk Management in the control panel under Computer Management, do you see the same thing?

Don't mean to repeat myself, but are you sure the disk is really 149gb and not 149000000 kb?