SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Insert multiple columns

  Hi all, I need to insert one row in table.but it has more than 35 columns. I have datatable it has …

  kuppurajm

  3 replies

  15 years, 5 months ago

  By: kuppurajm

• 32/64 bit SSIS 2008 question

  If I understood correctly all I’ve read in these forums… SSIS is 32 bit. So I can develop SSIS pac…

  Randy Doub

  4 replies

  15 years, 5 months ago

  By: Anam Verma

• Stored Procedure Takes long time on one Server, but quick on another

  Hello all, Hello All, Have an interesting problem, where a stored proc is taking about 15 mins when…

  mymail.default

  25 replies

  15 years, 5 months ago

  By: Evil Kraig F

• Error on this code "GO WAITFOR DELAY '00:00:05'"

  I want to run a "GO" and then pause for 5 seconds. When I run this code I get "A fatal scripting e…

  malik_nagel

  2 replies

  15 years, 5 months ago

  By: Evil Kraig F

• transaction size limit

  We have a problem with one process. We get the file full of INSERT UPDATE and DELETE. Problem is th…

  boris_shvartsman

  11 replies

  15 years, 5 months ago

  By: boris_shvartsman

• Activity Monitor questions

  I have a couple of questions about 2008 Activity Monitor. On one of our servers the "% Processor Ti…

  Denise McMillan

  3 replies

  15 years, 5 months ago

  By: Roy Ernest

• SQL SERVER 2008 R2 Install best practice?

  Interested in learning things I can do during install to help availability and performance for the …

  Vertigo44

  2 replies

  15 years, 5 months ago

  By: Vertigo44

• Tsql statements to write to an ascii file onto file server (basically writing log when sql server script runs)

  Howdy, New to sql server. I have a sql server script that needs to run. It runs fine. but it doesn'…

  JasonSmith

  4 replies

  15 years, 5 months ago

  By: JasonSmith

• Unable to use OBJECT_NAME() and context_info() together

  Hi, I'm trying to save the currently running stored procedure to context_info() then pull this out …

  samalex

  1 replies

  15 years, 5 months ago

  By: Lowell

• Missing Index Suggestion

  I have a query and I'm trying to improve its execution speed. The Estimated Execution Plan is sugge…

  Sioban Krzywicki

  8 replies

  15 years, 5 months ago

  By: Sioban Krzywicki

• Connection Errors

  Hi All, I'm having some weird issues connecting to a SQL Server 2008 server from any terminal serve…

  Michael Lee-158245

  2 replies

  15 years, 5 months ago

  By: Michael Lee-158245

• SP makes the version store grow - hanging

  Hi At occasions I've noticed that tempdb grows on one of my SQL Servers. And it keeps growing until…

  andy.l

  6 replies

  15 years, 5 months ago

  By: Pravasis

• Adding data randomly into a column of a table

  Hi All, I have a table with two columns : ID and Name Now two new columns are to be added. so i add…

  malavika.ramanathan

  2 replies

  15 years, 5 months ago

  By: Pravasis

• which one to select in these following option

  hi... everybody sorry for my stupid question.. i've three options for creating the reports 1)crysta…

  vinayak.v

  4 replies

  15 years, 5 months ago

  By: grahamc

• Partition Table Switch Error

  Hi All I have created a partition table on a database and I can see that the partition ha…

  CrazyMan

  4 replies

  15 years, 5 months ago

  By: CrazyMan