This post is brought to you by the letter “K”. Those of you that have been following my blog and tweets recently will know all about the SQLRelay event that is happening in the UK this week. Tonight is the second of a four night series of events culminating on the 6th October in London where [...]
|
||||||
|
Recently I asked a colleague to split up an update statement into smaller batches to reduce locking on the system and the impact on replication, the table in question did not have an identity attribute on it so it had to be segmented a little more manually and he was worried that it would result in a lot of code to write. Now it’s true we could have used NTILE or TOP statements in a loop and split the update statement down that way, but then I wouldn’t have been able to talk about how you can work smarter not harder when it comes to building repeated queries. [...] Most if not all SQL professionals will have heard of SQLServerCentral.com, if you haven’t it’s a great community site with it’s own SQL Server forum where you can ask questions and receive answers from your peers. The site has a contribution center feature where registered members can submit articles, scripts and even a “Question of the day”. In true community spirit I shared one of the scripts that I had been working on. [...] Richard Douglas shows how you could use the undocumented stored procedure xp_FileExists to start another process. [...] |
||||||
|
Copyright © 2012 Richard Douglas – SQL Server Professional - All Rights Reserved |
||||||