SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• TO manage mutiple connections

  Is there a way, I can use a Global TAG (connection STRING) to refer to DB objects? For example: SER…

  Joe-420121

  6 replies

  14 years ago

  By: Joe-420121

• Log backups during reindexing.

  Hello, I was just wondering if a T-log backup would interfere if it happened during reindexing job?…

  Duran

  2 replies

  14 years ago

  By: Duran

• Need some clarification on execution plan

  Hi, I have created one index in address table in adventureworks database just for testing. CREATE N…

  Ryan007

  4 replies

  14 years ago

  By: Grant Fritchey

• How to Tune Performane of Stored Procedure

  hi, how to tune the performance of a stored procedure.

  Diyas

  4 replies

  14 years ago

  By: Grant Fritchey

• Advice needed with table update has poor performance because of view

  Hi all, we have a situation where we update a table which is used in two views. Both views uses a t…

  perry-570145

  2 replies

  14 years ago

  By: Gail Shaw

• Cancelling a DB thats restoring

  Hi all What happens to a DB if you cancelled the restore for a DB thats been set to overwrite exist…

  Kwisatz78

  2 replies

  14 years ago

  By: Gail Shaw

• restore database is ok?

  Dear Friends, when i restore a Database backup,how can check restored Database is OK? before that a…

  zsafakhah

  6 replies

  14 years ago

  By: derek.colley

• FullText Search Indexing

  Hello! I have a table create table FY_Objects ( ID bigint identity primary key, CategoryI…

  burtsev

  2 replies

  14 years ago

  By: burtsev

• ascending numbers

  I have a table having bigint stored in it. CREATE TABLE #Number(Num BIGINT) GO INSERT INTO #Number(…

  Confusing Queries

  22 replies

  14 years ago

  By: Cadavre

• How to restore non-system stored procedure from 2000 Master database to 2000R2 Master database

  Hello everyone, I am working to upgrade SQLServer 2000 to SQLServer 2008R2. For this, I have create…

  B Raj Dhakal

  3 replies

  14 years ago

  By: DBA328

• 3 bit counter

  hello all. I need to 3 bit counter with T-Sql that give this result: 000 001 010 011 100 101 110 ..…

  elham_azizi_62

  2 replies

  14 years ago

  By: Paul White

• How to Select Row to Column

  SELECT A1.TotalAmount * 20 / 100 AS TutionFees ,A1.TotalAmount * 20 / 100 AS CorpusFund ,A1.T…

  tamil.selvanmca

  1 replies

  14 years ago

  By: vinu512

• Database Mail - Error

  The mail could not be sent to the recipients because of the mail server failure. (Sending Mail usin…

  SQListic

  2 replies

  14 years ago

  By: saidapurs

• SSRS 2008R2 reports not rendering correctly in scheduled emails sent to iPhones and iPads

  I recently upgraded a reporting server from 2005 to 2008R2 and immediately ran into some problems w…

  sherrerk

  3 replies

  14 years ago

  By: andrew.young-739982

• MDF File size not growing

  Hi I am using SSMA to load data from oracle to sql server, i noticed that mdf file size is not grow…

  SQListic

  1 replies

  14 years ago

  By: MysteryJimbo