Stack Exchange

StrayCatDBA

Altanta Georgia

I'm the Sql Server DBA for a "Top 300" US website. My areas of expertise are full-text search, sql internals, troubleshooting performance issues and scaling up. I'm passionate about Sql Server and I'm not scared of the debugger.

top accounts reputation activity subscriptions
Top Questions
No questions with score of 5 or more
Top Answers
47
Trigger Error: The current transaction cannot be committed and cannot support operations that write to the log file
stackoverflow.com

19
How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
stackoverflow.com

17
SQL Server Transaction Backups vs Logs
dba.stackexchange.com

17
How to improve performance on a clustered index seek
stackoverflow.com

13
Concatenation Physical Operation: Does it guarantee order of execution?
dba.stackexchange.com

11
Is it safe to rely on a shadow volume backup of the mdf and ldf files?
dba.stackexchange.com

10
Non-yielding IOCP Listener
dba.stackexchange.com

10
linked list in SQL and Trees
dba.stackexchange.com

10
Stored procedure with table name as parameter amongst others
stackoverflow.com

8
Are database query optimizers aware of storage performance differences?
dba.stackexchange.com

8
Getting top n latest entries from SQL Server full text index
stackoverflow.com

7
Can Availability Groups replace transactional replication?
dba.stackexchange.com

6
How to delete an old .ldf file and create a new .ldf file automatically
dba.stackexchange.com

6
How to avoid a select query for holding a Sch-S lock
dba.stackexchange.com

6
Why does memory reported by sys.dm_os_buffer_descriptors not match the max server memory when large db tables are queried? (Table size > max memory)
dba.stackexchange.com

6
Anyway to speed up the archiving of a large table
stackoverflow.com

6
SQL Server 2012 - Sliding Functions using OVER
stackoverflow.com

6
Will SQL Server Service Broker be supported in SQL Azure in future?
stackoverflow.com

5
Detecting SQL Server Utilization with a query
dba.stackexchange.com

5
Buffer usage for index with no reads
dba.stackexchange.com

5
Lock escalation problem on a trigger
dba.stackexchange.com

5
SQL Server Full Text Search around numbers and underscores
stackoverflow.com