I've never seen someone asking for academic credentials when they are looking for a DBA, it's always x years of experience.

If someone is looking for a junior DBA, they'll know...

Jeff Moden (6/21/2011)

---

Oliiii (6/21/2011)

---

I can see why xp_cmdshell is useful for a DBA and some maintenance task.

But i don't see why any dev would be allowed to use it?

Do you...

I can see why xp_cmdshell is useful for a DBA and some maintenance task.

But i don't see why any dev would be allowed to use it?

Do you have an example...

Use BCP.exe or create an SSIS package.

It's probably less of a pain to uninstall and reinstall SQL Server, but if you want to do it this way it should work fine, just make sure you put...

SQLCMD is not made to export a large amount of data, so there are no efficient or easy way to get around some of the limitations.

Use BCP.exe if you need...

We've stopped using xp_cmdshell on all new instances (nearly all 2008 and better).

It's still available on SQL 2005 and 2000 though, mostly for all the maintenance jobs and procedure.

We only...

Depending on the number of rows and the number of sparse column in your table you might not see any differences in size.

You can use this to see all the...

You don't make a decision on the lack of memory of a server by looking at the target memory.

You check the perfmon counters related to memory (Lazy Writes, page life...

And how do you infect a mdf or ldf file?

It's the standard behavior to ignore .mdf and .ldf files in specific directories, you could also ignore a few other file...

Yes, i don't think SQL Server has any restrictions on IP addresses, it just need to know where to listen.

To know about the subnet mask, ask your network admin, he's the one who knows.

But looking at the IP address you have it's most likely 255.255.255.0.

For the network to use...

Forcing join type is also useful when you are looking for ways to optimize a query and you would like to see what's missing to get a more efficient join.

Maybe...

We've had to do the same thing here (date ranges were a bit different though), we ended up doing what was suggested above, a partition a day with jobs taking...

First of all if there was no bottleneck the speed would be unlimited and result instant, there is always a bottleneck, you just have to find it. It might be...