Chowdary's (4/28/2014)

---

Thank you all,

From your replies i came to know 2 main things to clear the Log File those are below

1> Need to take the Log Backup Frequently...

There's also the distributed replay tool that came out with SQL SErver 2012. That's worth checking out.

I'd have a separate telephone table. That way you can have more than one phone number for any given person AND you can assign a phone number to more than...

Not seeing your code or how you're accessing stuff, it's hard to say, but, you could read up on Jonathan Kehayias' blog. He's pretty much the best resource out there...

Here, read this about the log [/url]to understand why it's always growing.

You need to either set your database to simple recovery, or get log backups in place.

Since it's a dev box, I'd just do an in-place upgrade. I recently did one for my 2012 system to move it to 2014. It just worked. You do have...

Excellent! Happy to share.

They may be saying that, but you can't store data in the proc cache. You can't. It's an internal system memory space completely managed by SQL Server. It's not something...

Good to hear you have it all figured out. When operating with two different databases like that, another thing to keep an eye on is the statistics.

One of the best resources I've found on getting started with the in-memory databases. Tons of links to good articles.

Start with the Microsoft documentation. Always start with the Microsoft documentation. But, there are also 3rd party resources such as Tim Ford and Louis Davidson's excellent book.

Frequently, yes. Because you're going to lavish attention on that instance, know when it's running, possibly set up some type of high availability for it, etc. Yes, if you have...

You're talking Azure VMs, not SQL Azure which is the platform as a service offering, not infrastructure.

As far as disks go, the only ones available currently are through Azure blob...

You're comparing apples to hammers.

The procedure cache within SQL Server is for caching query execution plans for the queries running within SQL Server. It does this to avoid recompiling queries...

The best thing to do is not share resources with anything. sQL Server just doesn't play well with others. But, it doesn't sound right that just reducing the amount of...