Sean Long's user avatar
Sean Long's user avatar
Sean Long's user avatar
Sean Long
  • Member for 10 years, 8 months
  • Last seen more than 4 years ago
62 votes
7 answers
106k views

.bak file not visible in any directory in SSMS

34 votes
2 answers
195k views

Max Connection Pool capped at 100

14 votes
1 answer
31k views

Difference between FreeProcCache and FreeSystemCache

10 votes
2 answers
37k views

What is the most effective way to compress and store a SQL Server backup? [closed]

9 votes
4 answers
29k views

Can a database's files be copied while a database is online?

8 votes
2 answers
2k views

What can I add to a server to make SQL restores faster?

6 votes
2 answers
373 views

Figuring out the physical size of a group of tables in SQL server

6 votes
2 answers
7k views

What is "Index Fragmentation Percent" a percentage of?

5 votes
2 answers
92 views

Determining the tables and impact of a large number of SPs

5 votes
1 answer
6k views

What is the Wait Type "QDS_Shutdown_Queue" referring to?

4 votes
1 answer
935 views

Getting a list of active objects that use cursors but don't explicitly close/deallocate them

4 votes
1 answer
1k views

How large are blocks of data in SQL Server?

3 votes
2 answers
2k views

Replacing master.dbo.sysperfinfo with sys.dm_os_performance_counters

3 votes
1 answer
311 views

Restoring with replace going incredibly quickly [duplicate]

3 votes
2 answers
8k views

"Restore With Replace" or drop/restore with Instant Initialization on?

2 votes
2 answers
323 views

How can I hunt down what is trying to use SA?

1 vote
1 answer
4k views

Restarting SQL Server's services remotely programmatically

1 vote
0 answers
57 views

Backing up the SQL Application

1 vote
1 answer
113 views

Can a database restore fail after it has begun?

1 vote
0 answers
4k views

SQLCMD cannot find the SQL Server remotely

0 votes
1 answer
1k views

Using a string with single quotes in a table

0 votes
2 answers
1k views

Connecting to the default instance of SQL Server connects to a named instance

0 votes
1 answer
151 views

Getting the value from a column during a trigger [closed]