Server Configuration

How to create select query?
I have the following tables: tblQueue: QueueID, CustomerID, ProductID, WeekIDFrom, WeekIDTo tblSchema: CustomerID, ProductID, WeekID I need help with creating a select query which returns products from tblQueue that don't exist in tblSchedule during the same week. Please note that a booking in tblSchema ... 27 Jun 2008 05:59

Performance monitor, execution io question
Hi folks. I hit problem which i can't explain so you could help me. I try to fix existing application and run sql perf. monitor to get biggest io offenders. So i get them into table and select them ordered by 'reads' in desc order. Than I get text and try to run it from my desktop with 'set statistics io on' s... 29 Jun 2008 17:17

SqlServer Culture Info
Dear All, I am accessing Sql Server using C#, System.Data.SqlClient. Problem with DateTime. When the server is located in different part of the world it uses different culture and display DateTime in different format. Besides, the First Day of a week is also different. So, may I know how can I get the Cul... 27 Jun 2008 10:05

add an aggregate to a SELECT
This query gives me what I want except there are multiple sightings for a car from INTERNAL_CLM. All I need is the most recent one. So I need the max(sighting_date). I don't know how to write it with the aggregate. The 3 fields are car_mark, car_number and sighting_date. Would that be a self-join on INTERNAL_CL... 26 Jun 2008 19:47

How to encrypt data so DBA can decrypt
How do you encrypt data in SQL 2005 so the DBA or SQL Server adminstratior can't decrypt? I don't see an easy way, but I found a blog that indicated it may be possible. thanks -John ... 27 Jun 2008 03:57

Sorting "both" ways?
Ok, bear with with me here... I have a big table (well, 500 rows) that has a list of debits, credits, and "other". I'd like to write a SQL statement to retrieve these, sorted in an odd way... 1) sort by group, so we get all the credits, then the debits, then the "other" 2) sort by magnitude, but not just ABS(... 27 Jun 2008 05:59

SQL Server 2008
Hello, Does anyone knows what is the release date of SQL Server 2008? Thank you, Miguel ... 27 Jun 2008 09:04

HACKED! DANGER! HELP! "SQLDebugger logging into local machine"
Greetings, I am new to SQL. I currently run a server with SBS 2003, MSExchange, SharePoint and some third party software. The SQL versions are: Server 2005, MSSDE and VSS writer. THE PROBLEM When i came into the office today I hit ctrl-alt-del and brought up the logon menu. To my surprise the name in the ... 27 Jun 2008 11:07

SQL Server 2008 developer RC0 missing setup.exe?
I downloaded RC0 onto a Vista Business Dell Optiplex 755 (x86) quad core. My directory listings for \x86 and \setup look like this: C:\downloads\x86\setup>dir /b 1033 catalog config.xml owc11.msi owc11sp1.msp rsfx.msi rssharepoint.msi sqlbrowser.msi sqlserver2008_bol.msi sqlserverbestpracticespolicies.m... 27 Jun 2008 09:04

Issues with Joining Tables
Hello all. I’m having an issue with joining the contents of two tables. The join options available to me seem to have limitations that are keeping me from retrieving all data from both tables. I will do my best to give the table details below, and try to give you an idea of what I want as from the output of the ... 27 Jun 2008 12:09