majorbloodnock (1/15/2013)

---

Gary Varga (1/15/2013)

---

A reasonable interview will test deeper understanding, however, the biggest problem is that some interviews are conducted so poorly these people that "learn by cramming" sometimes succeed....

It's not a link. In Windows, open the Start Menu, and type Windows Update. The top item that the search finds will (normally) be "Windows Update". Click...

Actually, your best bet for that is replaying a trace file from the current server on the new server. Details on how to do that are here: http://msdn.microsoft.com/en-us/library/ms189604(v=sql.105).aspx

Collect the...

All that means is you have an out-of-date copy of Windows 7.

Assuming it's a legal copy, you can use Windows Update to get SP1, and then you'll be fine. ...

sp_cursorprepexec is a built-in stored procedure that comes with SQL Server. Details here: http://msdn.microsoft.com/en-us/library/ff848775.aspx

But it looks like it's in a comment-block in the code you quoted. /* begins...

What edition of SQL Server 2012? Enterprise? Standard? Express? Developer?

RedGate SQL Backup is a good product. Not sure what that has...

Well, it'll probably look something like this:

DELETE FROM dbo.MyTable

WHERE MyDateColumn >= '2012-06-01' AND MyDateColumn < '2013-01-01';

SQL Server will log every row row deleted. Has to in order to maintain...

Definitely not. That was an old practice in prior versions of SQL Server, and Microsoft moved away from it in SQL 2005 and recommended against it. Use schemas...

Can I call this proc recursive? Under the headings of Performance, it shows some problems coming up from proc sp_Blitz. 🙂

[master].[dbo].[sp_Blitz] has WITH RECOMPILE in the stored procedure code,...

How you record the changes is pretty key to how you report them, but not necessarily critical.

If you want to regularly query the data, then you either need "active auditing"...

Sounds like you're off to a good start.

A couple of things you can do:

Right-click a database in SSMS (Management Studio), then Report -> Standard Reports -> Backup and Restore Events....

Advice about it? Read the documentation and ask the questions that come to mind. I found it pretty straightforward once I just followed the directions on MSDN, the...

Per your post immediately prior to my question:

create table ##permission_info (id int primary...

That's when those databases were created. By Microsoft. Not by you.

Copy a database from one server to another, and you still get the data it was created on...