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

Sometimes the problem is that management does not want to hear that you don't know how to do something. I have been faced with this several times. On...

In my 18 year career, I have not been fortunate enough to have my employers invest in me through training. The majority of my training has come from my...

Microsoft has an outstanding recommendation for the maximum password age, a multiple of seven. The reasoning behind this is simple: your password will never expire on a weekend. ...