SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Increment column from 1-10 in select statement, tally or simple ROW_NUMBER?

  Hello all, What's the best way to increment a column in a select statement? I know that this will A…

  Jared

  5 replies

  14 years, 8 months ago

  By: roryp 96873

• Target Server Memory (KB) and Total Server Memory (KB)

  Hi all, I have a query about setting the Target Server Memory (KB) and Total Server Memory (KB) val…

  bathawes 16438

  8 replies

  14 years, 8 months ago

  By: bathawes 16438

• Changing the Initial file size

  Good Morning everyone, I am about to run out of space on one of my important databases. The initial…

  rvphx

  6 replies

  14 years, 8 months ago

  By: rvphx

• update of a column based on max date and group by

  i have three tables orders, orders_delivered, orders_delivered_sta and the data in the three tables…

  mtkr

  3 replies

  14 years, 8 months ago

  By: rvphx

• BOL Hyperlink Not Working Issue

  I have SSS2008 R2 installed on my desktop (Windows Vista 32bit) and my laptop (Windows 7 64 bit) an…

  YSLGuru

  2 replies

  14 years, 8 months ago

  By: YSLGuru

• Qoute " in output ????

  Hi, I am using the following : SELECT top 1 TAG_NAME = 'CUST_Height', TAG_DATA = UDF_VALUE_VARCHAR2…

  jbalbo

  1 replies

  14 years, 8 months ago

  By: Sean Lange

• complex problem

  I have a 2 node active passive cluster. They are dell 810 with 4 6core procs, 128 gigs ram and 10T…

  John Burris

  6 replies

  14 years, 8 months ago

  By: Jeff Moden

• How can i test SSIS package in QA Environment?

  I had created the SSIS package in DEV environment. But i want to test my SSIS package in QA Enviro…

  Jay Pete

  7 replies

  14 years, 8 months ago

  By: Jay Pete

• Indexes not being used that are Clustered and Primary Key

  I have to contend with an app that the developers use called WebCodeGen. While I am not familiar wi…

  Geoff A

  3 replies

  14 years, 8 months ago

  By: Geoff A

• Possible index corruption

  I took a db backup from a SQL Server 2000 SP4 database and restored it into SQL2008 R2 SP1 and I go…

  Anonymous

  1 replies

  14 years, 8 months ago

  By: Grant Fritchey

• sql time duration of SP with Profilers

  I am not an expert with SQL profiler I want to know which sql directive from storage procedure tak…

  pereubu

  2 replies

  14 years, 8 months ago

  By: pereubu

• How to duplicate a table?

  How to duplicate a table structure using code, including all index and setting?

  adonetok

  1 replies

  14 years, 8 months ago

  By: Bru Medishetty

• SQL Server retrieval error under heavy load (200 concurrent users)

  Hi, Currently I'm facing an issue in a SQL Server retrieval procedure. Stored procedure returns une…

  harish.mohan

  5 replies

  14 years, 8 months ago

  By: harish.mohan

• copy tables from local machine to remote machine

  I have a central server and 3 local servers for 3-offices. The database structure is same in 1-serv…

  sanjayasamantaray

  6 replies

  14 years, 8 months ago

  By: Bru Medishetty

• How to grant db_dtsadmin role?

  Hello all! I'm sorry for this question, but i really don't understand something very simple. I want…

  pavlenych

  3 replies

  14 years, 8 months ago

  By: pavlenych