SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL query join between table and FOR XML output

  Hi, I'm trying to create a query which joins a table to a FOR XML generated XML. Below is greatly s…

  mark-list

  3 replies

  15 years, 5 months ago

  By: Matt Miller (4)

• Any Service Pack released for SQL Server 2008 R2?

  Hi, Could you please tell me that any Service Pack released for SQL Server 2008 R2? Thanks

  Mani-584606

  1 replies

  15 years, 5 months ago

  By: WayneS

• need a brief explanation of a question

  I was looking at a sample question for 70-432 on http://www.accelerated-ideas.com/exams/practice-ex…

  torpne

  2 replies

  15 years, 5 months ago

  By: torpkev

• Versions of execution plans

  When we execute a stored procedure, the execution plan is stored in cache. The maximum number of ve…

  SQL ORACLE

  2 replies

  15 years, 5 months ago

  By: Gail Shaw

• Problem using IF EXISTS in a stored procedure

  Hi, I am having a problem using IF EXISTS in a stored procedure. Within an IF EXISTS construct, I …

  Dave Conover

  9 replies

  15 years, 5 months ago

  By: Dave Conover

• stored procedure and parameter

  the following is my sp. i have a parameter @company i want the data retrieved based upon the @comp…

  sharonmtowler

  3 replies

  15 years, 5 months ago

  By: Ben Teraberry

• Defaulting to a different database

  Hey all, At a bit of a loss here ... I'm part of an NT group that has sysadmin to this 2008 instanc…

  Adam Bean

  14 replies

  15 years, 5 months ago

  By: Adam Bean

• SQL Job Alerts

  I have multiple instances with jobs that do not contain Notifications when the jobs fail. I am loo…

  Robert Myers

  3 replies

  15 years, 5 months ago

  By: Robert Myers

• inserting data into composite primary key

  Table vendor vendorid(primarykey) vendorname 1 target 2 med 3 mdi 4 cashwise 5 walmart Table client…

  T2512

  4 replies

  15 years, 5 months ago

  By: chandrakala.shetty

• string of data needs to be parsed to seperate columns

  i have a string of data that looks like this, there is no set position for where the next value wil…

  sharonmtowler

  11 replies

  15 years, 5 months ago

  By: Lynn Pettis

• Filter suppliers that dindn't sell

  I have the following query: SELECT fc.no, fc.nome, 'FANO1' = SUM(Case When year(datalc)=2010 Th…

  pnomadewolf

  2 replies

  15 years, 5 months ago

  By: Dan.Humphries

• Max size of an index

  I was asked this question and I'm embarrassed to say I didn't know the answer. I know that an inde…

  Chris Gierlack

  2 replies

  15 years, 5 months ago

  By: Chris Gierlack

• Is the MSDTC security seetings to be enabled for every SQL Sevrer box?

  Hi, I have Installed SQL Server 2008 SP1 on Windows 2008 R2 Server and this SQL instance going to h…

  Mani-584606

  1 replies

  15 years, 5 months ago

  By: Mani-584606

• block dba access to user data

  Is there a way in sql 2008 to block a dba's access to user data? I think the capability exists. how…

  sqlstar2011

  3 replies

  15 years, 5 months ago

  By: jeff.mason

• Strange Index Fragmentation

  Anybody having good experience with Idera? Thx.

  logixmike

  7 replies

  15 years, 5 months ago

  By: DBA Masters2010