Server Configuration

add an aggregate to a SELECT
This query works except it gives me multiple car sightings per CLM. All I need is the most recent sighting from a CLM and the history is immaterial. I need the max(c.car_sighting) . I don't know if this should be a sub-query or a correlated sub-query. tia, SELECT c.l_e , c.car_mark , ... 27 Jun 2008 15:15

SQL 2000
I can't seem to find the Microsoft page that compares all the different editions of SQL 2000. I have SQL 2000 Standard running on Windows 2000 (32 bit). I need to migrate the SQL server to Windows 2003 Enterprise 64-bit . Ideally I would like the SQL server to take advantage of the 64 bit architecture. Will ... 28 Jun 2008 08:36

Temporary Info for Preview
I want to watch a Invoice layout before saving and printing (like "Print Preview" option). What is "best"? -To save registers in regular tables and delete them if are not definitive, or -To create temporary tables to do so, or - ? Beforehand, thank -- Luis Garcia IT Consultant ... 28 Jun 2008 03:31

Database growing, performance degrading...
My program is using a SQL Server Express 2005 database. The program runs fine when you first start it, but over time the performance of the the database degrades and my program takes longer and longer to get responses from the database. Rebooting the database server solves this problem. I also notice that when th... 1 Jul 2008 13:22

Incorrect syntax near '1' error from sql server 2005
Hi When i am trying to run this SP i get Incorrect syntax near '1' error from sql server 2005. Here are the SP Values i pass. exec aspnet_Membership_CreateUser 'b3302ad3-6814-4ee8-b5ec-bce1210e6730', 'testuser555', 'Rajesh123', '4A86ynGjk7wnOy4I3Njr9w==', 'info(a)sdsdet.com', 'what Rajesh 123', CAST('1' ... 27 Jun 2008 12:09

hyphen in sharepoint database name
SQL Server 2005 Sharepoint with mirroring of all databases to DR box One of the Sharepoint databases has hyphens in it. This is causing an error in the Database Mirroring Monitoring Job. The error seems almost informational, or at least it is not apparently affecting the mirroring process. When I discontinue ... 11 Jul 2008 01:45

Test format for MCITP (SqlServer2005): 70 - 444
Guys, Is MCITP: 70-444 a combination of 'multiple choice' and "Case Study" or just 'Case Study'? Cuz, when I took my 70-443 test, couple of days ago, I was surprised to see all "Case Study" type questions. I thought, it would be a combination of 'multiple choice' and "Case Study" questions. And any time tha... 27 Jun 2008 11:07

maintenance plan details missing from log
I have created maintenance plan for full backup. Checking value "Log extetended infromation" in diallog "Reporting a Logging". But when report is created, detail information in text file report is missing. By other maintenance plan I with same properties is detail created. Thank you for any help or advice. N... 27 Jun 2008 08:02

Can I use LEFT JOIN to solve this problem ?
There are 2 tables in an application system. The first table "grpmem" contains both group_id and member fields. In the second table "ctct", it contains both data for Role and Member (First Name and Last Name). I have created 2 queries so that the first one retrieve the Group Name while the second one retri... 1 Jul 2008 18:31

sum & running total
1. How can I do running totals group wise efficiently and without using SP? ID GROUP DATE VALUE RUNNING TOTAL 12323434 1 1/4/07 121323.32 ? 12323434 2 ... 27 Jun 2008 05:59