Interview question I hadn't heard before. Thanks.

Can you be more specific as to why or why not better performance please.

I was using wrong Performance condition :pinch:. Try Object SQLServer:General Statistics and the Counter: Processes blocked.

Ninja's_RGR'us (8/11/2011)

---

SQLHeap (8/11/2011)

---

GilaMonster (8/11/2011)

---

Add ID as a 3rd key column to this index:

CREATE NONCLUSTERED INDEX [N2] ON [dbo].table

(

field_name2 ASC,

...

GilaMonster (8/11/2011)

---

Add ID as a 3rd key column to this index:

CREATE NONCLUSTERED INDEX [N2] ON [dbo].table

(

field_name2 ASC,

...

Ninja's_RGR'us (8/11/2011)

---

I'm guessing this is a local db on a slow disk subsystem so if you have GBs of data to read then yes this will take a long time.

Without...

The id field I'm getting the max from is not the primary clustered index, it is just another column (ID).

CREATE NONCLUSTERED INDEX [N2] ON [dbo].table

(

field_name2 ASC,

field_name1 ASC

)WITH (PAD_INDEX =...

It appears to have been a FK issue...the error msg totally threw me off.

I've even tried to move the object that it's saying is there to a different schema and I get:

Msg 15151, Level 16, State 1, Line 1

Cannot find the object 'sample',...

The query you posted returned 1 row verifying "dbo, sample, U". I've checked views, procedures, everything I can think of.

Oops. Here is a query (sql2k compatible) that I use regularly for that.

SET NOCOUNT...

Ofer Gal (5/11/2011)

---

On the SQL server I only have PS1

and the hard way gives me error:

Unexpected token 'in' in expression or statement.

At D:\Temp\freeInDB.ps1:11 char:40

+ $cmdStatement+=foreach ($DFileGroups in <<<< $db.FileGroups)

I...

Where can I get this cmdlet Get-SqlDatabase? Am using PSv2.0, SQL08, WinXP.

"The term 'Get-SqlDatabase' is not recognized as the name of a cmdlet,"

Ok, here is a PS script that is a bit more friendly for multiple subnets. The only downside here is that you will need to know (or get a...

Thanks for your responses! I have what I was looking for with your help.