SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Snapshotting mirrored databases

  Hi all I'd like some advice (and I can't find anything on Google) before I attempt this one. First …

  richardmgreen1

  2 replies

  11 years, 5 months ago

  By: richardmgreen1

• Adding version to row to ensure user updates the current row version

  Hi! I'm having the problem described in the following example: Table Samples: SampleID | Color …

  amns

  8 replies

  11 years, 5 months ago

  By: Jack Corbett

• Simple question: How many users are connected to the sql server (instance)?

  Hi all, I can't find perfect answer for this question: Can you check how many users are connected t…

  Tac11

  8 replies

  11 years, 5 months ago

  By: Tac11

• Update based on multiple conditions in a single pass?

  Hi, I have the following issue which I'm trying to resolve: essentially, I have a table of measurem…

  bleroy

  2 replies

  11 years, 5 months ago

  By: djj

• Exporting SQL Jobs history

  Hi, I know how to export a SQL Server job's history to a file by clicking on the Export button insi…

  navtec

  4 replies

  11 years, 5 months ago

  By: navtec

• Generate script to restore log backups

  Hi, I have more than 2000 log backup files in Z:\Backups\t-logs folder to restore after restoring t…

  Mani-584606

  19 replies

  11 years, 5 months ago

  By: Jeff Moden

• What would your answer be for this question?

  I have come across a question on of the job interviews, i have already answered the question but wa…

  curious_sqldba

  4 replies

  11 years, 5 months ago

  By: Jeff Moden

• Set datime and convert it

  Hi I have this query: declare @ToDate datetime declare @FromDate datetime set @FromDate = ? set @…

  hoseam

  15 replies

  11 years, 5 months ago

  By: ScottPletcher

• any way to reindex gigantic table efficiently?

  so I have a time series table consisting of 3 columns: a key, a timestamp and a value. The primary…

  cmoy

  3 replies

  11 years, 5 months ago

  By: ScottPletcher

• Search File with Widecard

  I need some help in coding for a script task for a SSIS package. I have a folder called TestFile i…

  QQ-485619

  3 replies

  11 years, 5 months ago

  By: Jack Corbett

• Search f

  I need some help in coding for a script task for a SSIS package. I have a folder called TestFile i…

  QQ-485619

  1 replies

  11 years, 5 months ago

  By: Jack Corbett

• Table Partiotion on Datetime column - nonclusterd index

  Hi Team, i have a table with below columns. S_id (int) S_Name (varchar) S_DOB (Datetime) S_City (va…

  Minnu

  8 replies

  11 years, 5 months ago

  By: Jeff Moden

• Redgate SQL Data compare

  Hi everyone - is there a way in SQL DataCompare 10 to set the working drive to something other th…

  kevin.ellis 76938

  3 replies

  11 years, 5 months ago

  By: kevin.ellis 76938

• Very Very Complex Query based on Dates

  CREATE Table #tempID ( ID int NOT NULL ) CREATE Table #tempreadings ( ID int NOT NULL , Value float…

  ramrajan

  12 replies

  11 years, 5 months ago

  By: ChrisM@Work

• not sure why DBCC CHECKDB is running

  Hi, I have no maintenance plans scheduled to run.. but I can see dbcc check running on all my users…

  Edward-445599

  4 replies

  11 years, 5 months ago

  By: Ant-Green