SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• setup maximum and minimum memory

  I have a dedicated SQl server that has 12 gb physical memory. I manually change the default max mem…

  sqlfriend

  3 replies

  13 years, 6 months ago

  By: Bhuvnesh

• ATTACHED SUSPECT DATABASE in SQL2008 R2

  hello to all i would like to ask some assistance for attaching a suspect db a size of …

  jolan.mahinay

  5 replies

  13 years, 6 months ago

  By: prakashmuddu

• Reading data from Excel using Sql

  Hi, could any one shed some light to read data from Excel sheet using SQL code. Requirements 1)Exce…

  subramani.rudrappa 78855

  6 replies

  13 years, 6 months ago

  By: Rich Mechaber

• Table stucture in a database

  Can some one please tell me any query to see the table structure(column name, type) in the database…

  gowri.4ever

  7 replies

  13 years, 6 months ago

  By: Jeff Moden

• Adding two rows of a column display result in another column in same table

  Hi Friends, I need your help i need to show the result table as follows, User Name Total A…

  sajidsdali

  4 replies

  13 years, 6 months ago

  By: Jeff Moden

• Tempdb: per Instance not per Database?

  Hi All! The tempdb system database is created by system per Instance or per Database on SQL Server?…

  bhavinjparmar

  2 replies

  13 years, 6 months ago

  By: bhavinjparmar

• 64-bit vs 32-bit SQL 2008 and development

  I'm configuring a new PC, which is a 64-bit architecture/OS. I'm doing some development on this bo…

  Rod at work

  5 replies

  13 years, 6 months ago

  By: Gail Shaw

• Pivot Query

  Hi all, I have a table with two columns, Key & Value Key | Value ------------ Key1 | Value1 K…

  kunal.desai 7690

  7 replies

  13 years, 6 months ago

  By: Jeff Moden

• how to add a column that contains the max value of the group from another column

  The PROJECT_LEVEL column should return the MAX DASHBOARD_STATUS_LEVEL for every MARKET_PROJECT of t…

  cnjsvision74

  2 replies

  13 years, 6 months ago

  By: MMartin1

• Is it possible to update multiple tables with a view

  i have a view that references three tables and i want to update the table when someone updates the …

  SQLTestUser

  2 replies

  13 years, 6 months ago

  By: GSquared

• combining result in stored procedure ??

  I have problem : I have to 2 select queries , which is called inside 2 separate procedures. But i h…

  sumith1andonly1

  7 replies

  13 years, 6 months ago

  By: Steven Willis

• need help with analysis services cube permissions

  Guys I need help setting up permissions for our cubes that are running on SQL 2008. I have creating…

  mstephens1754

  1 replies

  13 years, 6 months ago

  By: Robert Klimes

• cast or convert to use "sys.fn_sqlvarbasetostr()"

  Hi folks, in order to generate INSERT-Statements for a table I found the following procedure (thank…

  ralf_huster

  3 replies

  13 years, 6 months ago

  By: Sean Lange

• EAV tables Vs. SQL_VARIANT Vs XML

  this is a shunt of a thread from here. http://www.sqlservercentral.com/Forums/Topic1384989-391-2.as…

  aaron.reese

  5 replies

  13 years, 6 months ago

  By: GSquared

• SQL Server AD authentication issue through firewall

  Hi, We have a issue regarding sql sever AD authentication in our organisation. The users are in a r…

  nicolas.daneau

  2 replies

  13 years, 6 months ago

  By: nicolas.daneau