Viewing 15 posts - 5,476 through 5,490 (of 6,678 total)
I've already got plenty here in my own little slice of south CA. I think its just about 80 here right now.
March 28, 2009 at 2:20 pm
sqlblue (3/28/2009)
you're probably right, i doubt that the forum allow attachement.but can i just copy the code you have here and put it in a
class, compile it and use it?
The...
March 28, 2009 at 9:41 am
I can think of a couple options:
1) Install SQL Server 2008 client tools, setup a folder and register your servers, then use the multi-script option to open a connection to...
March 27, 2009 at 6:40 pm
Florian Reischl (3/27/2009)
Jeffrey Williams (3/27/2009)
PS> Get-Childitem -Recurse | ? {$_.LastWriteTime -lt (get-date).AddDays(-3)} | % {Remove-Item $_.Name -Whatif}
:w00t:
So that's exactly what I'm speaking about...
Fortunately I don't have to. I'm a developer,...
March 27, 2009 at 2:00 pm
Florian Reischl (3/27/2009)
sqlblue (3/26/2009)
... PowerShell...Powershell? Wish you the best :-), it can do almost everything, but the syntax is just ugly in my opinion...
Greets
Flo
Ah, Flo - it's not that bad...
...
March 27, 2009 at 1:23 pm
I am not really sure if they meant hex or decimal.
March 27, 2009 at 1:19 pm
Once an index is disabled - the only way to enable it is to rebuild. Rebuilding an index that was disabled in an offline operation (meaning, the index is...
March 27, 2009 at 1:17 pm
Since you are truncating and loading every time - here is what i would recommend:
1) Disable all NC indexes
a) Leave clustered indexes enabled - or you...
March 27, 2009 at 9:40 am
I don't see any issues with the setup for this small set. When you get to loading millions of rows you are going to want to modify the batch...
March 26, 2009 at 4:17 pm
It sounds like you are running the SSIS package on your desktop. If so, that is going to be part of the problem.
In the OLEDB Source - are you...
March 26, 2009 at 3:07 pm
Those all look like SQL Server 2000 maintenance plan jobs. Are you on SQL Server 2000 or SQL Server 2005?
The outline I provided was based on setting this up...
March 26, 2009 at 1:39 pm
There is no native way to delete OS files from SQL Server. The basic options are:
xp_cmdshell - allows you to call out to the OS and issue OS commands....
March 26, 2009 at 1:36 pm
Basic starting point - adjust as needed...
Daily Plan (All User Databases)
Integrity Check
Backup
Remove Old Backup Files
Remove Old Transaction Log Backup Files
Daily Plan (All System Databases)
Integrity Check
Backup
Remove Old Backup Files
Hourly Plan (All...
March 26, 2009 at 1:25 pm
Other option could be a powershell script - sqlcmd and send the email. It really depends upon what you are doing. For anything that needs to be accessible...
March 26, 2009 at 1:16 pm
The real question is why do you need to do this in SQL?
Much easier to create a batch file or powershell script to delete files on a regular...
March 26, 2009 at 1:13 pm
Viewing 15 posts - 5,476 through 5,490 (of 6,678 total)