Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Gaby Abed

SQLServerCentral.com profile

   Items 1 to 12 of 12   
 

Yet another way to defrag indexes

A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.  Read more...
By Gaby Abed 2014/07/25 | Source: SQLServerCentral.com | Category: defragmentation
Rating: |  Discuss |   Briefcase | 1,365 reads

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,813 reads

Using Run As to Make Your Life Simple

Using 'Run As' when working against different domains.  Read more...
By Gaby Abed 2013/06/06 | Source: SQLServerCentral.com | Category: run as
Rating: |  Discuss |   Briefcase | 2,557 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,390 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,848 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,046 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 2008/09/29 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 623 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,265 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 2008/09/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,184 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 | 909 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 2008/09/04 | Source: SQLServerCentral.com | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 3,933 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,292 reads
   Items 1 to 12 of 12