As of May 31, 2023, we have updated our Code of Conduct.
Shane's user avatar
Shane's user avatar
Shane's user avatar
Shane
  • Member for 14 years
  • Last seen more than a month ago
9 votes
Accepted

Giving a user database permissions in SQL Server Management Studio

8 votes
Accepted

Importing a large SQL script into SQL Server?

8 votes

How can I see who is connected to my db?

6 votes
Accepted

SQL Server 2008 R2 Enterprise database has unexpected 4GB database size limit

5 votes
Accepted

How do I get an SQL Database in "Mirrored, Disconnected / In Recovery" into service?

4 votes

Move a SQL 2000 32-bit database

4 votes

Does running the sql server profiler affect performance on the server?

3 votes

Generic best practices for SQL Server 2008 R2

3 votes

when is it time to hire another SQL Server DBA?

3 votes
Accepted

SQl server 2008 permission and encryption

3 votes
Accepted

Implications and benefits of removing NT AUTHORITY\SYSTEM from sysadmin role?

3 votes
Accepted

Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?

2 votes

SQL 2008 is performing a CHECKDB every 10 minutes, any ideas why or where I can look to find out?

2 votes

1 logical drive vs 2 logical drivers on 1 raid controller to separate data from log files?

2 votes

SQL/IIS (Classic ASP) Web Application Performance Optimization

2 votes

Wake on Lan in Sleep/Hybernate mode Vista

2 votes
Accepted

How can you schedule a database backup on SQL Server 2005?

2 votes
Accepted

Any gotchas to installing SQL Express 2008 after SQL Server 2008 on same machine?

2 votes
Accepted

How to change the user iis 5 service runs on?

1 vote

sql2005 maintance plan 4 bak files?

1 vote

transfering sql server license from one host to another

1 vote

Problem: we need to install SQL 2008 R2 Express with Management tools on about 24 physical machines of various OS flavors

1 vote

Changing a SQL Server 2008 installation from instance to default

1 vote

Where can I go to learn how to read a sql server execution plan?

1 vote

query maintenance plan schedule

1 vote
Accepted

SQL Server 2005 TempDB Maintenace

1 vote
Accepted

BULK INSERT fails and rollback or not?

1 vote

Enabling xp_cmdshell in a production environment

1 vote

how do i do edit the frequency of backups in sql server?

1 vote
Accepted

User for MSSQL 2008 Service Accounts