Server Configuration

Query runs faster with fewer parameters
I have this query I'm running for a client. I changed the select to select * to make things clearer. The problem is the last line in the where clause - down at the bottom: select ak.* FROM ihs_charge_accession_key ak join IHS_Charge_Accession_File a on ak.Billing_Enc_ID = a.Billing_Enc_ID LEFT OUTER JOIN ... 23 Jun 2010 18:26

Add Calculated Series in SSRS not there
Desperately need help with something very simple! I'm working with SSRS 2008 in my Visual Studio 2008. I would really like to use the functionality "Add Calculated Series" when I right-click eg. Sum(Value) in my chart. Problem is, there is none?! Anybody encountered the same issue? Thanks! ... 23 Jun 2010 08:25

Help with license for SQL 2008
Hi, i've downloaded SQL 2008 from our Licensed download page and upon running the setup i selected "Trial" and there seems to be a Serial Key pre-entered . I completed the setup and now if i open SQL Mgmt Studio and when i checked on the "About" tab, there is nothing indicating the duration of the trial versio... 22 Jun 2010 14:57

SQL Questions
Hi, i am from Spain, excuse my Inglish I have a Windows Server 2003 R2 x64 1) can I install SQL 2000 Standard Edition? 2) Can I downgrade SQL 2008 Standard Edition licences to SQL 2000 Enterprise? 3) Need Windows 2003 R2 x64 SQL Enterprise Edition or can i install the SQL Standard? Thanks for all and excus... 22 Jun 2010 14:57

SQL memory management
We have a client with a SQL2000 EE sp3 on Win2003 EE as a 2 node cluster. The the nodes are 16 CPUs each with 18GBs memory. The boot.ini has the /PAE switch (no /3GB) and the SQL server does not have the AWE setting turned on. Will the SQL server use more than 2GB memory with the AWE set to 0 and MAX memory set... 24 Jun 2010 17:30

buffer latch 2 timeout error when connectiong to db from mgmt stud
I am receiving a timeout error when trying log into a server from sql mangament studio. The Db is upa nd running fine except all of the backup jobs are suspended. I can connect fine the the sqlcmd as well. Does anyone know what is going on with this? It just started acting up this way yesterday. -james E... 22 Jun 2010 17:10

How to CONCATENATE >50 fields in Excel table into SQL Insert State
To bypass the limitation of the use the & sign instead of using =Concatenate... i.e. =CONCATENATE(A1,A2,A3...) is the same as =A1&A2&A3 with this, you bypass the limitation of the "50 Fields" you are encountering.. I know this late (by 2 yrs) but if anyone elses searches for this hopefully this will he... 21 Jun 2010 15:49

Database Collation Change - Unusably slow Import/Export Wizard
Hi, I am trying to change the database collation (+ all defaulting columns). I have created a new database with the new collation and have tried to use Import/Export Wizard to transfer the data and create the new tables. IT IS UNUSABLY SLOW... ~5000 records every half hour, or possibly even worse. The o... 28 Jun 2010 10:37

What's the next release after SQL Server 2008 R2 & when?
I am confused as to the release of SQL Server 2008 R2. Is this the supposed SQL Server 2010 release? or some sort of stop gap release? What's the next planned release, SQL Server 2011, or 2012 or....? any advise would be great. thanks, GrampaJoe ... 22 Jun 2010 17:10

Get all FKs with their table names, PK/FK fields
Upon closer inspection the query returns too many results since the ordinal position of the field is not taken into account. The following SQL is correct: SELECT FK_Table = fk.table_name, FK_Column = fkc.column_name, PK_Table = pk.table_name, PK_Column = pkc.column_name, constraint_name = fk.constrai... 21 Jun 2010 04:48