SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Job To Delete All Records Then Copy All From Another Table

  I am using a SQL Server Agent jobs that run each morning to update the records in a table to match …

  jre1229

  4 replies

  11 years ago

  By: Lynn Pettis

• Please help. Having problem executing a dynamic sql statement over linked Server

  I have a situation that I need to add a field to a table over linked server. The specifications of …

  Jeffery Williams

  18 replies

  11 years ago

  By: Jeffery Williams

• mark a table or view in a t-sql script, and open/browse this table/view via hotkey

  Hi, is there a way to mark a table or view in a t-sql script, and open/browse this table/view via h…

  info 58414

  2 replies

  11 years ago

  By: info 58414

• Optimize memory with varchar(max) datatype

  I am building a table change log that will track each attribute update and include the original and…

  J0shu@

  12 replies

  11 years ago

  By: Er.Karthikeyan

• Creating Rows Between Dates In A Single SQL Statement

  Hi, I am trying to find an easy way to create multiple of just two date in a single sql statement. …

  lockered

  3 replies

  11 years ago

  By: lockered

• SQL Server Logical/Physical Reads!!!!

  Summary Info: Logical Reads : Reading Data pages from Cache Physical Reads : Reading Data pages fro…

  Dinesh Babu Verma

  6 replies

  11 years ago

  By: DicksonMulwa

• How do I turn this into a Stored Procedure?

  Please, no links. I have looked at many examples and websites, and I am not understanding it. DECL…

  chef423

  6 replies

  11 years ago

  By: chef423

• if inequality brings less rows and equality bring more , then can i put inequality as first col of index

  hi, "So, what does that mean for index columns order? Quite simply, if queries are always going to …

  rajemessage 14195

  3 replies

  11 years ago

  By: Eirikur Eiriksson

• Is temporary table creation and dropping logged anywhere in SQL SERVER?

  Dear Everyone I have a script which generates a temporary table and then runs a script and finally …

  hurricaneDBA

  21 replies

  11 years ago

  By: Eirikur Eiriksson

• how to perform sorting and filtering in stored procedure with performance optimization?

  Hey I am just learning to write stored procedure. This is a link to my Question which i have asked …

  maria.pithia

  6 replies

  11 years ago

  By: maria.pithia

• Log file Rotation Script

  I needed help with the log file rotation and cleanup script and how to remove the log file older th…

  sureshjevani

  4 replies

  11 years ago

  By: Gail Shaw

• Dropping a FK "online"

  Hi, I am trying to partition few tables, this requires the primary key/clustered index to be droppe…

  Roust_m

  1 replies

  11 years ago

  By: Gail Shaw

• How To Update NUll Enabled Field Without Interfering With The Rest of the INSERT/UPDATE

  If I have a table with 1 or more Nullable fields and I want to make sure that when an INSERT or UPD…

  YSLGuru

  12 replies

  11 years ago

  By: Peter.Neilson

• Alter Function - took long time ...

  Hi, I created a scalar user defined function and when I try to modify / alter the script, it just t…

  davidku

  6 replies

  11 years ago

  By: davidku

• Primary XML Index Worse Than No Index

  Hi Guys, I've been working with some tables with XML columns, and I've been playing around with ind…

  Xedni

  1 replies

  11 years ago

  By: Alan Burstein