My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan,...

If I understand your question, you want to know if you can specify the file names for multiple file backups?

This is a part of the BACKUP command. You enter the...

The links are updated in the editorial. My apologies for the issues.

They are:

http://www.engadget.com/2011/06/16/ibm-turns-100-brags-about-bench-pressing-more-than-companies-ha/

http://www.ibm.com/smarterplanet/us/en/overview/ideas/index.html?re=CS1

Two other things.

1. Is this a new database? In which case, the log has to be written with 0s, which can take a long time.

2. Instant file initialization on? If...

Excellent, and thanks

sa may not have privileges to start Agent. Agent is a separate service, and controlled from Windows. The sa account is limited to just SQL Server, and any action to...

The thing is we can't see you data. Can you post something that builds a table and populates it with sample data?

Something like

Create tableA

( ID int

, ColA varchar(10)

)

go

insert TableA...

Varies quite a bit, suspect that people are just busy this week getting ready for your vacation.

this might help you: http://www.sqlservercentral.com/articles/powershell/73288/

Powershell is a command line environment with SQL 2008 and newer Windows OSes. You can invoke the command line and then execute scripts, similar to how...

Why don't you want to join with the calendar table? Do you somehow think this is more efficient? Likely it's not if you plan on running a series of calculations...

you're not doing a join here.

Also, what do you mean by exclude some dates? Is there a reason you don't have these marked in your calendar table?

Follow Jim's advice, but as a few hints.

1. write a SELECT that calculates the data first. You can do this for all rows, joining with your table of days. Once...

You can modify Jonathan's script to check for logins that have a used in a specified database, or just make sure you manually add those logins. There isn't a way...

GilaMonster (6/25/2011)

---

Jim Murphy (6/24/2011)

---

Awesome. Some day, I'll enjoy it. You will blog about your experience...

ark.trofman (6/24/2011)

---

I understand that you need to have certain rules and make them available for the folks who want to publish here. Also I understand that the basic rules of...