The Multifunctioning DBA:

SQL Admin

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  9:10 PM

Partition Table Load Mistake



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

I have a table that has 54 partitions and is a range right partition function. So ideally I like to have 52 partitions with data in them and the first and the last partitions are empty. Well the other day, our ETL team ran a load job that is meant to run after our weekly load process. They had not...


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...


January 21, 2011  7:02 PM

SQLskills Training: Why I need it.



Posted by: Colin Smith
SQL Admin, Training

About three years ago I became a DBA. This was not by design and I never set out to be a DBA. I started out at a help desk, worked my way into a techshop (Working on deploying and repairing laptops and desktops for the company), and then finally got to what I thought my end game was, a Windows...


March 30, 2010  2:50 AM

The SQL Server Community



Posted by: Colin Smith
Help, PASS, SQL Admin, SQL community

As you know, I am pretty new to being a DBA and new to the community of SQL Server. I come from a background of being a Windows Administrator and I can say, that I never really found a lot of support from a community. I really never found a community to ask for support. I can honestly say that is...


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: