2011-10-03 (first published: 2008-03-27)
7,008 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,655 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,395 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,948 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)
546 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
19,907 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
Forums
Somebody realized to configure Cluster-Aware updating on VMWare nodes
Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...
is it cache or something else
hi a few days ago i narrowed down the cause of a new problem...
SQL Server - Log file not getting smaller on Log backup
I have a database that is in full backup recovery model. When the log...
Question of the Day
SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers