ugh VI... for classes that only had VI as an editor, I actually preferred to dial in remotely, FTP the files I was working on down to my PC, use...

Another option may be to have an "Operating System" step that calls SQLCMD on the second server using the command:
EXEC msdb.dbo.sp_start_job @job_name = 'yourjobnamehere'

The only limiting factor is SQL Agent will not start a job if it is already running, so even if a job is scheduled to run at 4:00, if someone...

Your initial understanding of indexes from an Oracle perspective is correct.  Oracle doesn't store data the same way SQL Server does, it stores a ROWID in the indexes that points...

If this staging database would only be for ETL type purposes, I think it would be easier to work with on the same instance, as you could use 3 part...

db_execute is not one of the fixed built-in database roles.  I think the point that Dwayne and Jonathan are making is that this must be a manually created database role...

I believe for setting up Alerts by severity, lower level severity errors only generate the alert if they are configured as logged errors.  You can see that in the sys.messages...

OK, I'm probably really dating myself here, but text file import/export is something that I think was actually handle better in the mid 90's in FoxPro for DOS, where it...

I think what he is saying is that you do not need to make the computed column persisted in the table, you can index a non-persisted computed column and it...

If possible, I'd suggest storing the backup files somewhere off of this server anyways, not just a separate drive on the same server, reduce the single points of failure.  Using...

From the results of the query you posted, it looks like even though the physical drive E: is nearly full, the data file on that drive has about a terabyte...

Looking at the totals isn't necessarily helpful, have you confirmed what files the 1115624 MB space available is located in?  This query will show you all the files and their...