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

Guess how many 360 K floppies it would take to backup a 1 TB database. Also try to guess how much time it would take if you had one guy...

Fortunately nowhere near the number required to backup the database.

What was originally coined "NoSQL" should really have been NoACID, since they have since discovered that in order for their database platform to be marketable outside the realms of academia...