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...

Short answer: Yes

Longer answer:

https://technet.microsoft.com/en-us/library/ms345392(v=sql.105).aspx

Scalable Shared Databases Overview

The scalable shared database feature allows you to scale out a read-only database built exclusively for reporting purposes (a reporting...

null

Chitown (7/14/2016)

---

When I run the select * from the table, it returns 100K records in 6 minutes. I deleted top 10 records and it took almost 50 seconds (5 seconds...