Get Item from Delimited List at Position
Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.
2011-03-10 (first published: 2011-02-21)
1,078 reads
Scripts
2011-03-09 (first published: 2011-02-21)
809 reads
2011-03-07 (first published: 2011-02-21)
8,678 reads
2011-03-04 (first published: 2011-02-21)
6,131 reads
Monitoring Resource Governor Memory Grants
A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.
2011-03-03 (first published: 2011-02-14)
3,201 reads
Search for a text in all databases
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
2011-03-02 (first published: 2008-01-25)
5,089 reads
2011-03-01 (first published: 2011-02-18)
4,015 reads
Columns Explorer - With constraints create / drop scripts (no cursors)
Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.
2011-02-28 (first published: 2011-02-18)
1,593 reads
String tokenizing / splitting
We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.
2011-02-25 (first published: 2011-02-09)
2,033 reads
2011-02-21 (first published: 2011-02-05)
1,960 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
Alamat Kantor BCA KCU A. Yani Telp:0817825533
Hub Via Wa:62817825533 Alamat Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa...
Alamat Kantor BCA KCU Bandung Telp:0817825533
Hub Via Wa:62817825533 Alamat Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa...
Alamat BCA KCU Bumi Serpong Damai Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Wisma BCA BSD City, Kav. CBD, Jl. Pahlawan Seribu Lot...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers