|
Παρουσίαση με Ετικέτες
Όλες οι Ετικέτε... » sql (RSS)
-
It might come time where you need to alter your database to use a different collation. You can do this using the following snippet: [crayon-58480392872f2119297576/] When you execute the above snippet you may come to the following error: This error occurs when your database in Multi-User mode where users are accessing the database or there are objects referring to your database. To overcome this error,...
|
-
To get a rough view of how many rows, total, used and unused space each table has, in a sql server database you can run the following query: [crayon-583450f43d6a5734372322/] Another way is using the stored procedure sp_spaceused which displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in...
|
-
In Entity Framework code-first, if you have a domain model like the following: [crayon-582b152280188265428148/] and want to create an index for a string property, when you execute update-adtabase for your migration, you may end up with the following error: This usually happens when you use VARCHAR(max) which is the default column type when creating a string property in EF. To make...
|
-
In Azure if you have two or more SQL Databases and you want to perform a query across them, you might come across the following error: [crayon-579cfaea2349f498907233/] In order to perform cross database queries among SQL Azure databases you need to use the elastic database query feature. What is the Elastic Database Query Feature? The elastic database query feature enables you to run a Transact-SQL query...
|
-
-
These are some quick notes on how to configure an SQL Server to Listen on a Specific TCP port. Open Run Command line and type: SQLServerManager12.msc for SQL Server 2014 SQLServerManager11.msc for SQL Server 2012 SQLServerManager10.msc for SQL Server 2008 and press Enter. To assign a TCP/IP port number to the SQL Server Database Engine In SQL Server Configuration Manager, in the console...
|
|
|
|