dndaughtery (7/20/2016)

---

Hey guys, had one of my team members drop our main table by accident. Is there a way to prevent a table from being truncated or dropped? I tried...

There is an existing operator, schedule, notification framework for use by SQL Agent and SQL Alerts, and you may be able to leverage these existing tables. What you're wanting to...

We've all been in situations where the organization has a legacy application for which there is no designated owner; meaning that the developer who built and supported it left years...

Which aspect of this do you need advice on?

Create a table to contain one row for each DBA along with their contact details and what days of week / hours...

Steve Jones - SSC Editor (7/19/2016)

---

Eric M Russell (7/19/2016)

---

I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system...

I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system was being replaced completely with a new one,...

For one-off or infrequent formatting, there are several web-based options.

http://www.bing.com/search?q=online+t-sql+formatter

When working remotely, one will miss out on a...

Hash matched joins between very large tables will also do it. I once had to troubleshoot an ETL process that would run for days until eventually filling a 1 TB...

Many folks are willing to pay as much as 50% more for locally sourced food, thinking (for example) that milk or vegetables from China may be less wholesome and more...

Any difference in exeution time would be the result of T-SQL syntax pre-processing; one is probably just a macro of the other. All other things being equal, the actual compiled...

Even for those DBAs who work 8am - 6pm from the office, we bring our laptops home for on-call support. If we can handle emergencies remotely, then it's not that...

BTW, how and why were the additional URL parameters added to my above link?

Is this something new on SQLServerCentral?

I'm not sure if SQL Server Express Edition has the 'Default Trace' turned on by default or even if it supports event auditing in general. A google search gave no...

Also keep in mind that these users may be members of yet another domain (or local admin) group that has a SQL Server login. For example, confirm if 'BUILTIN\Administrators' has...