SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• jalq - just another licencing question

  Hi SQL Server Pros, I recently asked myself if it is allowed with a per core licence to install the…

  Query Shepherd

  3 replies

  11 years, 1 months ago

  By: Query Shepherd

• Moving DB Data\Log Files with minimal downtime

  Hi I've been tasked with trying to figure out a method to move a database from it's current unstabl…

  wak_no1

  2 replies

  11 years, 1 months ago

  By: wak_no1

• Database design of more years

  Hello, I have question about dividing of databases. Old supplier created separate database for each…

  tony28

  4 replies

  11 years, 1 months ago

  By: tony28

• Backup issue

  Hi All, I have an issue with my database backup ... so when check using sp_who2 'active' it shows :…

  WhiteLotus

  3 replies

  11 years, 1 months ago

  By: WhiteLotus

• CASE statement in where clause

  Hi, I have the following query and want to use case statement in where clause as per below. Can any…

  thundersplash845

  2 replies

  11 years, 1 months ago

  By: thundersplash845

• Restoring the database with sensitive data to Non-Prod env

  Hi, When the database have sensitive data in the prod. How do you restore into non-prod environment…

  ramana3327

  4 replies

  11 years, 1 months ago

  By: Matt Miller (4)

• Need some help with the error.

  I received this error at 3:10 AM last night "Dispatch : Timeout during data retrieval due to busy s…

  LearningDBA

  1 replies

  11 years, 1 months ago

  By: Jeff Moden

• Varchar(MAX) column as included column in an index

  Hi All, I was wondering what exactly is stored in the leaf level of a non clustered index if a varc…

  Matthew Darwin

  5 replies

  11 years, 1 months ago

  By: Matthew Darwin

• audit database options change

  We ran into a rather bizarre situation. On one of our database instances somebody changed two log s…

  dweil

  1 replies

  11 years, 1 months ago

  By: spaghettidba

• Agent Start Problems

  Hi all, SQL Server 2008 r2 SP1 (Dev edition) on Windows 2008 r2. Everything was working fine. som…

  Staggerlee

  7 replies

  11 years, 1 months ago

  By: Karen Yorgy

• DB Mirroring Alternative?

  Good Morning Everyone, Our production data is on a development server. I am looking at moving every…

  louie1487 78804

  9 replies

  11 years, 1 months ago

  By: ManicStar

• Filtered Index Issue

  Good Day, we are running an SQL Server 2008R2 database in our Production Area. In order to improve …

  lianvh 89542

  1 replies

  11 years, 1 months ago

  By: Adi Cohn-120898

• Logic behind Columnstore index

  Hello Experts, The columnstore clustered index doesn't allows any other index to be built on that t…

  er.mayankshukla

  3 replies

  11 years, 1 months ago

  By: Grant Fritchey

• Need Solution

  Hi, I need query for below problem. As per my source data, if anyone purchase within 48 hours it s…

  balu.arunkumar

  2 replies

  11 years, 1 months ago

  By: ChrisM@Work

• jobs are not disappearing

  Hi All, I am trying to disabling the jobs but the jobs iam getting this error 'Alter failed for job…

  srinu.m1988

  3 replies

  11 years, 1 months ago

  By: spaghettidba