SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Bulk Insert Peformance Question

  We have a SQL Server document repository that we need to get content into. I currently have a flat…

  Adam Kreul

  6 replies

  15 years ago

  By: Adam Kreul

• How to Find Duplicate Images

  Hi, CREATE TABLE #tblImage ( ImageID int IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [Image] imag…

  Selvam Rajendran

  1 replies

  15 years ago

  By: ChrisM@Work

• After Update Trigger Problem

  Hi Frnds, I wrote an simple AFTER UPDATE trigger, i just wanted to amke a try to GET THE VALUE…

  Subbu S

  1 replies

  15 years ago

  By: Subbu S

• Help Me Guys

  Hi All, Iam facing the problem, which i described below, its for auditing purpose. Audit Deati…

  Subbu S

  13 replies

  15 years ago

  By: Subbu S

• how to replace data from another database?

  I am using Import wizard to import data from SQL server 2000 to SQL server 2005, but everytime I im…

  mak101

  15 replies

  15 years ago

  By: homebrew01

• SQL 2005 STD : Message A significant part of sql server process memory has been paged out. This may result in a performance degradation

  Hello, Today, I was creating Snap Shot for replication and I notice that I was received the follow…

  Champs123

  8 replies

  15 years ago

  By: Jeffrey Williams

• Invalid object

  Hi, I am using a temp table in my sp. I have written the following tsql before and after using the …

  sreecareer

  4 replies

  15 years ago

  By: ColdCoffee

• Stored Procedure vs Parameterized queries

  I have a developer who keeps praising the Parameterized Queries instead of stored procedures. Can y…

  ramoha

  5 replies

  15 years ago

  By: David.Poole

• Linked server from sql 2005(32 bit) to sql 2008(64bit)

  Hi, I want to create a linked server on my sql 2005(32 bit, windows 2003-32bit) which should conne…

  atin.kumar 62362

  2 replies

  15 years ago

  By: Jeffrey Williams

• searching an unicode string (arabic text) in a coloumn

  Hi All, i have a table where couple of coloumns consititues Arabic text . my requirement is to sear…

  jaipal vallabhaneni

  2 replies

  15 years ago

  By: jaipal vallabhaneni

• Query to find all special symbols in a column

  Hi all, In sql 2000 we could see some special characters showing up for a nvarchar field where as i…

  Selvam Rajendran

  4 replies

  15 years ago

  By: WayneS

• Rollback or Delete? Which is nore efficient?

  One of my colleague wrote a Insert trigger on Table A. It calculates value for some of the fields…

  Annie-469370

  4 replies

  15 years ago

  By: Annie-469370

• What type of join?

  I have a table of 'rules' to do pattern matching and a master table to report data from. Some produ…

  MissyDaisy

  2 replies

  15 years ago

  By: MissyDaisy

• Simple list of relationships possible?

  I want to generate a simple file which gives the relationships between tables with the table name, …

  Cessna185

  3 replies

  15 years ago

  By: SQLRNNR

• SQL Server 2005 32 bit on Windows 7 Professional 64 bit

  Tried to make a clean installation. Management studio not showing on Sql server 2005 start menu onl…

  thulani.moyana 79207

  5 replies

  15 years ago

  By: SQLRNNR