SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Backup failed 665(The requested operation could not be completed due to a file system limitation)

  Hi, I got the backup failed with error 665. We have a scheduled weekly full backup job running thro…

  ramana3327

  1 replies

  11 years ago

  By: Grant Fritchey

• Computed Column Problem

  I have a strange problem. I have a computed column in a replicated table, the Formula is as follows…

  Tim ffitch

  2 replies

  11 years ago

  By: Tim ffitch

• Trace flag 8295?

  Hi, Does anyone have where trace flag 8295 is used for. I found it active on a customer server, SQL…

  Pieter Vanhove

  3 replies

  11 years ago

  By: julie.woolner

• ? A select top1 within a select ?

  Hi I have a query where I want to select only the top record which meets the criteria from one of t…

  jbalbo

  4 replies

  11 years ago

  By: Eirikur Eiriksson

• MS Sql server 2008R2 Upgrade Advisor confusion

  Intro: we have sql server 2008R2 cluster where few DBs are in 80 (i.e.2000) or 90 (2005) compatibil…

  Yuri55

  2 replies

  11 years ago

  By: Yuri55

• How would I be able to capture sessions who modify a table with the details modified in the table

  Hi Folks, I created am inventory table with few columns say, Servername, version, patching details,…

  SQL_Hunt

  1 replies

  11 years ago

  By: Grant Fritchey

• Query to select date range from two table with same date range

  I have 2 tables, one is table A which stores Resources Assign to work for a certain period. The str…

  derickloo

  8 replies

  11 years ago

  By: LinksUp

• Trying to add a trigger that inserts original data from 1 table to another. With getdate() appended to 2nd table.

  I am trying to create a trigger on a table. Let's call it table ABC. Table looks like this: SET ANS…

  Greg.Jackson

  10 replies

  11 years ago

  By: Luis Cazares

• Help with a SQL Query

  EmpCode..........Time...............In/Out 001----2013-10-02 06:54:00---False 001----2013-10-02 11:…

  th02b0

  5 replies

  11 years ago

  By: Sean Lange

• Management Studio consistently hangs after accessing Object Explorer

  I am having a consistent and very frustrating problem with my Management Studio -- SQL Server 2008 …

  katrina92886

  11 replies

  11 years ago

  By: davidti

• "normal" non-clustered index vs INCLUDE index

  debating this with a colleague ... which would you expect to be more efficient ? (all fields int) …

  simon_s

  19 replies

  11 years ago

  By: Grant Fritchey

• enabling RCSI.....correctly

  Hello experts !! The following is from an accidental dba perspective 🙂 To enable RCSI on a database…

  SQLJay

  5 replies

  11 years ago

  By: Perry Whittle

• Error - an expression of non-boolean type specified in a context where a condition is expected , near ','

  Hi, I am getting an error when running this query in SSRS- "an expression of non-boolean type speci…

  pwalter83

  3 replies

  11 years ago

  By: pwalter83

• Enter today's date etc

  Sometimes I want to quickly to edit a record in a table instead of using an insert statement. Somet…

  sqlfriend

  10 replies

  11 years ago

  By: Sean Lange

• msdb acronym?

  Seeking pointless trivia & failing to find it; is the acronym of msdb known? I can't recall se…

  Dird

  1 replies

  11 years ago

  By: DBA_Freddie