Finding a string value in a SQL Server table
In this article, we look at how to use T-SQL code to find a string value in a SQL Server table.
Tim Ford is a Senior Database Administrator with MindBody in San Luis Obispo, California and is in the process of relocating west to the Pacific Northwest from Michigan. Since 2010 he’s produced Microsoft Data Platform training events branded as SQL Cruise from Alaska to the Caribbean and the Mediterranean at Tech Outbound, an events company specializing in technical training in unconventional locations. His SQL Cruise events take place on cruise ships in the Caribbean, Alaska, and the Mediterranean. Tim also is the Executive VP of Marketing for PASS, the global association for Microsoft data professionals. He also is a contributing author for itprotoday. Tim loves helping people find their true potential through education and building networks between Thought Leaders in various fields and those who are just starting on their careers or struggling to find their footing in established careers. If you’re looking for this sort of experience then check out the next SQL Cruise event taking place this August in Seattle.
- MSSQLTips Awards: Acheiver (75+ tips) - 2010
Configure SQL Server Resource Group Ownership in Cluster Administrator
We have a two node SQL Server cluster in our organization. We are running an instance of Microsoft SQL Server on each node in the cluster. I am coming up to speed on the Cluster Administrator tool and I am looking for a process by which I can check the
Cluster Administrator Application for SQL Server DBAs
I've installed a SQL Server 2005 cluster and now I have to administer the darn thing. I am comfortable within SQL Server and the management tools that wrap around it, but I've been told by the Server Team in our organization that I need to be able to use
Determine Free, Used and Total Space for SQL Server Databases
I've seen so many different options and scripts for determining free space, consumed space, and total space allocated for databases in Microsoft SQL Server. Problem is none ever seem to give me all the information. I need to run one script to see this i
Using the FORFILES Command to Delete SQL Server Backups
Recently I constructed a new backup process that I want to institute globally across all my SQL Server 2005 instances. This backup process will not only backup all the databases I point it towards, but at the same time will script out the backup commands
SQL Server 2008 Date and Time Data Types
Learn about the date and time data type changes that were first introduced in SQL Server 2008.
Launching a default Project in SQL Server Management Studio
I have a common set of scripts I rely on whenever I create a new SQL Server 2005 instance. I understand that I can group these scripts and connections into a SQL Server Management Studio Project, but is there an easy method for opening this Project by de
Execute UPDATE STATISTICS for all SQL Server Databases
If you're like me, you have a SQL Agent job in place to rebuild or reorganize only the indexes in your databases that truly require such actions. If you rely on the standard maintenance plans in Microsoft SQL Server, a Scorched-Earth policy of rebuilding
SQL Server Management Studio customized startup options
SQL Server Management Studio (SSMS) is now the primary tool that we all use to manage SQL Server. Whenever I open up SSMS I always go through the same steps to connect to a server and open certain query files. Are there any shortcuts or alternative ways
SQL Server database backup and missing backup history scripts
In this tip we look at different queries you can use to get status information about all of your SQL Server database backups.
Determine space used for a table using SQL Server Management Studio
Recently I had to restore a copy of a production database to a test server in order for some, well, testing. I had warned the Application Analyst Team for months that we were going to be in a space crunch because while the production database had been gr
SQL Server 7.0 to 2005 Security Vulnerabilities for Logins
On a recent trip out west we were informed via radio that there were a series of earthquakes occurring off the coast of Vancouver Island. We happened to be sailing directly over the location of these earthquakes and never noticed anything, although the s
SSRS Conditional Formatting
I have a report that lists all databases for which a full database backup has not been applied in the previous 24 hours from the time the report is run. When I originally created the report I had a manageable number of databases to support and I was the
Vacation for a SQL Server DBA
There is something to be said for taking a vacation. The rest and relaxation, seeing new places, being exposed to new and exciting things. The other side of the coin is being on-call, answering pages at 3:00 AM then driving around a strange location hun
SQL Server DBA Telecommuting Tips
I've been working remotely (also known as Telecommuting) for over 8 years now. While it sounds great: Hey I get to work from home! telecommuting effectively takes a great deal of work. You can't just phone it in (sorry I could not resist the pun). B
Managing SQL Server Database and Application Metadata
I am frequently asked to translate the databases that reside on a physical server / SQL instance into their corresponding application names. Typically this need arises when preparing planned downtime notifications for servers, but it also is valuable whe
Balancing Resources for SQL Server Clustering and Consolidation
In my SQL Server environment we initially clustered to support a consolidation effort in which we were focusing on elimination of approximately thirteen Microsoft SQL Server 2000 and 2005 instances. Just because you have disk space, plenty of memory, and
Differences between SQL Server temporary tables and table variables
I have heard of table variables, but not sure how to use them in a stored procedure. What purpose do they serve and why not just use temporary tables instead?
SQL Server Clustering Active vs Passive
In this tip about cluserting for SQL Server we discuss the difference between an Active-Active versus and Active-Passive cluster.
SQL Server Index and Statistics Report
In this tip we look at a stored procedure you can create to get information about statistics last update, fragmentation and row counts for a SQL Server table's indexes.
Getting started with SQL Server clustering
We have a suite of databases that support a medical care system. These products have progressed in importance over the years to a point where our health care professionals rely on them for critical patient care. These databases must be available 24x7 wi
Rebuilding the SQL Server master database (Part 3 of 3)
So far we have prepared for the rebuild of our master database and have gone through the surprisingly simple rebuild process. (One of those DBA things where you spend all of your time on the preparation for something to go wrong, but everything goes off
Rebuilding the SQL Server master database (Part 2 of 3)
Previously in this series about how to rebuild the master database, we itemized the steps required to prepare for rebuilding the master database. In the third tip in the series will present how to restore your SQL instance back to the state it was in pri
Rebuilding the SQL Server master database (Part 1 of 3)
I recently found myself in a situation where I had to rebuild the master database on one of the nodes of our development SQL 2005 cluster. The process itself is quite simple, the proof is in the preparation however. The chances things will go wrong are