992 reputation
722
bio website
location Brazil
age 25
visits member for 3 years, 3 months
seen Dec 16 at 10:44

Mar
19
comment Monumental difference in execution time between queries when using RECOMPILE query hint
@MartinSmith its using local variables. I ensured that the execution plan was reused when not using the RECOMPILE and the parameters were the same. The execution plan was of objtype Adhoc. When I changed the parameters, another execution plan was compiled and cached. With the RECOMPILE hint, a new plan was generated everytime and it wasn't even cached afterwards, just discarded.
Mar
19
asked Monumental difference in execution time between queries when using RECOMPILE query hint
Mar
18
revised Running each SQL Server service under different Windows accounts
edited title
Mar
18
asked Running each SQL Server service under different Windows accounts
Mar
13
accepted Full-text index in partitioned table
Mar
13
accepted What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?
Mar
13
accepted When was data last inserted/updated/deleted in a table?
Mar
12
accepted What does a SQL Server DBA need to know about Windows Server?
Mar
9
accepted What does a DBA have to know about SSAS?
Mar
8
revised What does a SQL Server DBA need to know about Windows Server?
better wording
Mar
8
asked What does a SQL Server DBA need to know about Windows Server?
Mar
8
awarded  Nice Question
Mar
7
comment What does a DBA have to know about SSAS?
Thank you, DaniSQL. I've also found this paper, and I probably shoud have mentioned it on the question (sorry!), but I was looking for a more gentle introduction about the subject, and opinions built on experience of our fellow DBAs here.
Mar
7
asked What does a DBA have to know about SSAS?
Mar
7
awarded  Commentator
Mar
7
comment What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?
Great link! I'll be taking this course!
Mar
6
comment When was data last inserted/updated/deleted in a table?
@JNK I'm investigating some kind of auditing mechanism like the one you're suggesting, but for this particular case I'd need retroactive data.
Mar
6
asked When was data last inserted/updated/deleted in a table?
Mar
6
awarded  Analytical
Mar
6
asked What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?