This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If this value indicates an increased amount of index fragmentation throughout your database, you may need to fine-tune your indexes by redesigning, or rebuilding more frequently.
2015-01-22
7,455 reads
We have the winners of the 2014 Tribal Awards. Congratulations to everyone involved: winners, finalists, and nominees, and thank you to everyone who voted or nominated someone for an award.
2015-01-21
1,023 reads
Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.
2015-01-21
9,039 reads
2015-01-20
9,279 reads
My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.
2015-01-19
3,752 reads
Of all the basic SQL operations, the pivot seems to cause the most problems. It turns out that there are several questions that come to mind while learning about pivoting, but which are seldom asked on forums.
2015-01-19
11,491 reads
Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.
2015-01-16
10,316 reads
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
2015-01-15
6,497 reads
Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.
2015-01-15
9,692 reads
In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.
2015-01-14
8,200 reads
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Looking to confirm my understanding of these three products and how they can be...
In one of my environments I have 3 pairs of Always On SQL 2022...
Comments posted to this topic are about the item Learning From Breakage
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers