Skip to main content
HandyD's user avatar
HandyD's user avatar
HandyD's user avatar
HandyD
  • Member for 6 years, 8 months
  • Last seen this week
15 votes

transaction log in RAM or physical file?

14 votes
Accepted

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

11 votes
Accepted

Why is dropping a primary key expensive?

10 votes
Accepted

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

7 votes
Accepted

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

7 votes

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

6 votes
Accepted

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

6 votes
Accepted

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

6 votes
Accepted

How to delete rows from relational database

6 votes
Accepted

Truncate all Tables in Database with T-SQL

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

Piecemeal restore only one filegroup without primary filegroup restore

5 votes

How does the disk and file share witness work?

5 votes
Accepted

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

5 votes

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

5 votes
Accepted

Hidden operation of rebooting a SQL server database

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

4 votes
Accepted

How can I add time and date to a query output file name in sql server agent job

4 votes

sp_MSforeachdb Continue on failure when running DBCC CHECKDB

4 votes

Exactly same query and plan but different duration and total reads. I Know parameter sniffing but

4 votes
Accepted

Are stored procedure query texts stored in any tables?

4 votes

SSAS database backup

4 votes
Accepted

Not able to update one of the key value by using JSON_MODIFY function in SQL Server

4 votes

Initial Full Backup required for Filegroup Backups?

4 votes

Moving from Azure to Hyperscale

1
2 3 4 5
13