|
||||||
|
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday before it was set up by Adam Machanic (Blog|Twitter) and you can read all about it here: T-SQL Tuesday. This months host is Allen White who asked the question “What T-SQL tricks do you use today [...] 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. [...] Things have been a little quiet on the blog front in the last couple of weeks, the reason for this is that I’ve been spending my spare time studying for the SQL Server 2008 MCTS – Database Implementation and Maintenance exam. Today was the big day, I’d never taken a Microsoft exam before so didn’t really know what [...] The second part of this series on finding files in SQL Server introduces the FileSystemObject. [...] |
||||||
|
Copyright © 2012 Richard Douglas – SQL Server Professional - All Rights Reserved |
||||||
