Entering random data into a table

Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.

Tables Without Clustered Indexes

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.

Page considered Suspect in SQL Server 2017

Manage the suspect_pages Table on SQL Sever 2017

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.

How to Identify Useful SQL Server Table Statistics

In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.

Log and report on table growth for trending

Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.

Quickly Investigating What's in the Tables of SQL Server Databases

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.

SQL Server Tables - 11 Questions You Were Too Shy to Ask

There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions. Robert Sheldon reckons that no questions about SQL Tables are off-limits, and deserve frank answers.

On Comparing Tables in SQL Server

How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.