SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Multiple execution plan for 1 query.

  I have this SQL statement with 2 different execution plan. I am also attaching both execution plan.…

  LearningDBA

  3 replies

  11 years, 2 months ago

  By: ChrisM@Work

• Removing a Server name from MS SQL Server Management Studio 2008 'Connect to Server' Drop-down list

  Good morning. In MS SQL Server Management Studio (2008), is there a way to remove unused entries fr…

  CherylNH

  13 replies

  11 years, 2 months ago

  By: -Adam

• Error Message on the application server

  This is how the error message on the application server looks like, but the sql server error log do…

  Srl832

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Table Type and OpenRowSet

  I'm trying to store the output of my stored procedure into a temp table, which takes Table Type as …

  sarath.tata

  5 replies

  11 years, 2 months ago

  By: sarath.tata

• Backup to device, UNC file, generates OS error

  Hi friends, family and fellow SQL dba's I have a bit of a bother, and it's OS / SQL related. I back…

  Alocyte

  13 replies

  11 years, 2 months ago

  By: v.sierra

• ?? on linking two table to one ??

  Hi This may sound basic, but here is my problem I have table1(Client widgets) and Table2(Client Toy…

  jbalbo

  2 replies

  11 years, 2 months ago

  By: Nevyn

• Using SQL Trace, Query DMVs or Extended Events

  I have a 2008R2 box that is randomly having a performance problem between certain times of the day.…

  lmarkum

  3 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Dicussion about index

  Hey Guys, I am working in sqlserver 2008 R2 I have an interesting question. My question is does ind…

  KGJ-Dev

  16 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Do we need to recompile the stored procedure after a table alter

  Version 2008 R2 The stored procedure has the dependency on the table that was altered.

  Guras

  4 replies

  11 years, 2 months ago

  By: Guras

• Creating a snapshot/transactional table by appending

  Hi everyone, I am very new to SQL coming from a SAS background. I work at a College where I am tryi…

  FromSAStoSQL

  4 replies

  11 years, 2 months ago

  By: FromSAStoSQL

• transaction log growth

  I received alerts from a couple of the production servers last night stating that the log file is r…

  Srl832

  10 replies

  11 years, 2 months ago

  By: Super Cat

• deployment of sql server 2008

  hi all, i am an oracle dba but recently my manager gave me about 100 excel files which have lakhs o…

  Tejesh

  3 replies

  11 years, 2 months ago

  By: lmarkum

• T-sql script

  Is there any task we can use in the maintenance plan before the backup to move the old backups to d…

  ramana3327

  5 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Change primary key nonclustered to primary key clustered

  Hi everyone, We have a table, which has one clustered index and one non clustered index(primary key…

  Aspet Golestanian Namagerdi

  2 replies

  11 years, 2 months ago

  By: ScottPletcher

• Question on PIVOT

  I have output like this Name Type Value Sarath Age 33 Sarath Id 333 Mahesh …

  sarath.tata

  8 replies

  11 years, 2 months ago

  By: Nevyn