SQL Server 2005 Paging – The Holy Grail
Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.
2010-05-08 (first published: 2009-03-11)
39,437 reads
Robert Cary
- Interests: Sleight of hand magic, cycling, bowling, poker
Searching Syscomments Accurately
As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.
2008-01-07 (first published: 2007-01-22)
8,238 reads
Implementing a T-SQL semaphore
SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.
2006-10-17
16,994 reads
Blogs
Daily Coping 7 Dec 2022
By Steve Jones
Today’s coping tip is to stop for a minute when you walk outside and...
Encryption and Data Protection Regulation
One of the reasons you may be considering encryption is due to the relevant...
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
Forums
Blocking
We were getting constant blocking on the db server. However, after stopping the process...
Either/ Or Query
Hi, I have a table containing some columns and some simple data. I want...
Ask SSC