196 reputation
10
bio website
location Dallas, TX
age
visits member for 3 years, 9 months
seen 2 days ago

BI Developer!


Nov
13
comment How best to index large table with many index keys
Thanks @Aaron, I always keep those MERGE issues in mind. However in our case, those tables are only modifed by our ETL load and only during off-peak hours, so I don't think we're affected.
Nov
13
asked How best to index large table with many index keys
Oct
16
awarded  Popular Question
Oct
8
accepted Viewing how much transaction log is used in Simple Recovery Model
Oct
7
revised Viewing how much transaction log is used in Simple Recovery Model
added 71 characters in body
Oct
7
asked Viewing how much transaction log is used in Simple Recovery Model
Sep
24
awarded  Autobiographer
Sep
8
awarded  Popular Question
Jul
2
awarded  Curious
Jun
27
comment Installing SQL Server 2012 SP2 on instance with Cumulative Update #10
Ok I thought so. Fortunately, we only have to wait until July! Thanks @Aaron!
Jun
27
accepted Installing SQL Server 2012 SP2 on instance with Cumulative Update #10
Jun
27
asked Installing SQL Server 2012 SP2 on instance with Cumulative Update #10
Dec
11
accepted Does SQL Sentry Plan Explorer count the reads in UDFs?
Dec
11
comment Does SQL Sentry Plan Explorer count the reads in UDFs?
Ah, I did not know about the call stack in the Pro version. That's exactly what I was looking for. It's good to know that exists. At this point, I don't think I can justify the price but I'll keep it in mind for future situations. Is there a reason why SQL Server doesn't provide I/O information for UDFs in STATISTICS IO? It's misleading to omit such essential information.
Dec
11
revised Does SQL Sentry Plan Explorer count the reads in UDFs?
added 23 characters in body
Dec
11
asked Does SQL Sentry Plan Explorer count the reads in UDFs?
Nov
5
comment SSMS Tools Pack Alternative
One suggestion - we work with many databases in our company. It'd be great if the tool would default to the database connection of the current Query Window. Or have an option to default to a specific database.
Nov
4
accepted High cpu usage on SQL Server
Nov
4
comment High cpu usage on SQL Server
In that first question, I was referring to queries that are repeatedly recompiled (ex. procs that use temp tables). Thank you for sp_whoisactive. I discovered the issue was a missing index on a column. The query, although by itself quick, was being called thousands of times in a short timespan - each time doing a table scan for just one record in the result.
Oct
18
revised High cpu usage on SQL Server
added 180 characters in body