Not entirely sure I understand the question. Generally, store the time as UTC in the database, and let the client convert to local time.

When you access a non-indexed view, SQL will expand the query that defines the view to access the...

You can use a file connection manager, or build one dynamically using variables and\or expressions. Dynamic is good for things like adding the time to a file, such as

dailyfile20140414

dailefile20140415

...

SSIS File System Task:

http://technet.microsoft.com/en-us/library/ms140185(v=sql.105).aspx

SQL Profiler. Possible Extended Events as well, but I am not sure about that.

Looks like your SQL Agent service is not using a domain account, but the local system...

Create a baseline to see what current server utilization is. You may be able to add dozens more databases to the existing environment, or you may be already overloaded.

Here...

I would also consider taking a look at Ola Hallegren's scripts. He has lots of documentation. The "recommended" maintenance is if fragmentatation is over 30%, rebuild, if it...

What is the current fragmentation level, and how large are your indexes?

Continuing on a theme here, not all databases are equal, so comparing the number of managed databases is a faulty metric. Managing 100 databases that support (well developed) third...

run 'sp_who2' and see what processes are running under your account. You can then take that SPID and follow SQL Guy 1's instructions.

Replication needs to read the transaction log. If you stop replication, that may cause the log to grow even more.

What caused the log to grow in the first place?...

SQL actually keeps track of how often an index gets used, and that info is accessible via the dm_db_index_usage_stats DMV.

Take a look here: https://www.simple-talk.com/blogs/2012/08/08/a-quick-look-at-dm_db_index_usage_stats/

IT researcher (1/22/2014)

---

I have already asked some questions about Autogrowth and shrink. But I have some doubts related to it.

1)I have a database which grows about 300 MB every...

Good news!

I would document the incident, including timelines. The time that the database was offline has an associated cost. That is what you need to use when someone says...