Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 13 years, 1 month
  • Last seen this week

216 Offered bounties for 47,850 reputation

3 votes
1 answer
668 views
+50

What is "execution count" in Query Store?

1 vote
0 answers
600 views
+100

List parameters and their values while inside a stored procedure

1 vote
0 answers
600 views
+50

List parameters and their values while inside a stored procedure

1 vote
1 answer
168 views
+50

move mySQL 5.6/InnoDB tables to a different physical location

17 votes
2 answers
19k views
+300

Is there a way to insert multiple rows into a table with default values for all columns?

17 votes
2 answers
19k views
+150

Is there a way to insert multiple rows into a table with default values for all columns?

2 votes
2 answers
3k views
+100

Possible for two simple updates on the same table to deadlock?

22 votes
2 answers
2k views
+150

How to prevent statistics creation on a column?

5 votes
1 answer
4k views
+150

AppDomain 2 SSISDB is Marked for Unload due to Memory Pressure

3 votes
1 answer
2k views
+100

Changing Database Encryption Keys

6 votes
2 answers
435 views
+250

Multiple Set Quoted_identifier within one script takes the last one?

0 votes
4 answers
635 views
+100

Why is it considered that a set unnormalizes a database absolutely?

7 votes
2 answers
473 views
+200

Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?

3 votes
2 answers
560 views
+100

SQLServer Row level security - Enforce from within database

4 votes
3 answers
2k views
+150

SQL Server keep reverting to inefficient plan (Clustered index Scan) once a week

7 votes
2 answers
473 views
+100

Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?

11 votes
1 answer
185 views
+200

Inline Scalar UDF Under RCSI - Can Results Differ

27 votes
1 answer
1k views
+500

Splitting Snapshot files with MaxBCPThreads for Transactional Replication

9 votes
1 answer
1k views
+500

Key-range RangeI-N lock compatibility in SQL Server

1 vote
3 answers
638 views
+500

Are there any reasons why a table wouldn't show in sys.dba_tables? (Oracle)

4 votes
2 answers
14k views
+500

Find rows with similar string values

11 votes
4 answers
1k views
+500

Shouldn't Operator cost at least be as large as I/O or CPU cost that comprises it?

10 votes
1 answer
1k views
+500

Is it possible to re-use a query plan from the plan cache from one database in another database?

22 votes
3 answers
1k views
+500

What is the correct result for this query?

37 votes
3 answers
9k views
+500

Why would a SELECT query cause writes?

4 votes
1 answer
2k views
+500

Generating sequences partitioned or grouped by field(s)

5 votes
1 answer
529 views
+500

Constant Scan joining

7 votes
2 answers
14k views
+500

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

20 votes
1 answer
2k views
+500

Nonclustered index storage on clustered columnstore

7 votes
3 answers
1k views
+500

Is there a limit to how many backups can be appended to a single file?

1
2 3 4 5
8