SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Update Statement Based on some date Value '00000000'

  Hi All, I have requirement is like Do not update the cloumn, if the Date is NULL value or BLANK/EMP…

  Saintmount.Sql

  3 replies

  14 years, 7 months ago

  By: Saintmount.Sql

• Linked sever error

  I have created a linked sever and when i am trying to executing command I got the following message…

  bala2

  4 replies

  14 years, 7 months ago

  By: chris.mcgowan

• Create table in other database

  When I create a table in SQL Server Management Studio, it always gets created in the master databas…

  tmccar

  11 replies

  14 years, 7 months ago

  By: Welsh Corgi

• Does ORDER BY clause matters if we have also used a TOP clause in query?

  For ex, I have a table employee with empid,name and salary as column and I ccreate a clustered inde…

  kirti.malukani

  8 replies

  14 years, 7 months ago

  By: Gail Shaw

• Misaligned disks but the disk is dynamic with 2 partitions.

  I have a dynamic disk (4.5TB) in size which is SAN attached with 9 disks (RAID 5). It is being repo…

  robster

  9 replies

  14 years, 7 months ago

  By: Perry Whittle

• SQL Server Job Agent asynchronous?

  Hi, I wanted to schedule a Job using SQL Server Job Agent to run every minute. This job will then c…

  elogen

  1 replies

  14 years, 7 months ago

  By: Welsh Corgi

• Why an index isn't being used

  Hi, As I'm new to SQL Server with Oracle background, I've been trying to understand how to optimize…

  ahmed_b72

  7 replies

  14 years, 7 months ago

  By: ahmed_b72

• SQL Server 2008 R2 developer edition question

  OK, so now I have got my book on 70-433 and if/when I take the exam this will be my first formal st…

  meridius10

  11 replies

  14 years, 7 months ago

  By: meridius10

• Denali

  I'd love to hear reasoning for answers. I am strongly considering going for Reporting Services data…

  checkai

  3 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• A simple query to list all running SQL jobs.

  EXEC MSDB.DBO.SP_GET_COMPOSITE_JOB_INFO NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL Assumpti…

  Mehernosh

  1 replies

  14 years, 7 months ago

  By: Ignacio A. Salom Rangel

• Dynamically compary 2 tables using EXCEPT and INFORMATION_SCHEMA

  Hi, I'm trying to find a way to pass 2 database names into a procedure that will automatically comp…

  ss1011

  5 replies

  14 years, 7 months ago

  By: ss1011

• Database/table size grows enormously

  Good day I have a database with some 40 tables and few of them have Full Text Search (FTS) enabled …

  kazim.raza

  4 replies

  14 years, 7 months ago

  By: kazim.raza

• Query optimization

  There is a table with some 25 lakhs of record. It has already 8 statistics. During the query analys…

  vijayakumarn

  6 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Regarding MDW Database in sql 2008

  Hi I want to know. In a single MDW Database: How many instances can be added to collect the data?

  aryan_naw

  1 replies

  14 years, 7 months ago

  By: chris.mcgowan

• Replication Error

  Hi All, I am getting the following error on the Replication monitor, can anyone help? ---- Error me…

  kgkamau

  4 replies

  14 years, 7 months ago

  By: kgkamau