Is the content "static"? Do you have a set number of content entries that are always used? If so, put them into a table, have a column to...

Let's try something simple that isn't mentioned in your list...

Does your coworker have a login on your database server? Their Windows account needs to exist on it with proper...

Consider posting your script so we can review it. How many rows are being deleted? You might want to consider deleting in batches and deleting a few at...

First, save the SSIS Package using Rely On Server For Security (or however it is worded). Then try the job. That will show you whether the issue is...

From the BOL, for BACKUP LOG statement...

LOG

Specifies a backup of the transaction log only. The log is backed up from the last successfully executed LOG backup to the current end...

First you need to find out if the issue is with your view or with the statement the view uses. Run the statement that creates the view, but add...

Being honest...I read the initial post and thought....ho hum...had a database problem and restored from the backup. Okay....that's good to know, but the interviewer said CRITICAL.

Restoring from a backup is...

You say the cube is on another box...so that implies more than one server is involved. Is there maintenance being done the first Wednesday of the month? Or Tuesday...

We have a cleaning service where I work....however, my opinion is that I don't mind pitching in for things if everything is equal. If we lose the cleaning server,...

I like two monitors (extended desktop). I use the right monitor for running SSMS and the left monitor is where I pull up my scripts in notepad, etc, watch...

Ville-Pekka Vahteala (4/8/2014)

---

SQLBill (4/8/2014)

---

Jack Corbett (4/6/2014)

---

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is...

Jack Corbett (4/6/2014)

---

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is now 19+ hour...

I use the connection colour option in SSMS. See 'Use custom color' and set up registered servers using the desired colours. I tend to give red to production, yellow(ish) to...

I think the difference is really simple.

ALTER TABLE: you can specify whether you are adding a column or changing a column. If adding one, it adds it to the...

I use .txt and .sql files on a USB (with permission from my company).

-SQLBill