SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance.
2015-07-03 (first published: 2013-06-11)
18,558 reads
2013-06-19
1,487 reads
SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.
2013-05-20
5,172 reads
Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to analyze your SQL Server database and suggest actions to be taken in order for taking your query performance to the next level.
2013-04-09
5,110 reads
The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,
2013-03-05
3,615 reads
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
I have a table with partition on create_timestamp field. Though we're storing all data...
Comments posted to this topic are about the item Adding and Dropping Columns II
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers
