Lowell Izaguirre

Script all indexes as CREATE INDEX statements

this script will generate CREATE index statements for all indexes in the database;there are already scripts out there that script constraints for primary keys and unique constraints, which automatically create an index behind the scenes. but what about the other indexes?uncomment two statements in order to filter out primary keys and Unique indexes so you […]

4.22 (18)

2006-03-17 (first published: )

24,473 reads

Search All Fields in db for a Specific String

forums question came up where someone needed to search every varchar/char field in the database, and find any table/field that had a specific value (ie ip address, email, servername) we all agree that a monster scan like this is bad, but bad or not, sometimes you need to do it.it returns results that look something […]

2005-07-07 (first published: )

249 reads

T-SQL to Export Table Structure to a script

When you want to export a table structure to T-SQL, everyone always points you to Enterprise Manager, or a script that calls BCP.Sometimes, a developer either doesn't have access to those tools, or just doesn't want to use them (like me) out of spite.I made this T-SQL because it was educational, and noone else seems […]

3 (2)


3,733 reads


Daily Coping 17 Sep 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021


  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available


Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs


SSRS Migration Question

By CiyonAart

So I have a SQL 2017 server that has the two Report Server Databases,...

What is the specific job of the SQL Developer position?

By AllanLloyd

I knew about the position of SQL Developer through an introductory newspaper. I found...

update final code where not contain x then null if not contain x and another cod

By ahmed_elbarbary.2010

i work on SQL server 2012 I face issue i can't update table replacement...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers