SQLServerCentral - Scripts by Gaby Abed

A quick way to find recently entered datetime entries in tables

Sometimes you need to scan a large number of datetime columns for most recent access. Read more...

By Gaby Abed 2010/06/08 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,794 reads

Using Run As to make your life simple

Using 'Run As' when working against different domains. Read more...

By Gaby Abed 2009/04/13 | Source: SQLServerCentral.com | Category: run as

Rating:

|

Discuss |

Briefcase | 1,508 reads

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table. Read more...

By Gaby Abed 2011/03/22 | Source: SQLServerCentral.com | Category: bcp

Rating:

|

Discuss |

Briefcase | 11,201 reads

Deleting old files (with/without archive bit)

A hopefully useful script to delete old files, not just backups, and make use of the archive bit. Read more...

By Gaby Abed 2009/01/01 | Source: SQLServerCentral.com | Category: archive

Rating:

|

Discuss |

Briefcase | 1,698 reads

Finding all data types in user tables

A quick way to get a snapshot of what data types are being used in all user tables. Read more...

By Gaby Abed 2008/12/04 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 1,014 reads

Getting schemas for your tables

A short script you can incorporate into any 2005/2008 code to get the full schema.table. Read more...

By Gaby Abed 2013/05/22 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 600 reads

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so. Read more...

By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers

Rating:

|

Discuss |

Briefcase | 3,105 reads

Checking fragmented indexes

A quick script to check for fragmentation in a database and generate a list of defrag statments you can run. Read more...

By Gaby Abed 2013/05/22 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 1,965 reads

Finding whitespace in a specific column

A quick way to check a targeted column for whitespace. Read more...

By Gaby Abed 2008/11/06 | Source: SQLServerCentral.com | Category: whitespace

Rating:

|

Discuss |

Briefcase | 893 reads

Monitor database growth - a better way for sp_spaceused

A better way to use sp_spaceused, returning values on one row for the database instead of two. Read more...

By Gaby Abed 2013/05/22 | Source: SQLServerCentral.com | Category: sp_spaceused

Rating:

|

Discuss |

Briefcase | 3,772 reads

Quick and dirty way to make a very large table

A script that can generate a massive amount of data relatively quickly Read more...

By Gaby Abed 2008/09/04 | Source: SQLServerCentral.com | Category: large data

Rating:

|

Discuss |

Briefcase | 1,268 reads