Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts by Gaby Abed
SQLServerCentral.com profile
Items 1 to 10 of 10
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
Items 1 to 10 of 10
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use