SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Archiving old data in CSV file

  Hi, I have a huge table that is growing very fast (500000 row per day ) I need to keep data in this…

  houdou2

  1 replies

  15 years, 5 months ago

  By: houdou2

• Witch query is more efficient??

  Witch query is more efficient?? Table Structure: CREATE TABLE [dbo].[tbl_test]( [ID] [int] NOT NUL…

  ahmed.net

  5 replies

  15 years, 5 months ago

  By: Gail Shaw

• Retrieving data from SQL2008 to XML via Web Service

  Dear Friends, One of our customers would like to get their invoice data from Web Service in XML for…

  VAL_mi

  2 replies

  15 years, 5 months ago

  By: VAL_mi

• Regarding backup of database from local system to public ip system

  Hi, how to take backup of database from local system to public ip system? Database on local system.…

  goldspoon

  5 replies

  15 years, 5 months ago

  By: Gail Shaw

• Can drop temptable from different server?

  Dear all, I want to know that can I drop temp table from different server? tables are existed in Se…

  naunton

  8 replies

  15 years, 5 months ago

  By: naunton

• clearing DMV stats. SQLPERF does not work.

  I want to clear the following DMV/DMF's: sys.dm_db_index_usage_stats sys.dm_db_index_operational_st…

  winston Smith

  6 replies

  15 years, 5 months ago

  By: winston Smith

• converting oracle code to sql server code

  Hi guys Please help me to convert below mentioned oracle query into sql server. want to retrieve al…

  leodec

  6 replies

  15 years, 5 months ago

  By: leodec

• Database recovery scenario

  Backup Plan -Full backup sunday 12:00 pm -Fifferential backup sun-sat 7:00 PM -Tran log backup ever…

  M&M

  2 replies

  15 years, 5 months ago

  By: Gail Shaw

• Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 524288

  Hi All, See previous posting Regards, Paul

  pakman

  1 replies

  15 years, 5 months ago

  By: Gail Shaw

• How to License SQL 2008 Enterprise in Clustered Environment?

  Hi All, How do I go about Licensing an SQL 2008 Enterprise in a Clustered Environment? Thanks.

  smile_netz

  2 replies

  15 years, 5 months ago

  By: smile_netz

• Using DAC To Fix 8992 Corruption Error

  I have a large database which we are about to move to SQL Server 2008. Up until this point, it has…

  mnDBA

  2 replies

  15 years, 5 months ago

  By: mnDBA

• SQL Server Reporting Service 2008 on vista home premium

  I have installed SQL Server 2008 Developer edition on VISTA Home Premium. Even though Reporting Ser…

  vstitte

  13 replies

  15 years, 5 months ago

  By: iyacaman

• Query Editor SSMS 2008 R2 Strange Script

  I just removed SQL Server 2008 Developer and installed SQL Server 2008 Developer R2. Ever since the…

  webooth

  2 replies

  15 years, 5 months ago

  By: webooth

• SQL Server 2008 Activity Monitor error

  When I trying to Open Activity Monitor in SQL 2008 PROD server. Getting following error. TITLE: Mic…

  anzz

  1 replies

  15 years, 5 months ago

  By: Adiga

• Install sqlserver-2008 Enterprise Evaluation

  Hi, I have laptop installed windows vista sp-1. I need to learn sql server-2008 so i plan to downlo…

  muthukkumaran Kaliyamoorthy

  6 replies

  15 years, 5 months ago

  By: samirthukrall