Viewing 15 posts - 16,666 through 16,680 (of 39,970 total)
Chad Crawford (3/17/2011)
Wahoo! Just passed 70-454. I am now officially SQL 2008 DBD ITP. 😀 Yipee!
Congrats, I need to take those exams. Did you find them hard?
March 17, 2011 at 3:12 pm
March 17, 2011 at 3:06 pm
the thing is that execution plan analysis isn't that simple. Grant's book is good, but it's some work to get through.
You might think about
- look to convert scans to seeks
-...
March 17, 2011 at 11:39 am
You are welcome, and if you wouldn't mind, can you show the code that worked for you?
March 17, 2011 at 10:51 am
WayneS (3/17/2011)
2. Implicit conversions can also cause poor performing queries.
Especially in SQL CLR. If you pass in the wrong types for conversions, you might end up with multiple conversions...
March 17, 2011 at 10:21 am
What you want to do is compare the inserted and deleted tables. If there is no change, then no insert. If there is a difference, then insert something
So if I...
March 17, 2011 at 9:44 am
March 17, 2011 at 8:46 am
gissah (3/16/2011)
...
March 16, 2011 at 10:23 am
Also keep this in mind. If you do a large transaction, maybe a large update. You need log space for the update PLUS log space for the rollback. That's because...
March 16, 2011 at 9:49 am
Do you mean large in terms of the activity? Or is the log just large all the time? Do you have log backups running?
The log writes down records based on...
March 16, 2011 at 9:15 am
Please show some sample data and explain what you are trying to do. Your explanation of what you need and what is happening is lacking details. Write more information about...
March 16, 2011 at 9:08 am
Viewing 15 posts - 16,666 through 16,680 (of 39,970 total)