August 21, 2012 9:10 PM
Posted by: Colin Smith
SQL Admin,
SQL Administration,
SQL ServerI 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
Posted by: Colin Smith
SQL Admin,
SQL Administration,
SQL Administration. MS SQL,
SQL ServerI 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
Posted by: Colin Smith
POSH,
Powershell Tips,
Scripting,
Scripts,
SQL Admin,
SQL Administration,
SQL Administration. MS SQL,
SQL ServerI 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...
February 23, 2010 9:46 PM
Posted by: Colin Smith
corruption,
DBA,
DR,
On-Call,
Planning,
SQL AdministrationJust the other morning at 3:00 AM I get a page, Love being on call, and I see some errors about MSDB. Well this concerns me but it is 3:00 AM and my head is not really on straight. I doze back to sleep, in ten more minutes I get two pages, This time I get errors about MSDB again and I also get...
