2011-10-03 (first published: 2008-03-27)
7,189 reads
Robert Cary
- Interests: Sleight of hand magic, cycling, bowling, poker
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)
41,908 reads
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,421 reads
Search All Columns in all tables
This script will quickly generate DML to search all the tables in the current database for a given string. It could be modified to execute the generated code if desired. If you are running this in a
2007-01-23 (first published: 2007-01-04)
2,973 reads
Find Nth Occurrence of Character Function (Set Based)
This function was originally contributed by other visitors. Below is an example of a set based approach to the problem. This script requires a numbers table (see SqlServerCentral article http://www.sqlservercentral.com/columnists/mcoles/2547.asp for more details)Please note that this code is uses SQL2005 featuresEnjoy!Robert Caryhttp://tsqlland.blogspot.com
2006-10-20 (first published: 2006-09-18)
557 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
20,306 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Cengkeh Telpon/WA:085188120691
BCA KCP Cengkeh Telpon/WA:085188120691 Jl. Cengkeh 21-21A, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat,...
BCA KCU THAMRIN Telpon/WA:085188120691
BCA KCU THAMRIN Telpon/WA:085188120691 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
BCA KCU KALIMALANG Telpon/WA:085188120691
BCA KCU KALIMALANG Telpon/WA:085188120691 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers