SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How much RAM does 2008 used ?

  I was told that SQLSever 2008 only uses 34GIGS of RAM ( We have 64 GIGS ) ? Is this true ? If so …

  mw_sql_developer

  4 replies

  10 years, 7 months ago

  By: SQLRNNR

• Update clause

  Would this update statement work? both the SET & WHERE have the same columns: Update Table S_O…

  SQLPain

  4 replies

  10 years, 7 months ago

  By: Kristen-173977

• After cancelling SQL job database stuck in restoring state

  Hi I was doing restore operation and i cancelled SQL agent job in middle now my DB is stuck in Rest…

  SQlLogic

  14 replies

  10 years, 7 months ago

  By: Michael G

• Frequency of Table Update in ETL environment

  I have a new production server with about 100 jobs on it. These are ETL jobs about half of which ar…

  Johnny B

  5 replies

  10 years, 7 months ago

  By: Johnny B

• SOmething weird with SQL patching

  Hi all , I just did SQL patching ( Service pack 3) to my testing server and it turns out that only …

  WhiteLotus

  4 replies

  10 years, 7 months ago

  By: Jeff Moden

• Conversion failed when converting the varchar value - Error

  Hi, I am getting the following message when trying to run the below sql Msg 245, Level 16, State 1,…

  SQL_Kills

  11 replies

  10 years, 7 months ago

  By: Ed Wagner

• Calling Netbackup from SQL Job

  Hi there, I am trying to initiate a Netbackup task from a SQL Job using the following CmdExec code:…

  mg_dba

  6 replies

  10 years, 7 months ago

  By: alanspeckman

• Increment values in SQL server

  Hi there, I have to increment sequencial values for the following: Current Data Col1 Col2…

  eric-silva

  2 replies

  10 years, 7 months ago

  By: Sean Lange

• Generate Invoice Document from SQL

  Really need some help on this one - i need to generate documents for customers to sign automaticall…

  andyc209

  11 replies

  10 years, 7 months ago

  By: John Rowan

• How to resolve SQL Client Timeouts?

  Hello, I am a .NET programmer who also works with SQL 2008 R2 Server. Sometimes I get Client timeo…

  tom.sage 70179

  7 replies

  10 years, 7 months ago

  By: Eric M Russell

• Cluster Index Key value

  Hi all, I have a table which has cluster index on col1 column. If i insert 10 into my table what wo…

  Barcelona10

  5 replies

  10 years, 7 months ago

  By: Barcelona10

• Executing query/SPs thru Command line

  Hi experts, How do I execute below scripts using CMD: Please Note: SQL server 2008r2, default insta…

  Tac11

  12 replies

  10 years, 7 months ago

  By: Lowell

• rebuild index worsens query performance

  we have a query which runs several times a day reads from several tables in one database ("W"), and…

  jgenovese

  56 replies

  10 years, 7 months ago

  By: nancy.gs.chuah

• ? Records that don't match from two db's...

  Hi I am using the following views from two db's to find records that don't match. My question is ca…

  jbalbo

  5 replies

  10 years, 7 months ago

  By: Eric M Russell

• USER DEFINED DATA TYPES: Used in table creation - What happens if you change just the user defined type to varchar(max) from text?

  Question: Table definition uses user defined types for EVERY field (yeah, I know, but it's legacy…

  sgmunson

  18 replies

  10 years, 7 months ago

  By: sgmunson