This is exactly why you should be using source control to modify all your database objects, just as developers use it to modify code. Unless you set up auditing, and...

SQLRNNR (9/25/2014)

---

This is the kind of thing you now have to worry about more when storing different data types in the same data type column. People will write code...

That's the only place I'm aware of to make those kinds of changes.

Use trace or extended events to...

You can have a section in your resume called Certifications and list it there. As to writing the manual, that should be part of the description of that job.

Try going to the Options screen, Environment, Keyboard. Then you can try doing a reset on the keyboard scheme you're on. That ought to do it.

It really depends on how the optimizer is resolving those queries. It's also dependent on how you're writing the queries. AND, it's dependent on the indexes you have on the...

BACKUP DATABASE

works extremely well, even with users connected.

Jeff Moden (9/24/2014)

---

Chowdary's (9/24/2014)

---

Thank you for response Grant,

I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go...

Chowdary's (9/24/2014)

---

Thank you for response Grant,

I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So...

Some filtering then, but, assuming that's a CHAR(1) field, not much filtering at all, so you're still going to be looking at scans and few options for the optimizer to...

There doesn't seem to be any tuning opportunities in the code itself. You're retrieving all the data from two tables in a UNION ALL with no filtering. The optimizer is...

Personally, the best ones are from Red Gate Software[/url]. They have tools for both monitoring and backups. But then, I am prejudiced since I work for them.

You should just do...

I experimented with doing backups simultaneously. It's possible with PowerShell to set up a threaded process to fire off all the backups at the same time. The results were pretty...

Having just going through the nomcom process, I thought it seemed pretty fair. There's an assumption of knowledge about the inner workings of the board that maybe shouldn't be there....