SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• why we should delete old data and what could be the chunk size for delete 2.5 million records

  Hi, I am Using sql server 2008 R2. my database size is 1 TB and 13% free space left. everyday 2.5 m…

  somadattamallick

  10 replies

  10 years ago

  By: Jeff Moden

• stored procedure parameter issue

  Please see the attachement. how to write a Stored Procedure as per the attachment to pass parameter…

  mcfarlandparkway

  2 replies

  10 years ago

  By: Alan Burstein

• Get 1st April

  Hey, I need to find a nice neat way of setting a variable to 1st April of that current 'contract ye…

  dramaqueen

  2 replies

  10 years ago

  By: dramaqueen

• SQL traces and SQL restarts

  Hello everyone. Hope you can offer some advice or guidance on this subject. Currently I am running …

  MickyD

  2 replies

  10 years ago

  By: curious_sqldba

• Trying to retrieve actual execution plan, returns null

  I am trying to retrieve actual execution plan from production for a certain stored procedure, I cop…

  SQL Guy 1

  9 replies

  10 years ago

  By: Jacob Wilkins

• sql swap dated fields

  Hello all, I have a table with 2 date columns (StartDate and EndDate). For some bizarre reason the …

  datsun

  3 replies

  10 years ago

  By: ScottPletcher

• Is is possible to set datefirst globally for a given database

  I am trying to set DATEFIRST = 1 globally for a given database. Is there a way to do this? Regards …

  rune-654994

  2 replies

  10 years ago

  By: antonela

• Best Approach for Shadowing a Database on Same Instance

  I am being asked to create a copy of one of our production databases on the same instance. This co…

  Del Lee

  1 replies

  10 years ago

  By: BLOB EATER

• Need to narrow down data from a table which matches certain pattern.

  Hi All, I have a situation where i need to pull the data from table which matches a certain String.…

  krishnamurali2489

  4 replies

  10 years ago

  By: bgrossnickle

• EXECUTE AS question

  We have an application which requires it's database to be restored to a pre-production state, as de…

  chuck.forbes

  6 replies

  10 years ago

  By: chuck.forbes

• How to use locally declared parameters in index rebuild statement

  Hi, I have a TSQL script in which I am assigning some values to locally declared parameters. The pa…

  navtec

  5 replies

  10 years ago

  By: navtec

• Database backup and restore automation

  Hi, I am part of application deployment. mostly, I used to take the database backup and restore the…

  somadattamallick

  2 replies

  10 years ago

  By: johnwalker10

• Timeouts in SQL Server 2008 r2 Clustered Environment

  Hi Team, Please take 1 or 2 mins to read out the below. Sorry for long explanation!. > We migrat…

  GonnaCatchIT

  9 replies

  10 years ago

  By: GonnaCatchIT

• deleting dynamic records from database

  I have a requirement to delete dynamic records from the database. May i know what is the meaning of…

  mcfarlandparkway

  1 replies

  10 years ago

  By: matak

• The mystery of transaction logs

  Hi guys , I notice my transaction log grew bigger starting from last week . I checked the log backu…

  WhiteLotus

  4 replies

  10 years ago

  By: WhiteLotus