SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• PERFORMANCE ISSUE ON SQL SERVER 2008

  Good Day, I have a performance issue where I run a query/script on different SQL server versions, …

  JALLY

  3 replies

  10 years ago

  By: JALLY

• SDLC

  Hi all, Somewhat non-technical question, I'm going for a position where 'A good knowledge of the s…

  JaybeeSQL

  1 replies

  10 years ago

  By: Nicholas Cain

• Differences between sql server 2008 and 2008 R2

  I did some research to find the differences between between sql server 2008 and 2008 R2 but couldnt…

  curious_sqldba

  19 replies

  10 years ago

  By: Gail Shaw

• Unsafe assembly

  Hi all, Recently following message appears in SQL Error log.Any ideas? 'Unsafe assembly 'microsoft.…

  Barcelona10

  2 replies

  10 years ago

  By: Barcelona10

• Comparing Data from two tables on two different servers

  I have a HQ server and Office_location server. we have a replication application that moves new/upd…

  Lee Hopkins

  3 replies

  10 years ago

  By: Grant Fritchey

• Queries and joins with different locations.

  I am trying to set up a query that will report on quantities ordered, shipped and backordered (thos…

  tshad

  5 replies

  10 years ago

  By: Grant Fritchey

• Load flat file error code -1071607689

  Hi, I have a SQL Server 2008 in Server 1 , where I have a job of loading flat file in Table. the fl…

  benkraiemchedlia

  1 replies

  10 years ago

  By: Smendle

• How to use One to many relation with sub-query

  I have created below query for SSRS with one to many relation join. Basically my logic is =>Firs…

  salman-pc

  1 replies

  10 years ago

  By: drew.allen

• Ensuring logins are not used

  There are approximately 30 logins on one of our PROD instances of SQL Server that I believe are unu…

  Clint-525719

  2 replies

  10 years ago

  By: Eric M Russell

• Timeout for insert (table with full text search)

  Hi I have a table with 11 G data space and 25,000,000 records.3 fields are configured for full te…

  mah_j

  7 replies

  10 years ago

  By: Sergiy

• Sum Time in Sql

  I am trying to sum up time and almost did it. Now I would like to sum up top 2 time as follows: SE…

  AT-2016

  9 replies

  10 years ago

  By: Sergiy

• Get Table Data - Historical Table

  I've the following table: department - student - start_date - end_date 1 102 …

  AT-2016

  2 replies

  10 years ago

  By: AT-2016

• Load data using SSIS

  Hi friends, We need to develop a SSIS package to load data from ftp site onto SQL Server tables. …

  newbieuser

  6 replies

  10 years ago

  By: MMartin1

• How to get list of all tables/index that are not compressed for all Databases in an instance

  How to find out which big tables and indexes are not compressed. Is there a standard report for thi…

  SQLisAwe5oMe

  3 replies

  10 years ago

  By: SQLisAwe5oMe

• PLE is too high (larger than uptime...)

  Hi, Server has been restart this morning, i got [font="System"]object_nameSQLServer:Buffer Manager…

  az-sqlsc

  6 replies

  10 years ago

  By: az-sqlsc