Topics for "brent-ozar-unlimited"

What is partitioned view?

Each table in a partitioned view is its own little (or large) data island. Unlike partitioning, where the partitions all come together to form a logical unit. For example, if you run ALTER TABLE on a partitioned table, y…

Why is partitioned view better than partitioned table?

Partitioned views can produce even better plans than partitioned tables do for some queries (need to stress “some”). This is purely due to optimizer limitations since the optimizer could break up a partitioned table acce…

How to make sure SQL Server is running at a high priority?

Instead of trying to make sure SQL Server is running at a high priority, reduce the number of other processes competing with SQL Server for resources. Get the most out of your expensive SQL Server licenses by using this …

What can you do with indexed views?

What You Can (and Can’t) Do With Indexed Views 1 Security: we create views so that a user can read specific columns out of certain tables, but not all the data. 2 Simplification: sometimes, it’s easier to write a SELECT …

Can I create a partitioned view?

Yes and no! The nice thing about partitioned views is that they’re available in Standard Edition. You can create tables on different files and filegroups (just like with partitioning), and if you need to change the data …

What does RT stand for on Twitter?

What RT means on Twitter: ReTweet. RT is an abbreviation for ReTweet, which is like Repeat. It’s like forwarding, but for Twitters instead of emails. If you see something really cool from one of the people you follow, yo…

What does the abbreviation RT mean?

RT is an abbreviation for ReTweet, which is like Repeat. It’s like forwarding, but for Twitters instead of emails. If you see something really cool from one of the people you follow, you may want to ReTweet it so that th…

What is virtual log?

VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files. The number of virtual log files can grow based on the autogrowth settings for the log file and how often the activ…

What is VLF in VLF?

sp_Blitz Result: High Virtual Log File (VLF) Count. VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files. The number of virtual log files can grow based on the autogrow…

What is 'RT' in Twitter?

RT is an abbreviation for ReTweet, which is like Repeat. It’s like forwarding, but for Twitters instead of emails. If you see something really cool from one of the people you follow, you may want to ReTweet it so that th…

What is virtual log file (VLF) in transaction log file?

sp_Blitz Result: High Virtual Log File (VLF) Count. VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files. The number of virtual log files can grow based on the autogro…

Why are virtual log files slow?

The number of virtual log files can grow based on the autogrowth settings for the log file and how often the active transactions are written to disk. Too many virtual log files can cause transaction log backups to slow d…

What does VLF stand for in log?

VLF stands for Virtual Log File and the transaction log file is made up of one or more virtual log files. The number of virtual log files can grow based on the autogrowth settings for the log file and how often the activ…