Stack Exchange

George.Palacios

top accounts reputation activity bookmarks subscriptions
Top Questions
15 votes

During a log backup is the data backed up to the start or end of the operation?

sql-server sql-server-2012 backup transaction-log asked Oct 30, 2019 at 11:49
dba.stackexchange.com

12 votes

Is ALTER TABLE ... DROP COLUMN really a metadata only operation?

sql-server transaction-log alter-table asked Jun 27, 2019 at 16:14
dba.stackexchange.com

11 votes

How to check if a trigger fires on INSERT, UPDATE or DELETE statements?

sql-server trigger asked Oct 10, 2019 at 16:28
dba.stackexchange.com

9 votes

Dropping the automatically created NT AUTHORITY and NT SERVICE accounts

sql-server sql-server-2016 security asked Apr 29, 2019 at 12:46
dba.stackexchange.com

6 votes

Help with interpretation of execution plan (Hash Aggregation)

sql-server sql optimization execution-plan asked May 10, 2017 at 9:06
dba.stackexchange.com

5 votes

Bad row estimate following Compute Scalar operator in plan

sql-server sql-server-2014 optimization execution-plan cardinality-estimates asked Aug 21, 2018 at 8:04
dba.stackexchange.com

5 votes

Best practice around non-production databases refreshes and TDE

sql-server sql-server-2014 best-practices transparent-data-encryption asked Oct 1, 2018 at 11:52
dba.stackexchange.com

5 votes

Should I create two endpoints for two availability groups on the same SQL Instance?

sql-server sql-server-2012 availability-groups asked May 3, 2019 at 13:38
dba.stackexchange.com

5 votes

NOLOCK or Read Uncommitted locking / latching behaviours

sql-server locking isolation-level latch asked Jul 5, 2019 at 12:30
dba.stackexchange.com


Top Answers
24
How can wait times be higher than clock time?
dba.stackexchange.com

18
Does a non-clustered index make any guarantees about row order?
dba.stackexchange.com

16
How many rows can SQL Server process in a single INSERT statement into a table?
dba.stackexchange.com

16
RAID0 instead of RAID1 or 5, is this crazy?
dba.stackexchange.com

15
Limit max CPU usage SQL SERVER with WSRM
dba.stackexchange.com

15
.NET executes a SQL query and Active Monitor shows multiple rows blocking each other
dba.stackexchange.com

13
Multiple BIT datatype columns in the same table
dba.stackexchange.com

12
How to check if a trigger fires on INSERT, UPDATE or DELETE statements?
dba.stackexchange.com

10
Permutation and Combination of words
dba.stackexchange.com

9
Why did a SQL Server Restart roll-back seemingly committed transactions?
dba.stackexchange.com

9
Do primary keys change when indexes are rebuilt or reorganized?
dba.stackexchange.com

9
Using `min_active_rowversion` for global temporary tables
dba.stackexchange.com

8
How to access a SQL Server database using another user with permissions in the same intranet
dba.stackexchange.com

8
Creating database with only ldf file created 2 .ldf file
dba.stackexchange.com

7
Creating indexes after data load Vs Before data load in a large table
dba.stackexchange.com

7
Concurrent backups in MS SQLServer 2008 R2
dba.stackexchange.com

7
Count down from 0 to 5 seconds and repeat
dba.stackexchange.com

7
Does Service pack have all the changes in a cumulative update
dba.stackexchange.com

6
Substring without the first n characters
dba.stackexchange.com

6
Why do case/iif return nullable datatypes?
dba.stackexchange.com

6
performance benefits of shrinking a database
dba.stackexchange.com

6
How do I find out when a node was added to an availability group?
dba.stackexchange.com

6
Dynamic SQL query - how do I add an int to the code?
dba.stackexchange.com

6
SQL Server Always-On Availability Groups Patching
dba.stackexchange.com

6
Drop all databases based on age
dba.stackexchange.com

5
Split Brain Administrators
dba.stackexchange.com

5
Is NEWSEQUENTIALID unique within a database for Many tables?
dba.stackexchange.com

5
Best practices for committing a transaction in SQL Server where TRY CATCH is used
dba.stackexchange.com

5
I do not perform SUM with conditions in SQL Server
dba.stackexchange.com

5
Backup MS SQL AG on a non-production environment
dba.stackexchange.com

1 2