Click "New" to create new directory and test if it works (you will have to use new name "ReportsDev" or something different).

Hi,

You can get more information if you use Profiler. It can show you Application Name, Host and even process ID on that host.

If someone edits the dtsx file on the file system and doesn't import it into SQL Server, there's no way I'm aware of (if you aren't running version control software)...

You can log CREATE LOGIN, CREATE USER, ALTER LOGIN, ALTER USER, ADD ROLE MEMBER, ADD SERVER ROLE MEMBER and other events (http://technet.microsoft.com/en-us/library/bb522542.aspx) using DDL triggers.

I have added my vote as well.

It would be confusing to get this question on interview, is it? I wouldn't know what is the right answer, probably would give...

I new I will get incorrect answer 🙂

I based my answer on sys.indexes "type" column:

Type of index:

0 = Heap

1 = Clustered

2 = Nonclustered

3 = XML

4 = Spatial

You may try to use "CREATE INDEX WITH DROP_EXISTING" to enable indexes: http://technet.microsoft.com/en-us/library/ms177406.aspx.

Be carefull when you disable ALL indexes, disabling a clustered index on a table prevents access to the...

3) Yes, rebuilding indexes requires more space, but it depends on index size. I have database that takes more than 3 times space than actual data because of index rebuilds.

You...

You don't have to pay for the separate instances on your new server, you will be licensed per CPU or per user (depending on your license mode).

Hi,

I usually install service packs, but I wait for a month or so to make sure that there are no corrections to it (like it happened with SQL 2000 SP3a)....

Hi,

I think this article from Microsoft has answer to your question: http://support.microsoft.com/kb/2027550

No, the other way around. I thought that you do it with another job step.

You can try to add Maintenance Cleanup task step (on success) inside the maintenance plan itself instead of adding job step. This perfectly works for me.

I prefer to use msdb. It allows to have folders hierarchy and keep track of versions. I have report that displays all packages with versions numbers and hierarchy. Also, as...

That was Friday's madness 🙂

SELECT * FROM YourTable

WHERE convert (datetime,YourColumn) =

DATEADD(month,1,convert (datetime,convert(varchar(10), getdate(), 101), 101))