SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SELECT INTO and VARBINARY(max)

  Hello everyone, I am working with some legacy code for my client. They have a table, let's call it…

  jordantx

  2 replies

  12 years ago

  By: jordantx

• CASE usage

  select 'test message' + case when a=0 then 'message 1' when a<>0 then 'message 2' else 'XXXXX…

  balasach82

  4 replies

  12 years ago

  By: Eric M Russell

• Sum records by customer number into 1 row.

  Good morning everyone. I have the following temp file that contains the following rows. And I ne…

  Gillian_Pappas2002

  2 replies

  12 years ago

  By: Gillian_Pappas2002

• SSIS Script Text

  Hi everyone - hope someone can help. I want to create a script task in SSIS that will export 3 tabl…

  ByronOne

  7 replies

  12 years ago

  By: ByronOne

• SSRS report question

  Sorry for the very generic title, I just couldn't figure out what to put as a title. So here's my d…

  sethosla

  3 replies

  12 years ago

  By: pshields

• Management Studio Intellisense not working

  When writing my queries in SQL Managament Studio 2008R2, the columns from the table i am querying a…

  tstagliano

  14 replies

  12 years ago

  By: MyDoggieJessie

• Linked Server.

  Hi I need to configure linked server on SQL Server 2008. I have some users with read only rights, a…

  Sushant Yadav

  3 replies

  12 years ago

  By: Lowell

• Job interview question (DBA/Developer)

  Hello, I have an interview in a few days for a SQL Developer/DBA. They say the role is 70-30 (30 fo…

  DaveDB

  15 replies

  12 years ago

  By: Stuart Davies

• Unable to clear lock on ERRORLOG file in SQL Server to cycle error log

  Hello, Currently I'm having an issue with cycling the error log on two SQL Server Instances because…

  dancampoy

  2 replies

  12 years ago

  By: SQLRNNR

• Problem setting up snapshot replication

  I have tried to set up snapshot replication using SQL Server 2008 with the Publisher, Distributor a…

  Stefaans

  4 replies

  12 years ago

  By: yocki

• Invalid Cursor Position - No Cursor in Use...

  Hi everybody- Long time lurker, first time poster. Please let me know if I'm not in the right plac…

  pixeldude

  6 replies

  12 years ago

  By: Jeff Moden

• DBCC CHECKIDENT RESEED is very slow?

  Hi guys, Has anyone come across a DBCC CHECKIDENT RESEED being very slow? We've reached the INTs 2.…

  Dird

  5 replies

  12 years ago

  By: Dird

• Baseline MAXDOP - CTP

  I remember there was an article here sometime back on how to baseline/identify appropriate MAXDOP a…

  curious_sqldba

  3 replies

  12 years ago

  By: Igor Micev

• Reports are very slow and fast?

  Hi, Application side some times all the reports disaply very fast with in 2 seconds, and same repor…

  SQL Galaxy

  7 replies

  12 years ago

  By: mikeg317X

• Error on sys.databases log_reuse_wait_desc column

  we're seeing the following error on QA.. any ideas what the issue could be? Attach is a screenshot …

  LearningDBA

  5 replies

  12 years ago

  By: SQLBuddy123