Skip to main content
mrdenny's user avatar
mrdenny's user avatar
mrdenny's user avatar
mrdenny
  • Member for 13 years, 5 months
  • Last seen more than a month ago
38 votes
Accepted

Why are Denali sequences supposed to perform better than identity columns?

33 votes
Accepted

Efficency of stored procedures vs raw queries

30 votes

On a dedicated database server, how much memory to reserve for the OS?

29 votes
Accepted

What standard should I follow when naming tables and views?

27 votes

Check constraint only one of three columns is non-null

24 votes
Accepted

CREATE FILE encountered operating system error 5 (Access is denied.)

22 votes
Accepted

When is it appropriate to use SQL Server Developer Edition?

21 votes

Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?

21 votes

Using SQL Profiler on a database that's in production

20 votes

Restore exceeds licensed limit of 10240 MB per database. All I really need is the DB structure

17 votes

MAXDOP setting algorithm for SQL Server

16 votes

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

16 votes
Accepted

Is it possible to restore sql-server bak and shrink the log at the same time?

16 votes

SQL Server Max Memory not limiting use of RAM

15 votes

How to control the excessive use of ram by SQL Server?

15 votes

Task scheduler for SQL Server Express

14 votes

How can I track database dependencies?

14 votes

Moving tables to another SQL2008 database (including indexes, triggers, etc.)

14 votes
Accepted

How to refresh AD security group on Sql Server permissions

14 votes

Why is SQL Server consuming more server memory?

12 votes
Accepted

Are the cost percentages in this SQL Server plan over 100% for a valid reason?

12 votes

SQL Server: filegroup for system tables only?

12 votes

What are the differences between NoSQL and a traditional RDBMS?

12 votes

Which DBMS are fast enough for an online game (few thousand players)?

12 votes
Accepted

Shrink database after drop table?

12 votes
Accepted

Parallelism Best Practices

11 votes

Is changing the SQL Server port really that much safer?

11 votes

Which fillfactor is used by ALTER INDEX REBUILD?

11 votes

Identity Columns or UDF that explicitly generates a unique id?

11 votes
Accepted

How can I tell WHY an insert on a certain table is slow?

1
2 3 4 5
21