To all database engineers, you often implement repetitive processing (loops) using WHILE statements within stored procedures and functions. When batch processing large amounts of data or applying ...

While there are a great many books, blogs, and articles out there on T-SQL, there are always a few little "tricks" that many people overlook, or that many authors assume readers know. So this week, ...