I learned that missing piece of information with log shipping and readable copies.  You can do log shipping with the copy on a newer version of SQL Server, but you...

I completely agree.  As the question is written, the correct answer based on the documentation provided is that it can be adjusted both up and down.  Per the documentation, adjusting...

Beyond what others have stated, this will have many false positives.  Triggers that reference INSERTED and DELETED will show as invalid.  Excluding these is pretty simple.  However, update and delete...

Xml is indexable with the restriction that it is the only key column.  See https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15.

If the question was worded as "Which of these data types are not allowed...

GETDATE() returns the datetime of the server executed against.  The AT TIME ZONE clause tells SQL that the datetime returned from GETDATE() is at the time zone US Mountain Standard...

Technically, none of the choices are correct.  Datetimeoffset is 34 characters in length.  The length of @C truncates the value returned and results in "2018-09-03 11:55:34."  Changing the...

The query provided to detect heaps will also return table valued functions. The query below will return only user tables that are heaps.

SELECT

OBJECT_SCHEMA_NAME(i.object_id) AS SchemaName

,OBJECT_NAME(i.object_id) AS TableName

,i.*

FROM sys.indexes i

INNER...

I have moved the resource database in previous version of SQL Server. Although, I do not recall if it was 2005 or 2008. I found an interesting quirk...

Without knowing the answer or what the query store is, this question is guessable with a solid understanding of the system databases. But, it got me to thinking. ...

Sean Lange (6/4/2015)

---

Robert Eder (6/4/2015)

---

The problem with script A is the constraint name will be system generated. Script B is also written to use a system generated name. ...

The problem with script A is the constraint name will be system generated. Script B is also written to use a system generated name. It is best practice...

I use BEGIN and END for readability. Though, I have been doing this for years, it was only recently that I was burnt. I passed the stored procedure...

There is a saying that locks keep honest people honest. The same holds true for any security scheme. Yes, a rogue administrator could get into SQL through this...

It is worth mentioning that after a repair with data loss, not only is the corrupted record lost, but the whole data page. The good news is that with...

Each programming language has its advantages and disadvantages. Problems are found with a programming language, so another one is created. To a large degree, ones personal opinion about...