SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• SQL Server Backup & Restore startergies

  Hi Everyone , We need to implement a datbase back up statergy for one of clients ... Some of the …

  sabarish

  10 replies

  15 years, 2 months ago

  By: Rick.Cornell.SME

• Sql dynamic query

  Hi there, I have to produce the following result set. Gender Count Percentage Male …

  bladerunner148

  5 replies

  15 years, 2 months ago

  By: bladerunner148

• Implicit conversion question

  I ran into a situation yesterday that used a lot of my time. When I update a Decimal(18,6) field ty…

  mpdillon

  19 replies

  15 years, 2 months ago

  By: Paul White

• How do I start a job from a job using msdb.dbo.sp_start_job ?

  Hi, I created a main job that's supposed to execute three other jobs in sequence. The job contains …

  wgrimm

  2 replies

  15 years, 2 months ago

  By: wgrimm

• Check duplicates records while bulk inserting in to Table

  Hello, I want to insert the record in to a table using bulk insert method fro that I use the belo…

  mohanaraj

  4 replies

  15 years, 2 months ago

  By: ChrisM@Work

• SQL Table Insert rate?

  This should be the easiest question for you all. My question is: how many records i can insert into…

  Virender Sihag

  9 replies

  15 years, 2 months ago

  By: Paul White

• Blocking task which I can't figure out.

  Hi all, I have a client that is using some of my software that is getting a strange task blockin…

  Adrian Heald

  6 replies

  15 years, 2 months ago

  By: Paul White

• SQL 2005 SP2 Enterprise Slowness

  Yesterday I had an outage on my SQL 2005 SP2 Enterprise server. Here are the symptoms. 1. I was un…

  jason.nodarse

  13 replies

  15 years, 2 months ago

  By: Paul White

• Importing DBF file into SQL Server2005

  I read over the post here: http://www.sqlservercentral.com/Forums/Topic293409-148-3.aspx and took A…

  Jacob Pressures

  1 replies

  15 years, 2 months ago

  By: Jacob Pressures

• Retrieving Large Videos

  We are storing some somewhat large (15-20MB) videos files in an SQL 2005 table within a varbinary(m…

  sumnerdu

  6 replies

  15 years, 2 months ago

  By: sumnerdu

• how can we store a sql querry inside an xml node

  Hi All, I am new to XML how can we store a sql querry inside an xml node

  shameej_thbs

  3 replies

  15 years, 2 months ago

  By: Adi Cohn-120898

• I want to write Dynamic SQL or stored procedure to calculate similarties between similar fields(having same column name and data type) of two tables.

  I have two tables which contain the same records but those records are entered by different users a…

  mohammad.kamranpk

  1 replies

  15 years, 2 months ago

  By: Atif-ullah Sheikh

• Find the Difference between two tables, listing the column values that differ

  I have a situation in which I get the XML of inserted records and deleted records from the AFTER UP…

  Atif-ullah Sheikh

  12 replies

  15 years, 2 months ago

  By: mohammad.kamranpk

• Candidate Key Or Composite Key

  Which is better to have either Numeric Candidate Key or Composite Key in the dependent table to mak…

  Gopal Rathore

  11 replies

  15 years, 2 months ago

  By: Ben Teraberry

• Insert 10,000 records in one second (LogFile??)

  Hi experts. Yesterday I made topic in here (http://www.sqlservercentral.com/Forums/Topic943563-149-…

  irmorteza2000

  2 replies

  15 years, 2 months ago

  By: Jeff Moden