SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Data compression in a field - is it possible?

  I have a laboratory instrument testing about 500 samples of product per day. Each test produces a t…

  db-1061069

  5 replies

  14 years, 9 months ago

  By: db-1061069

• got performance problem in running store procedure....

  the store proc which is in production suddenly got a performance problem, the store proc runs smoot…

  sqlmaverick

  5 replies

  14 years, 9 months ago

  By: Jack Vamvas

• need technique to find duplicates which are causing PK constraint failure during merge

  I am merging two tables: TBLANIMAL (as T) animal varchar(40) haveit bit name varchar(30) ANIMAL (as…

  KoldCoffee

  6 replies

  14 years, 10 months ago

  By: Jeff Moden

• problem with retveing data

  hi, i have the following table :Products(item1,item2,total) with the data: item1 | item2 | total | …

  chanukae

  1 replies

  14 years, 10 months ago

  By: Ron McCullough

• Stored Procedure Statistics

  I want to log my stored procedure which client use how many times execute which parameters set etc.…

  ESAT ERKEC

  12 replies

  14 years, 10 months ago

  By: ESAT ERKEC

• How to get CustomerCount based on Customer Updated by Users and their UserTypes

  Hi I have 3 tables UserMaster UserID NameCreated_on UserTypeID 123John 20/07/2011 1 456…

  mayil

  1 replies

  14 years, 10 months ago

  By: LutzM

• Table Without a Primary key?

  Dear Sir, Why does SQL Server allow to create a Table Without a Primary key ? What is the intention…

  Subrata Bauri

  32 replies

  14 years, 10 months ago

  By: Subrata Bauri

• SQL Server Sessions Stateless or Statefull ?

  I am confusing ,SQL Server makes the connection and handle multiple sessions ?,SQL Server make sess…

  orakid

  2 replies

  14 years, 10 months ago

  By: orakid

• DBF file with Thai Characters

  Hi I have been given a number of dbf files to import into sql tables.. I am using SSIS 2008 to do …

  graham 47698

  2 replies

  14 years, 10 months ago

  By: graham 47698

• DTS package error with SQL Server 2008 R2

  Tried everything, still getting the same 'SQL Server 200 DTS Components...' error message with 2008…

  chukostar

  14 replies

  14 years, 10 months ago

  By: Welsh Corgi

• clarify some conecpts of SQL client

  I would like to clarify some concepts for installation. If a person only needs a sql server client,…

  sqlfriend

  3 replies

  14 years, 10 months ago

  By: LutzM

• Global Temp Tables and RAM usage

  Can someone shed some light on global temp tables (##temp) and the relationship they have with RAM?…

  nawillia

  10 replies

  14 years, 10 months ago

  By: nawillia

• How to run TSQL Job Step under different account

  The job owner account has no permissions except for what is stated below. I need to run an Exec St…

  TangoVictor

  3 replies

  14 years, 10 months ago

  By: TangoVictor

• Snapshot replication issue

  I have 3 servers (A, B, C). I have setup up snapshot replication from A to B and B to C (all using …

  bryandb

  2 replies

  14 years, 10 months ago

  By: bryandb

• Index seek or Index scan

  Hello All This is my table CREATE TABLE [dbo].[XYZ]( [DATE] [datetime] NOT NULL,--FOREIGN KEY [EX…

  patla4u

  2 replies

  14 years, 10 months ago

  By: LutzM