These are worth reading, kind of a read once – nothing too complicated. However they will be useful if you have the need for these
- [How to find out what procedure is doing a data modification]
- Very simple, yet effective approach to determine what RPC call is altering your data. This is a read it once, you get the ah-ha why didn’t I think of that moment and you wont need to reference it again!
- [Temporary procedures : T-SQL]
- We all know about temporary tables, but you can do that for stored procedures as well. Neat if you have a need for it
- [Conor vs. FOREIGN KEY join elimination]
- Explains a bit of the history why a single column foreign key performs better than a multi-column FK. Its the old 80:20 rule at work, or probably more accurately 99.9:0.1 rule
- Explains a bit of the history why a single column foreign key performs better than a multi-column FK. Its the old 80:20 rule at work, or probably more accurately 99.9:0.1 rule
- [SSRS -Report execution failed. Solution: SSPI=NTLM]
- Seems downgrading to NTLM solves some integrated security issues if Kerberos is not playing nicely. Handy to know.
- [Take advantage of Table Variables NOT being transactional]
- Ever needed to store state in a transaction that you didnt want to be rolled back? Think log tables! Read and learn
- Ever needed to store state in a transaction that you didnt want to be rolled back? Think log tables! Read and learn
- [SQL SERVER – Fragmentation, Detection and how to resolve it]
- Nice overview of fragmentation, and shows how to use DMV’s rather than the old school SQL 2000 DBCC approaches
- Nice overview of fragmentation, and shows how to use DMV’s rather than the old school SQL 2000 DBCC approaches
- [CodePlex: SYS2 DMVs]
- Hopefully this will serve as a good collection point – its very ‘young’ at the moment, but I would like it to live!
- [Locking improvements in SQL 2008 R2]
- Handy to know about, unfortunately R2 has a price hike associated with it
- Handy to know about, unfortunately R2 has a price hike associated with it
- [Find the most expensive operations in Execution plans]
- Handy way to take the XML plan and process it in a way to get a tabular list of the most expensive queries back. Very nice.
I suspect everyone who has dealt with scalar UDF functions in production environments are already VERY aware of the performance sucking capability they can have on your nice server. Here are some nice comments if you are not painfully aware:
Gareth