Server Configuration
in [Microsoft SQL Server]
|
select with subquery in select clause Hi I need to make a select from 2 tables whit this layout always with the newest datetime exchange currency. The local cuurency is Mexican Pesos Table 1 Currencies example: CurrencyID Key Description 1 USD USA Dollar 2 EUR European Euro 3 Yen Japan Yen Tabla 2 is Day exchange Currency CurrencyID Equivale... 7 Aug 2010 13:40
select with subquery in select clause Hi I need to make a select from 2 tables whit this layout always with the newest datetime exchange currency. The local cuurency is Mexican Pesos Table 1 Currencies example: CurrencyID Key Description 1 USD USA Dollar 2 EUR European Euro 3 Yen Japan Yen Tabla 2 is Day exchange Currency CurrencyID Equivale... 7 Aug 2010 15:51
SQL Server 2008 R2 Native Client backward-compatible to SQL 2005/2008?? We have several different SQL Server versions in our datacenter, with SQL Native Client 9.00.1399.06 on our Citrix servers. The above SQL Native Client goes with our Great Plains app client, it's possible we will have a new, higher-level SQL Native Client installed by another application client... Can differen... 9 Aug 2010 14:35
Report server setup for multiple applications We are trying to build a consolidated Report server environment that should fulfill all the requirements for different application. We have implemented this on SQL Sever by creating different databases for different applications on the same SQL Instance and then those applications use different set of Login account... 5 Aug 2010 19:11
How much memory should be free on a Server with SQL Server installed? I am the new DBA in a company and I see that their production server has between 90 and 95% of memory been used. The problem is that according to the task manager, is not SQL Server or related services which is using the memory, in fact is using only 460MB and MS SQL Server Analysis services is using 571MB, Rerport... 5 Aug 2010 18:04
Auto Update Statistics We are running SQL Server 2008 SP2 Enterprises. We have a table with a column that identifies individual clients, such as Client_UID, which is an int data type. So, if the table has 1 million records, as an example, and we have 10 clients represented in this table, let us assume each client has 100,000 records. ... 5 Aug 2010 15:48
Pages for Database's Indexes. What is a way to get the number of pages for each database's tables and indexes, so I can see all the number of pages and size. Just trying to streamline and check for fragmentation in indexes, and I have to either individual go through each database and go to each table and find out page size or is there a way to... 4 Aug 2010 16:55
Backups I created an incremental backup of one of my databases and set it to backup every hour as a test. It's on SQL Server 2000. How do I stop it. It's not listed under maintenance plan anywhere. ... 4 Aug 2010 16:55
linked servers between different sql versions?? Can a SQL Server 2008 server have a linked server that is SQL Server 2008 R2?? We presently use a SQL Server 2008 for reporting which links to a SQL 2005 server that will be replaced by a SQL 2008 R2 server, we need to link to a SQL Server 2008 R2 database from a SQL 2008 server. Note: The linked server is onl... 4 Aug 2010 15:49
Primary records with dependent as columns I have a query to fetch primary with all dependents that gives me result as: ID Primary Name depId DepName Dep DOB 10 Liselotte E. Mitnick 11 Daniel W. Mitnick 1986-06-30 10 Liselotte E. Mitnick 13 Ali E. Mitnick 1986-06-30 ... 4 Aug 2010 15:49 |