SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Resource_Semaphore wait types

  Hi All Noticed when diagnosing blocking using Spotlight, that the "type" is coming back as Resource…

  Ant-Green

  1 replies

  14 years, 5 months ago

  By: Eddie Wuerch

• 1:M - build flat view with new 2008 features

  given a fund table with many classifications, how can I build a view that shows the funds, each cla…

  gerardquinn43

  1 replies

  14 years, 5 months ago

  By: LutzM

• merging two rows

  Hello, I have a column patID with some values( with some condition 1), patID with some columns(with…

  MrReddy

  5 replies

  14 years, 5 months ago

  By: toddasd

• Backup Sql Server Express From Remote SQL Server Enterprise

  I have a SQL Server 2008 R2 Express server that I want to run a set of maintenance plans against. I…

  hkflight

  5 replies

  14 years, 5 months ago

  By: hkflight

• Grant non-sysadmin ability to view any database's users

  I have a login that I currently use to collect information on a SQL Server instance, including inst…

  Colleen M. Morrow

  3 replies

  14 years, 5 months ago

  By: Elliott Whitlow

• Service pack for SQL 2008 Express Edition

  Can SQL 2008 SP3 be applied on SQL 2008 Express edition? Is there instuction?

  tyang

  3 replies

  14 years, 5 months ago

  By: Revenant

• getting error when trying to edit existing sql server job

  I've created a SQL Server Agent Job. Now I'm trying to edit the existing job. However, when I go …

  sqlguy-736318

  1 replies

  14 years, 5 months ago

  By: SQLRNNR

• conversion error

  Hello, I have a column with datatype varchar ,some columns are like 19,345.00,123.78,23.00,123,234,…

  MrReddy

  4 replies

  14 years, 5 months ago

  By: MrReddy

• Update statement for when a specific field changes

  I have written an update trigger for when the costprice is inserted or updated. The issue I am havi…

  kyle.doouss

  19 replies

  14 years, 5 months ago

  By: tfifield

• IFF statemant question

  Could someone tell me what is incorrect with the following =iif(Fields!isYO.Value=0,'not YO','YO') …

  Fastskates

  9 replies

  14 years, 5 months ago

  By: Fastskates

• Splitting out results from duplicate data

  Hi, I have a table that contains an identifier and some name/address details some of the records ha…

  rpeplow

  5 replies

  14 years, 5 months ago

  By: Sean Lange

• Why is SQL Server Agent disabled by default?

  Why is SQL Server Agent disabled by default in SQL Server? Just curious....

  sqlguy-736318

  1 replies

  14 years, 5 months ago

  By: george sibbald

• SQL 2008 R2 Ent Edition on Win 2008 R2 Ent Edition

  I have the option of hosting my DBs on the Enterprise Edition of Win 2008 R2 but I need to make a c…

  _nzrdb6

  3 replies

  14 years, 5 months ago

  By: Elliott Whitlow

• SSMS Gui Restore issue

  Hi all, I had an issue around backups today which I am very confused about.... A customer called me…

  acrutchley

  2 replies

  14 years, 5 months ago

  By: acrutchley

• Date Coding Format - Is there any benefit of using YYYYMMDD OR DD-MM-YYYY? what is most common and why preffered?

  Hi, I wonder if One could tell me the benefit of using different date format in tsql or procedure c…

  iBar

  15 replies

  14 years, 5 months ago

  By: Jared