SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

  I'm connected to SQL 2008 R2 sp1 via SSMS as myDomain\User1 I am receiving error message trying to …

  Express12

  1 replies

  14 years, 8 months ago

  By: Express12

• error in SSAS cube

  Hi, I am facing this below error while processing the SSAS 2005 cube. The cube is getting processed…

  mailsrivatsa

  1 replies

  14 years, 8 months ago

  By: LutzM

• using dbcc commands

  hi all can we run dbcc commands on db which is 1 TB of Size. i.e like check db,indexdefrag,opentr…

  sudhir.tvs

  7 replies

  14 years, 8 months ago

  By: Gail Shaw

• help with parameter in ssis

  hi need to assign this value DATEADD(S,-59, DATEADD(s,-1,DATEADD(M,1, DATEADD(D, 1 - DATEPART(D,…

  sqlmaverick

  3 replies

  14 years, 8 months ago

  By: Ashok Teotia

• How do I give SQL Server 2008 R2 More Ram?

  I am running Windows 2008 R2 web server. How do I allot SQL Server 2008 R2 more ram? Where do I go …

  markpringle

  9 replies

  14 years, 8 months ago

  By: ChrisTaylor

• Using show actual execution plan causes increased execution time

  I have a query that uses multiple functions & 8 subqueries. When I run it in SSMS without sho…

  John D

  17 replies

  14 years, 8 months ago

  By: Ninja's_RGR'us

• Index Writes

  Hi, In my company, the hosting team schedule indexes once a week. My understanding is that is when …

  Rainmaker097

  5 replies

  14 years, 8 months ago

  By: Rainmaker097

• Scaling SQL Server with More Cores vs More Instances

  Assume I have multiple databases running on a single SQL server and need to increase CPU resources …

  smjhunt

  2 replies

  14 years, 8 months ago

  By: smjhunt

• Database Design for Storing Recipes

  Hello Everyone I am working on a small project for my wife & I. We have a cake business, and I…

  AndrewSQLDBA

  6 replies

  14 years, 8 months ago

  By: AndrewSQLDBA

• SSRS

  Hello all, I have following field in report. ID RespID balance Mibalance MaBalance …

  patla4u

  5 replies

  14 years, 8 months ago

  By: Ninja's_RGR'us

• Network binding order

  Hi.. I Am getting the following waring message while installing the sql server 2008 cluster x64 in …

  sudhakara

  13 replies

  14 years, 8 months ago

  By: matthew.lass

• using Full Text Search in SQL Server 2008 which is on a Windows Server 2008 R2 64 bit machine

  Hi, I have to implement Full Text Search. I have the binary data of the PDF files in a table. In de…

  SJanki

  2 replies

  14 years, 8 months ago

  By: SJanki

• Migrating to SQL Server 2008 R2 prior to SP1 release

  Thanks Luke C MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Develo…

  Luke C

  6 replies

  14 years, 8 months ago

  By: Luke C

• install sql server 2008 on the same server with sql reporting service 2005

  We would like to upgrade SQL reporting service from sql 2005 standard to sql server 2008 standard. …

  sqlfriend

  1 replies

  14 years, 8 months ago

  By: sqlfriend

• trying to pass year parameter to a stored procedure

  I have a merge statement I want to encapsulate into an SP. Then I want to be able to pass the sp a…

  KoldCoffee

  1 replies

  14 years, 8 months ago

  By: KoldCoffee