During development of stored procedures, i ran into one issue and this was due to not applied best practice of stored procedures practice and this issue comes mostly when we call stored procedures inside another one and so on, which are used in nested in transactions. So i would like to write next post...
In my previous post, SSRS #43 – Problem with undocumented SQL procedure AddEvent when kicking off a Timed Subscription , I mentioned that the report link from the Subscription is not a valid link. Our architecture team informed me that using undocumented procedure AddEvent probably is not the best...
Fragmentation - have you ever heard about it when you are dealing with databases. Just talking on DBA perspective I would say fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation...
Posted to
SQLMaster
by
Satya Jayanty
on
02-17-2011
Filed under:
Filed under: best practices, dba, sql server, #SQL Server, tsql, #TSQL, BRH, beginners, data, disk, fragmentation