SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Cursor or special select statement?

  I have a table that holds all my Customers with details such as Cust#,name, address, city, Delivery…

  Hyabusact

  4 replies

  10 years, 4 months ago

  By: Jeff Moden

• SQL Server disconnects my SQL users when Inactive !

  My friends , I found an unusual problem with my software in last days , About two weeks before one …

  abhari_batis

  3 replies

  10 years, 4 months ago

  By: PhilPacha

• Query on drop and create Index

  Hi Team, We have a table which has abt 30Lakh records, we insert abt 1 lakh record every day and up…

  GonnaCatchIT

  4 replies

  10 years, 4 months ago

  By: Gail Shaw

• How to reduce Huge Log File size

  HI All , I have an issue with my database LOG file which is very big now ( 299 GB ) for 1 database …

  WhiteLotus

  25 replies

  10 years, 4 months ago

  By: ScottPletcher

• Error encountered during creation of databases: CREATE FILE encountered operating system error 5(Access is denied.)

  Error messages: CREATE FILE encountered operating system error 5(Access is denied.) while attemptin…

  sqlnickxu

  23 replies

  10 years, 4 months ago

  By: russ.johnson

• How to find duplicate sets of record?

  Here is my scenario (I signifficantly simplified from real problem). I have a table with following…

  SQL Guy 1

  4 replies

  10 years, 4 months ago

  By: Eirikur Eiriksson

• Help with trigger implementation

  I have two databases, DB_MAIN and DB_FRONT. Both have a similar table setup: CREATE TABLE dbo.tbl_…

  pmb88

  3 replies

  10 years, 4 months ago

  By: pmb88

• Trigger doesnot update last record

  CREATE TRIGGER ToUpdateForABC ON tbl1 AFTER INSERT AS update tbl1 set ConpositeName = 1 where Stat…

  shogunSQL

  2 replies

  10 years, 4 months ago

  By: shogunSQL

• How to convert DOB to age using DateDiff function

  Hi There, I am trying to find list of members within the ages of 13-17 in a particular dept. I quer…

  SQLisAwe5oMe

  12 replies

  10 years, 4 months ago

  By: Sureindran Nadesan

• How to add record on linked server

  I tried to add a new record on the linked server but it fail. The Errror is Column Name or number o…

  chris92mars

  2 replies

  10 years, 4 months ago

  By: Ed Wagner

• Send email through sp_send_dbmail - dynamic sql - different results everytime

  Hi, I have a stored procedure which runs dynamic sql and sends results out in an email format. I ha…

  sandesh_krishnan

  2 replies

  10 years, 4 months ago

  By: sandesh_krishnan

• package hangs when using transactionOption Required

  I'm trying to implement a transaction on a package in SS 2008R2 , but the package hangs on the firs…

  dudus

  13 replies

  10 years, 4 months ago

  By: dudus

• Partitioned index on partitioned table

  I have a partitioned table with a partitioned index: CREATE TABLE MyTable ( PartitionID int not nul…

  N_Muller

  3 replies

  10 years, 4 months ago

  By: Jeff Moden

• Space occupied by each Transaction in Log

  Hi, is there a way to find space occupied by each transaction in tran log. CDC is holding up the lo…

  rao_dinesh

  1 replies

  10 years, 4 months ago

  By: JeremyE

• Need help using Database Engine Tuning Advisor

  Hi, I've some list of SQL Server Profiler - trace data file as follow I knew, how to Add - 1 Trace…

  Qira

  2 replies

  10 years, 4 months ago

  By: MadAdmin