Server Configuration

One table with two date fields returning records in a date range
I have a table that has several columns, two of which are date fields. A start_date and comp_date for start and completion date. I need to run a query that will return all the records between two dates selected by a user. Not hard, piece of cake. The problem I am having is that my query isn't returning all the re... 17 Jun 2010 19:01

move data
Hi, I have a big table(20 GB), I want to archive the data and clean up the table to fast access. Is it this the better way to min downtime: select * into myBigTable20100617 from myBigTable truncate table myBigTable ... 17 Jun 2010 17:54

How to get list of string for particular condt
hi, let consider, A table has following fields, name amount date I know to get sum of amount based for particular date condition be.. select sum(amount) as val from table_name where date='06-16-2010' Same as I want to get list of name for a particular date. How can I achieve this.. -- Mes... 17 Jun 2010 08:58

backup
Hi......... m running this code for backing up and to have backup log backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') ... 18 Jun 2010 09:08

Not able to backup database to different folder
Hello, I am creating a backup of a SQL Database using T-SQL and I get an error when saving it to a folder under Users/Miguel/Backup. The same happens if I use SSMS. If I change the folder to the usual SQL Backup folder there is no problem. Do I need to do something to my Users/Miguel/Backup folder? Tha... 16 Jun 2010 21:04

SQL 2008 vs 2008R2
We currently have SQL Standard 2008 in a 2 node cluster and are investigating perhaps updating to R2. Does anyone know where I could find a comparison that would give us the benefits of this update? ... 17 Jun 2010 17:54

Mirror error message
Hi getting the following error when attempting to start mirroring configuration: The server network address tcp://us-sql01.<mydomain.com>:5022 can not be reached or does not exist. Check the network address range and that the ports for the local and remote endpoints are operational. (sql server error 1418)... 16 Jun 2010 15:30

Unattended installation question
I'm trying to setup an unattended installation of SQL 2008 Express Edition. I want the local administrator of the box to have sysadmin access. How would I put that in the configuration file? Since the Machine name is different depending on the name of the box that I install it on, it can't be hardcoded into t... 16 Jun 2010 15:30

SQL 2008 Compatibility
I am looking for a chart or something that will tell me what Microsoft Products and what versions of these products are compatible with SQL Server 2008. I am expecially interested in APPV, Communications Server, WSUS, SCCM, Operations Manager, and Reporting Services. ... 23 Jun 2010 17:19

Query ???
Hi. Let Create table #temp1(erpnbr int, svpname varchar(50), dcode char(3), ucode char(3)) Create table #temp2(nbr char(13)) Insert into #temp1 values(5585,'John','352','001') Insert into #temp1 values(5585,'John','352','002') Insert into #temp1 values(5585,'John','352','003') Insert into #temp1 values... 8 Jul 2010 01:34