SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Send E-mail Notification For Agent Job

  Hi, I've created a Database Mail account (tested and sends with no problem), created an operator, s…

  guerillaunit

  7 replies

  13 years, 9 months ago

  By: sestell1

• SQL Server 2008R2 using more memory

  Hi Experts, got a request from systems team that in one of our prod system sql server using 7.25GB …

  SQListic

  5 replies

  13 years, 9 months ago

  By: Jared

• Look up duplicates

  I have a table of customer names and ids, and I want to identify the duplicate names in a new table…

  tmccar

  15 replies

  13 years, 9 months ago

  By: Luis Cazares

• stored procedure - Command(s) completed successfully.

  set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -----------------------------------------------------…

  abk365

  4 replies

  13 years, 9 months ago

  By: Sean Lange

• NonClustered index on Clustered table

  Hi All, Today i got a very basic doubt when i am doing some R&D on Indexes. Clustered: Will st…

  SQL*

  3 replies

  13 years, 9 months ago

  By: Jared

• upgraded SSIS 2005 to 2008, FTPWebRequest isssues

  I am trying to port our code to 2008 but I am having this FTP issue. The FTP connection keeps comin…

  Tobar

  1 replies

  13 years, 9 months ago

  By: Tobar

• Reducing Log File Size from 50GB

  I have a database that is currently using 50GB, 25GB DB, 25GB log file. The DB is set to simple mod…

  Rob Reid-246754

  9 replies

  13 years, 9 months ago

  By: Gail Shaw

• Selecting immediate parent data if child is not available

  ParentChildMapping ChildID ParentID 1 0 2 1 3 1 4 2 5 …

  OMG! its sql

  3 replies

  13 years, 9 months ago

  By: Mark Cowne

• NonClustered index vs Unique NonClustered Index

  Hi All, What is the main difference between Nonclustered index and unique nonclustered index with r…

  SQL*

  11 replies

  13 years, 9 months ago

  By: Gail Shaw

• How to achive accidental restortion in Mirroring

  Sorry! It is accentaly added. How to remove it Ram MSSQL DBA

  Ramdas

  3 replies

  13 years, 9 months ago

  By: Ramdas

• general topic

  can any one say about the difference between full vs differential ve log backups

  ramyours2003

  1 replies

  13 years, 9 months ago

  By: MysteryJimbo

• Merging the Row(s) and Column(s) into single field

  Hi, I'm trying to merge rows and columns into a single field based upon the weekday. Please refer t…

  S-322532

  3 replies

  13 years, 9 months ago

  By: Koen Verbeeck

• SSIS Data Flow Task Error

  [PRODUCTION [1]] Error: There was an error with output column "vdescending" (2273) on output "OLE D…

  SQListic

  2 replies

  13 years, 9 months ago

  By: Koen Verbeeck

• Index Rebuild Vs Reorganize...?

  HI Guys .. Just wanted to know how often should do Rebuild Index and Reorganize Index in week or …

  SQlLogic

  4 replies

  13 years, 9 months ago

  By: mikehillwig

• Index Maintenance plan succeeded but SQL Agent job history shows fail..

  HI guys, i am working with weird situation. I did setup Maintenance plan for Index Reorganize an…

  SQlLogic

  1 replies

  13 years, 9 months ago

  By: mikehillwig