506 reputation
36
bio website sqlinthewild.co.za
location South Africa
age 37
visits member for 5 years, 5 months
seen May 2 '13 at 10:15

Gail is a database developer/administrator living in Johannesburg, South Africa. She specialises in query optimisation and index tuning.

She's an MVP for SQL Server, a Microsoft Certified Master for SQL Server 2008 and a frequent poster at SQLServerCentral.com


Nov
20
awarded  Nice Answer
May
12
awarded  Yearling
May
12
answered Multiple SQL Server unique indexes with different includes
May
6
awarded  Yearling
Sep
26
comment How to find when the stored procedure was deleted and who deleted it?
Depends on the recovery model and how often log backups are done. If the log is backed up every 15 minutes and the proc was dropped 3 days ago, the log records for the drop will be long gone.
Sep
21
comment SQL Maintenance Job nearly fills up C:-drive
Why are you shrinking your databases?
Sep
19
awarded  Commentator
Sep
19
comment Syntax for DBCC CHECKTABLE on all indexes?
Why are you running repair? What errors did CheckDB (without the repair clause) return? Are there no backups that you can restore from instead of repairing? Do you know how much data repair is going to delete?
Sep
19
comment How much will SQL Server 2005 performance increase with more RAM?
Yes and yes. Without AWE, the SQL process can't access more than 2GB of memory.
Sep
19
comment Transaction log is full
Specifically log backups
Sep
19
answered Transaction log is full
Sep
17
answered When does a database data file get written to?
Sep
17
comment When does a database data file get written to?
Recovery model doesn't affect when the DB file gets written to. It affects how long log records are retained, how much gets logged in bulk-operations and what operations truncate the log.
Jul
6
comment SQL Server 2008 Load-Balancing
Duncan, you are correct. Two instances cannot read and write to the same data file at the same time.
Jun
26
awarded  Beta
Jun
25
comment Which SQL database should I run?
Neither can MS SQL Server.
Jun
17
comment SQL 2000 - WAITSTATS: CXPACKET query
Can you explain how CXPacket waits are related to IO?
Jun
6
answered How can I remove unallocated space from a SQL Server database?
Jun
3
answered Why attend Tech.Ed?
Jun
3
answered SQL/IIS (Classic ASP) Web Application Performance Optimization