Applies to: SQL Server Azure SQL Managed Instance This article describes how to set or change the database collation by using SQL Server Management Studio (SSMS) or Transact-SQL. If no database collation is specified, the server collation is used. Recommendations You can find the supported ...
table size, and the physical columns in the table.The first measurement, the database size and amount of data used at this point, can be queried using the T-SQL below.
In the last article ‘ SQL Server FILESTREAM and Replication’, we configured the SQL Server replication on the FILESTREAM database. We cannot use CDC and Replication together because Replication also tracks the changes from the transaction log. Expand the Replication folder in the SSMS and we ...
As far as getting stuff like creation dates and modified date, I'm assuming you want that information at the table level. I'm not sure what type of SQL you're using, but in MSSQL, you can open SSMS and go to the table properties and see the creation date. EDIT: The las...
Can we optimise While Loop in sql server for large number of data? Can we pass parameters to the trigger?(Beginner) Can we RAISERROR inside MERGE Statement Can we select Bottom 1000 rows of a database Table from SSMS 2008 R2? Can we set value in a variable inside a select statement ca...
How to quickly search for SQL database data and objects in SSMS How to export SQL Server data to a CSV file Why, when and how to rebuild and reorganize SQL Server indexes How to format SQL code in SQL Server Management Studio SQL Server Management Studio (SSMS) – how to save results ...
Set up an example database,AdventureWorks Create a new SQL Change Automation project within SQL Server Management Studio (SSMS) Set up a new development database Baselinethe development database fromAdventureWorks Make changes to the development database, andgenerate migrationsfor the SQL Change Automat...
Tony Davis explores how SQL Change Automation is increasingly providing ways of working with SQL Clone, to improve the quality of testing for database changes. With SCA v4.3, developers can now use the SSMS plugin to create a clone of the target database, to be used as a re...
Change authentication mode with SQL Server Management Studio In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then selectProperties. On theSecuritypage, underServer authentication, select the new server authentication mode, and then selectOK. ...
These are easily produced from either SSMS by point ‘n click, or automatically via SMO. I show how to do this automatically here in Scripting out SQL Server Data as Insert statements via PowerShell. If you use the PowerShell script, you’ll...