SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Update All columns in table

  HI , I have table EMP(source), in this i have 5 columns we don't know which column was updated in t…

  Arjun123

  7 replies

  13 years, 3 months ago

  By: demonfox

• Sql Merge Output

  If I use a SQL Merge with an Output Clause, If I dont specify an INTO, it works fine However, If I …

  xxx-593414

  4 replies

  13 years, 3 months ago

  By: HowardW

• Sql Query for removing duplicate rows in SQL server 2008

  Sql Query for removing duplicate rows in SQL server 2008 For exp CREATE TABLE DuplicateRcordTable (…

  sreenu_rvkl

  4 replies

  13 years, 3 months ago

  By: Lokesh Vij

• Unique Constraint on existing table with duplicate data

  Hi, I have a table called GN_CarParkingAreas Fields: 1. CarParkId int PK 2. CarParkNo varchar(10) n…

  Anju Renjith

  7 replies

  13 years, 3 months ago

  By: Anju Renjith

• problems to copy out SSID packages to file

  Hello from germany! I have a problem with copying a SSIS in MSDB out to as a file stored as a singl…

  willi r

  4 replies

  13 years, 3 months ago

  By: willi r

• TIME/DATE Datatypes Accuracy.

  Hi all, What is the meaning of "Accuracy of 100 nonseconds" in case TIME data type in sql server 20…

  SQL*

  6 replies

  13 years, 3 months ago

  By: SQL*

• sql server datapage storage content

  hi all, Is the Data Page contains the data from a single table or multiple tables data. 🙂

  SQL*

  5 replies

  13 years, 3 months ago

  By: Perry Whittle

• select and condition column+column

  Hello, is any possible idea for faster performance ? I have two columns date and sequence, so i n…

  tony28

  20 replies

  13 years, 3 months ago

  By: Ant-Green

• Can't shrink physical logfile size.

  Hi, Under Sql 2008 I really need to shrink the physical size of the logfile. The database uses fu…

  davidgray

  7 replies

  13 years, 3 months ago

  By: davidgray

• if Updated my table i want change status

  Hi, I was updated my table ,then i want change status_flg in updated table is it possiable ? help m…

  Arjun123

  1 replies

  13 years, 3 months ago

  By: Stupeo

• SQL 2008 R2 Installation - Missing Instance Features

  Hey everyone. I'm trying to install a Database Server using SQL Server 2008 R2 Enterprise edition o…

  nmadrigal

  9 replies

  13 years, 3 months ago

  By: andrew.j.borelL

• Transactional Replication Subscriber Database becomes in Recovery

  I have setup transactional replication between 1 publisher and 2 subscribers. 5 Databases are being…

  alanlee

  1 replies

  13 years, 3 months ago

  By: alanlee

• Nested replaces ?

  Hello all, At this moment I need some nested REPLACE actions. Some time ago I saw a set of routines…

  ben.brugman

  40 replies

  13 years, 3 months ago

  By: Dwain Camps

• Computed column with/with out PERSISTED

  Hi All, While reading about Computed column if found that if we mentioned PERSISTED Key word while …

  SQL*

  17 replies

  13 years, 3 months ago

  By: Jeff Moden

• best practices for service accounts

  I'm installing a new copy of SQL Server 2008 R2 on my Windows 7 computer. I'm at the point of Serve…

  e1785

  1 replies

  13 years, 3 months ago

  By: Richard Fryar