For more info on all the date and time functions check out the documentation at Microsoft.

Breaking in is very difficult. There are very few junior DBA positions out there that will take you from knowing little and grow you into knowing a lot. The best...

If you observe the wait statistics through sys.dm_os_wait_stats, you'll be able to tell where the waits are occurring. If you see log latch and IO waits, then you're experiencing slower...

It's a pretty manual task because there's almost no way to determine precisely, programmatically, where to put the silly things. So I've always done what the others do. Put them...

Modifying data structures by creating a new table, moving the data, rename the old table, drop all the old constraints, recreating all constraints and indexes, rename the new table, drop...

The optimizer will know that an index is unique and may use that as part of it's decision process when putting together the execution plan.

The command you're looking for in T-SQL is called MERGE. Here's the Books Online entry on it.

sunil88_pal88 (3/18/2014)

---

Hi Guys ,

There is one more thing I forget to tell that on development server ,everything is fine .Data is uploaded in almost 3 minutes, but on production it...

If you capture query metrics and the wait statistics from those queries at the same time, you can then correlate from wait statistics directly to queries. But, that's got to...

If WorkID is staying an identity column, then, you're guaranteed that the combination of WorkID and WorkDate are still identical because WorkID will always still be identical. But maybe I...

If this is a one-time shrink after a major data clean up, it should be fine. You just want to avoid a situation where you're growing then shrinking the database...

Snapshot isolation is great when you have a mix of exclusive locks and shared locks because it isolates them from each other. But this is a mix of exclusive locks....

Blocked processes or resource contention on that one database. That's all it takes.

I'm pretty sure disabling them in this case won't speed things along. Shrink is at a lower level and having the indexes in place is just another set of pages...

Instead of trying to write your own script, I'd suggest using one that's already written. Michelle Ufford's script is available[/url] and works quite well. You can schedule it to run...