Skip to main content
T.H.'s user avatar
T.H.'s user avatar
T.H.'s user avatar
T.H.
  • Member for 7 years, 2 months
  • Last seen more than a month ago
5 votes

Transaction log is full changing column type in a large table

5 votes

Set TRUSTWORTHY On smacks down service broker from working

3 votes

Best Way To Migrate Existing Production Database To New Physical Storage Structure

3 votes

Factors to consider while Rebuild/Reorganize of index in SQL Server 2012

3 votes
Accepted

Advanced job flow control

3 votes

Finding reason for page splits

2 votes

Method (Policy Based Management, DDL Trigger, whatever) to prevent logins with sysadmin from granting sysadmin to other logins

2 votes

High number of undistributed commands after a "An existing connection was forcibly closed by the remote host" event

2 votes

What can be the downside of always having a single integer column as primary key?

2 votes

Restricted logins with automatic full permission in databases

2 votes

Load testing: The performance of a query is decreasing as the number of parallel executions is increasing

2 votes

Does taking a log backup, truncating the log, and then deleting the tlog backup break the LSN chain?

2 votes

Performance issues after moving a database to SQL Server 2014

1 vote

Running job in endless loop

1 vote
Accepted

Identify Full Text Catalog Files

1 vote

SELECT query slow even with nonclustered Index and a full-text index

1 vote

SELECT query slow even with nonclustered Index and a full-text index

1 vote

What is the best practice for selecting from two tables with multiple relations?

1 vote

Performance issues after moving a database to SQL Server 2014

1 vote

Why does a select query require an IX lock?

1 vote

In SQL Server, how do you create a default constraint for a column using the result or return value from a Stored procedure?

1 vote
Accepted

Turning on RCSI on on-prem CRM 2015

1 vote

How to Export Table sql to Excel file in sql server 2014?

1 vote
Accepted

Wrong no of actual rows and why did statistics update help here?

1 vote

Restricted logins with automatic full permission in databases

1 vote

Can't create a server role using GUI in SQL Server 2014 Express

1 vote

Does anyone ever use database sequences that count down from 2^64-1?

1 vote

Instance Recovery in SQL Server?

1 vote

Detect if only one column is changing in a trigger

1 vote

SQL Server 2016 replication between Windows 10 and Windows Server 2012