Archivo de la categoría: SQL Server

Bitacora de SQL Server

CREATE SYNONYM ( join multiple databases in tableau sql server)

CREATE SYNONYM [dbo].[tbl1] FOR [db1].[dbo].[tbl1] The above code, if run on db2, would create an object tbl1 which would behave as a table under the dbo schema in db2, but would actually reference [db1].[dbo].[tbl1]. If you are on 2000, then no, it’s fully qualified names or nothing, I’m afraid. Nota: –>Ubicarse en la base donde… Leer más »

Suggested Max Memory Settings for SQL Server 2005/2008

Suggested Max Memory Settings for SQL Server 2005/2008 Posted on October 29, 2009 by Glenn Berry https://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/ It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to… Leer más »

SQL Home Database Administration HDDs, SSDs and Database Considerations

https://www.simple-talk.com/sql/database-administration/hdds,-ssds-and-database-considerations/ A technical journal and community hub from Red Gate Join Simple-Talk Sign in Home SQL .NET Cloud SysAdmin Opinion Books Blogs Forums SQL Home Database Administration HDDs, SSDs and Database Considerations Av rating: Total votes: 33 Total comments: 5 send to a friend printer friendly version HDDs, SSDs and Database Considerations 09 January 2013… Leer más »

Database Price

http://www.microsoft.com/sql/howtobuy/default.mspx Note: The retail price for Microsoft SQL Server 2005 Developer Edition is $49.95. Microsoft SQL Server 2005 Developer Edition may be installed and used by one user to design, develop, test, and demonstrate your programs. SQL Server 2005 Pricing Comparison: Retail versus Example Pricing   Processor License   Server plus User/Device CALs    … Leer más »

SQL Server Port Firewall 1433

SQL Server es una aplicación Winsock que se comunica a través de TCP/IP utilizando la biblioteca de red de sockets. SQL Server escucha las conexiones entrantes en un puerto concreto; el puerto predeterminado para SQL Server es 1433. El puerto no tiene por qué ser el 1433, pero 1433 es el número de socket oficial… Leer más »

Backup – Restore SQL 2005

T-SQL code BACKUP: USE myDatabaseName GO BACKUP DATABASE myDatabaseNameTO DISK = ‘C:\filePath\myDatabaseName.bak’NAME = ‘The name of the back up.’   RESTORE: RESTORE databaseName FROM DISK = ‘C:\filePath\backupFilename’ Tags: backup, restore