Eli Leiba

Get the #lines in a TSQL view/SP/UDF of a String

The following procedure gets a TSQL program object(View/UDF/stored procedure) and a given stringIt searched object's source code for the string and returns the number of lines where a match is found.This is helpful when we want to search all our TSQL code for a specific table name, column etc. and investigate where it is referenced […]

2005-06-02

83 reads

Tokenizing a String Using PARSENAME

SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting.

1 (1)

2004-12-27

10,042 reads

Evaluating Boolean expressions using T-SQL

Every once in awhile there is a unique T-SQL solution in SQL Server that solves a rare problem. Not many of us have had to deal with boolean evaluation in our jobs, but a few have. Author Eli Leiba has and brings us a new article that shows how to build a procedure that can take a boolean expression and evaluate it to true or false.

2004-12-21

13,086 reads

Tracking Down Newly Created Databases

SQL Server was designed to make the DBA job easier, distribution of security, automated procedures, etc. But in some areas it either does not go far enough, or a feature is used for an unintended purpose. One of those areas comes into play when allowing many people to create databases. Author Eli Leiba brings us a tecehnique he uses to close the gap and track down those newly created databases.

2004-11-18

4,866 reads

Identifying Blocking Locks

Blocks in SQL Server can cause untold amounts of pain and headache, mostly because they are so transient and often when you go to look for them, they have been released on whatever object you are researching. Author Eli Leiba has writeen a short piece on how you can automate the search for blocking locks and help you as a DBA be proactive in identifying them.

2 (1)

2004-10-28

12,380 reads

Blogs

Being a Woman in the SQL Community

By

In celebration of Women’s History Month starting next week, I was asked to write...

Join me at SQLBits 2020

By

The SQLBits conference is taking place in London again this year, between March 31st...

DBA, a job, a vital job

By

DBA, a job, a vital job. T-SQL a language that is fun. Select, a...

Read the latest Blogs

Forums

How to make DBCC CheckDB faster ?

By WhiteLotus

Hi All We are running DBCC CheckDB in our server during low activity time....

Exploring the DATE Functions in SQL

By aveek22

Comments posted to this topic are about the item Exploring the DATE Functions in...

Implementing Date Calculations in SQL

By aveek22

Comments posted to this topic are about the item Implementing Date Calculations in SQL,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers