I've been spending my SSC time on the general forums instead of The Thread for the last few day.

It's the same point I've been making for over a decade, that most people don't need the latest and greatest in high-power computers. I know lots of people for...

In that case, I think the exe you're calling may be returning something to SQL that it recognizes as an error code. Try this:

declare @Err int;

exec @Err = master..xp_cmdshell...

That's where it will probably end up. It's going to be considerably more...

I haven't had a chance to use them in a production environment, so really can't say how they do under real loads.

The length of an object's name has no effect on performance.

Do you have the create scripts for all of them? If so, put all of those into one big document, and then run that.

If not, then I recommend you...

Honestly, I set tempdb on autogrow, set the growth increment to half a gig or so, and leave it that way. Some systems, I set it to a full...

Have you tried running:

exec master..xp_cmdshell 'E:\PROGRA~1\CA\SERVIC~\bin\bop_cmd.exe'

Also, have you tried that with the full path enclosed in quotes, instead of the 8.3-style path?

The simplest way is to add a rebuild task to a maintenance plan that you run weekly.

Anything more complex than that, you'll need to decide what rules it needs to...

I know how it goes. I ended up as the DBA from a sales and marketing position (9 years ago).

I'm working on a highly automated maintenance solution currently. ...

Is drive E a local drive, or a mapped drive on the network?

repent_kog_is_near (10/1/2009)

---

For TempDB, I monitor the size for a period of time, and then I fix the size of TempDB to the size where it held steady. Should I use...

notquitexena (10/1/2009)

---

GSquared (10/1/2009)

---

I'm firmly in the "incremental improvements" camp. Build something that does something useful for the users. Then add to it incrementally and constantly review for potential...

If you can do sparse columns, that would be ideal. If not, EAV is a very workable way to do this. Yes, it has some drawbacks, but it's...