The Multifunctioning DBA:

SQL Administration. MS SQL

1

August 23, 2012  3:17 PM

Index Fragmenting on Purpose



Posted by: Colin Smith
SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

In most cases we would like to reduce fragmentation and try to come up with ways, like reducing fill factor, to minimize the amount of fragmentation that occurs when doing inserts and updates. I , however, need to create fragmentation. I am sure that you are asking yourself why I might need to do...

August 21, 2012  4:18 PM

MSSQL Server and BCP



Posted by: Colin Smith
SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

I recently had a need to BCP a very large data set in and out of a database. The out is no issue. bcp [databasename].[schema].[table] direction path_to_output_file.txt -Sservername -c -T is the format that I was using and it worked fantastic. I was able to BCP out my 934Million rows. Now I...


August 17, 2012  12:00 PM

Powershell to Drop Procs



Posted by: Colin Smith
POSH, Powershell Tips, Scripting, Scripts, SQL Admin, SQL Administration, SQL Administration. MS SQL, SQL Server

I was asked by a developer if I could drop all the procs in a database except the ones that he knew were being used. I thought Powershell can do that. So I told him that I could if he provided me a list of the ones that he did not want to be droped. So he sent me a list and I got to work. I thought...


March 23, 2010  4:14 PM

Phoenix SQL Saturday Update



Posted by: Colin Smith
Events, SQL Administration. MS SQL, SQL Saturday, Training

So it is going to happen. A couple venues are under consideration, sounds like we may have a few sponsers, and we are looking at mid to late July for the event. I can not wait. I just got off the phone with Quest Software and...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: