Skip to main content
John's user avatar
John's user avatar
John's user avatar
John
  • Member for 8 years, 1 month
  • Last seen more than a month ago
10 votes
Accepted

Querying True Physical Database File Sizes

9 votes

How to check for Non-Ascii Characters

8 votes

Query to report disk space allocation and used space

7 votes
Accepted

Please explain the difference between row and page compression

2 votes

Union of results of all database query to also include database name

2 votes

Fix line by line parameterization in a table

2 votes

Is it legal for SQL Server to fill PERSISTED columns with data that does not match the definition?

2 votes

Validation of Partitioned table Performance

2 votes

Is it okay to have a fill factor of 100 on the clustered index that is on an ID column?

1 vote

Msg 1833, File 'ABC.ndf' cannot be reused until after the next BACKUP LOG operation

1 vote

Include logical key on each table vs. join

0 votes

What's the best way to archive all but current year and partition the table at the same time