SE1986's user avatar
SE1986's user avatar
SE1986's user avatar
SE1986
  • Member for 6 years, 7 months
  • Last seen more than a week ago
  • UK
5 votes
Accepted

Implicit Conversion of VARCHAR Column to NVARCHAR does not cause expected table scan

4 votes
Accepted

Run Powershell Script From Agent As Administrator

4 votes
Accepted

Migrating SSRS 2008 to 2016 - ReportSync cannot see Data Sources

4 votes

Is there a default SELECT order?

4 votes
Accepted

XAMPP MySQL troubleshooting with MySQL Server

3 votes

Is it possible to make an index for an OR query?

3 votes
Accepted

Does differential backups and log backups contain users, roles and permission changes?

2 votes

How do I prevent changes to my PostgreSQL database?

2 votes

Why is a SELECT grant needed for an UPDATE statement on a table? (Error 1143)

2 votes

How to check the components that contribute to the size of the SQL data and log files?

2 votes

Combine two queries to one

2 votes
Accepted

I can't create a Database after I uninstalled SQL Server and then reinstalled SQL Server

1 vote

Activity Monitor duplicates in recent expensive query

1 vote

SQL Server Agent Server Login Account

1 vote

How to design a database with one-to-many and then many-to-many relationship?

1 vote

SQL Server 2008 R2 Auditing

1 vote

When is it ok to use an Index Hint on a query in production code?

1 vote

Connecting to the default instance of SQL Server connects to a named instance

1 vote
Accepted

Grant User permission to view XE results via sys.fn_xe_file_target_read_file

1 vote

Restrict use of tables

1 vote
Accepted

Whether the latest GDR from Microsoft includes all prior GDRs?

1 vote

What is a good way to get a time for the data freshness when the source is log shipped to another server?

1 vote

In SQL Server, how do I save the results of a query to a txt file?

1 vote
Accepted

Is mixed content in a column a bad design?

1 vote
Accepted

How SQL Server local account password rotation impact active user

0 votes

How to rename columns in an SQL-server database

0 votes
Accepted

Sql server migration side by side ( 2016 to 2019)

0 votes
Accepted

Cannot alter created role

0 votes

Query Store plan forcing failed with failure reason NO_PLAN

0 votes
Accepted

Why use an intent lock at a higher level in the hierarchy, why not just a regular lock?