My preferred PowerShell instructor, for just PowerShell itself, is Don Jones. He has...

ananda.murugesan (7/22/2014)

---

Ok, Many thanks form experties suggestions.

server side 800 GB freespace available at log file partition, so I am not executed that command let it be gorw that file....

Absolutely what Gail says. But, the real issue is going to be, what happens next time you run index maintenance, etc. Isn't the log just going to grow again? Then...

Oh, I get it. They're going to create some sock puppets to answer...

OK, that's officially weird on several levels. What the heck is it hoping...

The only way to shrink the size of the file is to shrink the size of the file.

If your file is growing too large, you have a couple of choices....

Learn PowerShell.

Automate all the things.

Yeah, I agree with John, test it.

It's a pretty standard approach when you're doing large scale inserts to drop the indexes. This is because maintaining indexes across all the inserts...

If you need to access data on more than one database within Microsoft Azure SQL Database, you must do that at that application level. The databases are absolutely isolated from...

The one thing I would start with is gathering performance metrics. Know what is happening on the system. What do the wait stats look like. Do we have queuing somewhere....

You can pull the plan generated out of cache using dynamic management views such as sys.dm_exec_query_stats combined with sys.dm_exec_query_plan. You can also use extended events to capture either estimated or...

The best piece of advice, go and get someone who knows what they're doing. You go past about 2-3tb and the rules change pretty radically. It's not something you can...

Great seeing you guys. SQLBits has some kind of magic perpetual engine, it keeps getting better.

SQLRNNR (7/17/2014)

---

That looks eerily...

It's right there in the post.