SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Add new calendar columns (January to December) to the existing query

  Hi, I have a requirement to add new calendar columns from Jan to Dec in an existing SSRS report bas…

  pwalter83

  3 replies

  11 years ago

  By: djj

• Efficient way to delete historical data

  I've been asked to help with an issue one of our factories is experiencing. They have a machine whi…

  Maddave

  28 replies

  11 years ago

  By: P Jones

• Not throwing proper error.

  HI Experts I have written a custom script to rebuild index. But if users choose wrong choice, it is…

  SQL_Hunt

  4 replies

  11 years ago

  By: SQL_Hunt

• Stored procedure taking longer in Prod

  Hello All, I have one stored procedure being called by the job that runs everyday. It generally tak…

  Walton

  9 replies

  11 years ago

  By: Grant Fritchey

• ?? Cross Apply error...

  Hi I'm trying to view two different parts of an XML field and getting the error: The correlation na…

  jbalbo

  2 replies

  11 years ago

  By: Alan Burstein

• SQL authentication account with read-write access to only 1 table

  How can I create a SQL authentication account with read-write access to only 1 table in a SQL datab…

  mtz676

  1 replies

  11 years ago

  By: Lowell

• Update / Insert statement

  Say I have the following SQL Statement IF(@Activities IS NOT NULL) Begin EXEC('INSERT INTO …

  .Netter

  10 replies

  11 years ago

  By: below86

• Incorrect Syntax error. But the generated query is good

  DECLARE @sql NVARCHAR(1024) DECLARE @DB VARCHAR(500) DECLARE DatabaseCursor CURSOR FOR SELECT name…

  SQL_Hunt

  9 replies

  11 years ago

  By: SQL_Hunt

• SQL Server 2008 Licensing

  First of all, I apologies if this has already been answered in other forum posts but I have searche…

  g.mclachlan

  2 replies

  11 years ago

  By: g.mclachlan

• Are LSNs recycled

  Hi all, I want to build a table I can archive off old CDC records to. The key on the change table i…

  Xedni

  4 replies

  11 years ago

  By: Gail Shaw

• DBCC CHECKDB - SCript Review and suggestions

  Hi Guys I have written a script to do dbcc checkdb agaianst all my database. Interesting part is: 1…

  SQL_Hunt

  3 replies

  11 years ago

  By: Gail Shaw

• Under hood method of receiving Alert notifications for SQL Express

  Hi, I've been looking at using a method of alerting for a SQL Express Instance. I appreciate you ca…

  simon.letts

  2 replies

  11 years ago

  By: simon.letts

• insert update from snapshot and select from readcommited is deadlocking

  hi, please correct me i am inserting updating few tabels from snapshot and reading same bunch of ta…

  rajemessage 14195

  4 replies

  11 years ago

  By: seregak76@mail.ru

• Want to add databasename in the results.

  Guys I written a proc to display the list of Indexes But I needed to print the database where the o…

  SQL_Hunt

  2 replies

  11 years ago

  By: SQL_Hunt

• Where IN () Clause

  Hi, I have a SQL statement that is running against a VERY large table that has an index on the "fme…

  rob_panosh

  5 replies

  11 years ago

  By: ScottPletcher