SQLServerCentral - Scripts by Gaby Abed

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,210 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 2009/02/04 | Source: SQLServerCentral.com | Category: BCP

Rating:

|

Discuss |

Briefcase | 7,782 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 | 825 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 | 796 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 | Source: SQLServerCentral.com | Category: SQL Server 2005

Rating:

|

Discuss |

Briefcase | 403 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 2008/11/13 | Source: SQLServerCentral.com | Category: Random Numbers

Rating:

|

Discuss |

Briefcase | 1,627 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 | Source: SQLServerCentral.com | Category: index

Rating: (not yet rated) |

Discuss |

Briefcase | 580 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 | 726 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 | Source: SQLServerCentral.com | Category: sp_spaceused

Rating:

|

Discuss |

Briefcase | 1,765 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,101 reads