Stan the DBA

Canada

stanleyjohns.wordpress.com

Age: 32

Passionate about faster retrieval of data, and high scalability. Specializing in SQL server and MySQL.

top accounts reputation activity favorites subscriptions

SQL Server: Has anyone used the large-page allocations tuning option?

sql-server performance database-tuning asked Aug 18 '11 at 9:19

dba.stackexchange.com

6 votes

In Oracle, can we restore a database onto the same instance with a different name?

sql-server oracle restore feature-comparison asked Apr 15 '11 at 13:48

dba.stackexchange.com

5 votes

How to change SQL sever configuration manager settings using TSQL?

sql-server t-sql configuration settings asked May 30 '11 at 19:58

dba.stackexchange.com

Top Answers

What are the top 3 performance Issues that you encounter with your SQL Servers?

dba.stackexchange.com

Trimming down a big SQL Server database

dba.stackexchange.com

About single threaded versus multithreaded databases performance

dba.stackexchange.com

Suggestion for Large SQL Server Database Design

dba.stackexchange.com

Is Oracle more demanding environment for a DBA than SQL Server?

dba.stackexchange.com

Where to look for a bottleneck after elimitating CPU, memory, and disk

dba.stackexchange.com

How can I tell if my SQL Server DB performance is hardware-limited?

dba.stackexchange.com

When should nonclustered indexes be stored on separate filegroups?

dba.stackexchange.com

What NoSQL solutions are out there for .NET?

stackoverflow.com

Database appearing in one tool but not another

dba.stackexchange.com

How can I move a database from one server to another?

dba.stackexchange.com

Database Users and Server Logins and the Mapping between them

dba.stackexchange.com

Is ROLLBACK a fast operation?

dba.stackexchange.com

Insert if not exists, concurrently

dba.stackexchange.com

Safely deleting a SQL Server log file (.LDF)

dba.stackexchange.com

How to deny drop permission for a table?

dba.stackexchange.com