SanDroid (12/13/2010)

---

Jeff Moden (12/11/2010)

---

MS should concentrate on doing more useful things.

.... Make any of the DBCC functionality more difficult to use? Heh... no way!

Leave these things...

I would also add that IF(and that's a BIG IF) you are going to do this knowing that the file will immediatley grow again considering change the growth factor from...

No, DBCC SHRINKDATABASE and DBCC SHRINKFILE should not be removed. However, even if they are fixed to prevent excessive fragmentation, it would probably be much slower than it already is...

Yes,you can do that or just comment that clause out and you will see more...:-D

After conversing with SanDroid, I have amended this query slightly so that the schema name and indid is displayed as well. Not all of you may need to see...

Please do remember that sysindexes.rowcnt is only as correct as your latest indexes and stats are up to date. If you have not done this in a while then that...

Way too complicated of a solution for what is needed here. Here the information is in one SELECT statement from three system tables that gives you all the same...

This does not work with selfish managers out for...

😛

I normally wouldn't advocate NOT working with your employer, but this has attempt has been met with everything from ambivalence to me, to outright hostility. If you're opening the...

All the moves I have made over the years, voluntary or not, have resulted in me being in the best job I've ever had. Better hours, pay, benefits, working...

Andy Warren (11/27/2010)

---

This is one of the areas where having an agent, usally someone from a staffing company, makes a lot of sense, it shields you from having to ask...

Well, it depends on what is revealed in the actual interview. In the past, I have been told things in a phone interview that was very different from what I...

There is no such thing as a 10 in anything IMHO, particularly as fast as SQL Server is changing these days. If someone tells me that in an interview my...

Me too Paul. I also like to know who (or prevent) might be modifying tables, so I like DDL...

Great product. cheaper, and does not crunch the boxes resources like Quest Spotlight or Idera SQL DM do! 😀