RamSteve (4/30/2015)

---

To be more specific .. I make huge transactions in database like delete and Insert and Update. Right after this transactions i Shrink the Database and take Transaction log...

YOu can do either, but I'd recommend setting it for the database.

Shrinking the database files is shrinking the database files. Backing up a database is doing a page by page copy of the database and backing up the log is copying...

TheSQLGuru (4/30/2015)

---

That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous requirements, not some...

Use extended events[/url]. They have great filtering and can capture just the queries executed by a given user.

I'm going to punt. I haven't used page restore in a production system, so I'm not going to try to advise you since important data is on the line.

Tom_Sacramento (4/29/2015)

---

Hi Grant -

I appreciate your response, and all your knowledge and experience. Maybe I'm short-cutting or lazy here but I was hoping for a shorter solution/crash course(!:w00t:) than...

Tom_Sacramento (4/29/2015)

---

Hi Grant -

I appreciate your response, and all your knowledge and experience. Maybe I'm short-cutting or lazy here but I was hoping for a shorter solution/crash course(!:w00t:) than...

SQLRNNR (4/29/2015)

---

Steve Vassallo (4/29/2015)

---

Our company was just acquired by another. They DBA team there added some jobs to our servers and one was a DBCC Shrinkdatabase command followed by...

Steve Vassallo (4/29/2015)

---

Our company was just acquired by another. They DBA team there added some jobs to our servers and one was a DBCC Shrinkdatabase command followed by a...

Sure thing. Best of luck. Report back what you get for a grade. I'm curious.

For a 42gb database, 8gb of memory is not that low really. But, it does depend on the types of queries and everything else.

I put nearly zero faith in the...

The Powershell solution is the way to go. It's using SMO calls in the same way as the GUI. That will generate the code the way you're expecting it.

While I agree with everyone that these tables are not properly normalized, in an effort to help, can you tell me which tables you're trying to understand the relationships between?

You...

spaghettidba (4/29/2015)

---

Grant Fritchey (4/29/2015)

---

The real question though is, why are you going for a certification. They're only helpful as study guides and possibly when working for a company that wants...