Chad Mattox's user avatar
Chad Mattox's user avatar
Chad Mattox's user avatar
Chad Mattox
  • Member for 7 years, 11 months
  • Last seen more than 7 years ago
13 votes
Accepted

Clustered Index Scan (Clustered) vs. Index Seek (NonClustered) + Key Lookup (Clustered)

12 votes

How to hide/disable tables without dropping them to check redundancy?

11 votes
Accepted

Are auto incrementing identities always given in the order of inserts in SQL Server?

11 votes
Accepted

Is total_elapsed_time in DMV sys.dm_exec_requests completely inaccurate?

11 votes
Accepted

Same code in multiple stored procedures

7 votes

How to select column names by data type

6 votes

Does SQL Server require more RAM to hold columnstore indexed tables than traditional rowstore?

5 votes

Is IFI compatible with tempdb growth?

4 votes
Accepted

Understanding of SQL Server active/active cluster

3 votes

Dropping PLE on query

3 votes
Accepted

Copy one database to another (existing) database on the same server

3 votes

Selecting one row from each group based on a Varchar field

3 votes

In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?

3 votes
Accepted

Stopping SQL Server Log Reader Agent In 2012

3 votes

What type of SQL Server Replication Allows Modifications

3 votes
Accepted

Databases created with different collations - why?

3 votes
Accepted

DR Site availability if primary goes down

3 votes
Accepted

Create a user account login that cannot login from SQL Server Management Studio

2 votes
Accepted

SQL server Like pattern match with CONCAT() always fails

2 votes

Geography data type and Upgrading from 2008 r2 to SQLServer 2014

2 votes

Cannot read from secondary availability group

2 votes

T-SQL for Query that can be done in SQL. What do they want?

2 votes
Accepted

Simple SQL question

2 votes

Sql service account password change for environment on Availability groups 2012

2 votes
Accepted

Return only one row from table with similar values in column that match a criteria

2 votes

Distributed database implementation in sql server

2 votes

Migrate Database

2 votes
Accepted

Nonclustered index Seek

1 vote

Performance issues with partial join query

1 vote

moving to SQL Enterprise 2014 from Standard 2012