SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL SERVER sp_msforeachdb

  When i use the following sp_msforeachdb @command1='USE [chapter];SELECT * FROM sys.Tables' it repe…

  chandrika.r 91171

  10 replies

  14 years, 7 months ago

  By: Ant-Green

• Can i detach db being in 'norecovery' state?

  The goal is to restore log on different 'stopat' values without 'restore database mydb from c:\bkp.…

  solver

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• trigger on a view

  I want to be able to put a trigger on a view to update a table in another database. I have been sup…

  cathalobrien@gmail.com

  7 replies

  14 years, 7 months ago

  By: Jared

• How many is too many multivalues ?

  What is the limit to the multivalue array or is there one ? In my case the user selects all product…

  Maija

  6 replies

  14 years, 7 months ago

  By: Jayanth_Kurup

• How to identify how much memory SQL is using, outside of the buffer pool

  I have a server with 32GB of RAM. My instance is configured to use 27GB of ram, leaving 5 for the O…

  winston Smith

  1 replies

  14 years, 7 months ago

  By: sengeet86

• Best Index to Create

  Hi All, I have a Typical 3 table Types Type: One Column with Identity, One Column with Code, StartD…

  sudhirnune

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• Migrating user sql server 2000 to sql server 2008..?

  Hi Friends, How to Migrating user Logins with password from sql server 2000 to sql server 20…

  Coolroof

  3 replies

  14 years, 7 months ago

  By: Ant-Green

• SQL SERVER(T-SQL)

  hi all, i need to write a store procedure in sql server Populate the city_summary table based on t…

  maheshkrishnas

  2 replies

  14 years, 7 months ago

  By: maheshkrishnas

• Performace hit on server when using sp_send_dbmail

  We are moving our site and database onto a new system. Historically we ran some run jobs everynight…

  jflynn-735049

  1 replies

  14 years, 7 months ago

  By: Lowell

• Some differences between Oracle and SQL Server

  Hi there , How are you doing all ? In oracle database, when I want to see some details about memory…

  ssaleh.k

  4 replies

  14 years, 7 months ago

  By: SQLCereal

• Stored Procedure Help

  Hi, my job is to get this result set Emp_name, Work_date, Shift_Description, Unit_description, Star…

  njdevils39

  16 replies

  14 years, 7 months ago

  By: Jared

• Varchar(max) performance problem in SQL server 2008 R2

  Hi all, I have this problem: We have a table with a varchar (max) column. This column constantly ca…

  e90fleet

  6 replies

  14 years, 7 months ago

  By: Johan Bijnens

• can any one just help me to write a insert storeprocedure

  here iam having 5table which has inner joins to each others TABLE1 QuestionPaperId (PK) Quest…

  Sivaganesh Tamilvendhan

  2 replies

  14 years, 7 months ago

  By: Sean Lange

• Upgrading a SQL Server 2005 Clustered Environment to SQL Server 2008 R2

  Has anyone out there upgraded a SS 2005 clustered environment to 2008 R2. Looking for tips and wha…

  oradbguru

  2 replies

  14 years, 7 months ago

  By: Perry Whittle

• Wondering why ERROR on a specific case of smallmoney

  select (cast ('1' as smallmoney) * 100000) select (cast ('1' as smallmoney) * 1000000000) select (c…

  SqlServerPass

  8 replies

  14 years, 7 months ago

  By: Eric M Russell