user avatar
user avatar
user avatar
HandyD
  • Member for 4 years, 10 months
  • Last seen this week
15 votes

transaction log in RAM or physical file?

12 votes
Accepted

Can I connect to the database as the user "dbo"?

11 votes
Accepted

Why is dropping a primary key expensive?

8 votes
Accepted

How we can we know SQL Replication components installed in SQL server

7 votes
Accepted

Does the SQL Server Service Account have to have access to a network share to perform a backup?

7 votes
Accepted

PowerShell command 'New-Item' fails when invoked through SQL Server Agent job

6 votes
Accepted

How to delete rows from relational database

6 votes
Accepted

SQL Server: Should the same log records be backed up multiple times?

5 votes

MS SQL Server 2014: which stored procedure is my error in?

5 votes
Accepted

How to verify Force Encryption is enabled for SQL Server

5 votes

How to use GROUP BY in a way concatenates data in one column, but filters for specific data in another

5 votes
Accepted

SQL Server RAM usage - how to find out where it is going?

5 votes

Can I bulk insert into an empty page-compressed table and get full compression?

5 votes
Accepted

70-761 Practice exam Question about @@Trancount final value

5 votes
Accepted

What happens when there's no tempdb space for version store operations?

5 votes
Accepted

minimum space is required on disk to restore a backup in SQl Server?

5 votes

Strange JOIN ON clause in T-SQL

5 votes
Accepted

Truncate all Tables in Database with T-SQL

5 votes
Accepted

Hidden operation of rebooting a SQL server database

4 votes

What does non clustered index points to when the table has clustered index that is not unique?

4 votes
Accepted

Update Rows From Table If Table Exists Without Using sp_executesql

4 votes
Accepted

On premise to cloud restore - Automated?

4 votes
Accepted

What is the word that means a query predicate can use an index

4 votes
Accepted

Parameterized Plan Flushed

4 votes

Best practices for committing a transaction in SQL Server where TRY CATCH is used

4 votes

How to properly implement relationship between a user and multiple other users

4 votes
Accepted

database_xml_deadlock_report or xml_deadlock_report

4 votes

How to tell which windows group login I used when logging in via windows authentication

4 votes

Explain an OVER clause

4 votes
Accepted

Piecemeal restore only one filegroup without primary filegroup restore

1
2 3 4 5
13