SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How Combine two separate IF statements into One IF

  IF EXISTS (SELECT 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'r' and COLUMN_NAME = y ) IF…

  MVIT

  3 replies

  13 years, 10 months ago

  By: Gazareth

• New Instance Shared Features Upgrade

  I'm about to install a new instance which will be a newer version build than the default instance, …

  Bobby Glover

  1 replies

  13 years, 10 months ago

  By: Bobby Glover

• Is it possible to create index on computed column ??

  Hi, Basically, I am getting just the year part of the datetime column and converted into varchar as…

  Ajdba

  14 replies

  13 years, 10 months ago

  By: Eric M Russell

• Deadlock on KEY Lock when attempting to run Delete statements concurrently

  Hi all, I would really appreciate some help with this one. It has got me stumped. Basically Im ru…

  matt 87379

  1 replies

  13 years, 10 months ago

  By: matt 87379

• Why only final row set to variable on CASE select?

  I have the following query on SQL 2008 which runs two select statements: DECLARE @result varchar(5…

  neil-560592

  7 replies

  13 years, 10 months ago

  By: neil-560592

• Create a dataset based on the result of another dataset?

  I am working .Net program. Is it possible to create a dataset based on the result of another datase…

  adonetok

  1 replies

  13 years, 10 months ago

  By: Luis Cazares

• trigger

  I have three tables one called PONumber which has PONumber and Subtotal another table called Purcha…

  edward_hall76

  23 replies

  13 years, 10 months ago

  By: Sean Lange

• Encoding Issues

  Hi all, I'm importing data into DB from xml file. When parsing completes some data in DB have � sym…

  anush_tar

  3 replies

  13 years, 10 months ago

  By: rhythmk

• Sql Query

  Hi All, In My Table A , Eid 101 having status all are "cp" then i need latest Edate, but in case 10…

  narendra.babu57

  3 replies

  13 years, 10 months ago

  By: Divine Flame

• Duplicate record check

  Hi Friends, i have record in xml like <root> <row spareid='10' sparename='abcd' /> <…

  s.khann786

  1 replies

  13 years, 10 months ago

  By: kiril.lazarov.77

• Detecting SQL Logins that have been unused for X amount of days?

  Hi all, I'm trying my best to look after a SQL Server 2008 instance, relatively new to all that sor…

  PMD2012

  12 replies

  13 years, 10 months ago

  By: PMD2012

• A bigger SQL Server, or a second SQL Server?

  Hi, We have SQL Server 2008 R2 Web Edition. Our company is growing, so the capacity of our SQL is r…

  Raymond van Laake

  6 replies

  13 years, 10 months ago

  By: Abel A.

• Changing Maximize Data Throughput for Network Applications

  Hello, I would like to change "Maximize Data Throughput for Network Applications" on my SQL server …

  ERIC CRUDELI

  1 replies

  13 years, 10 months ago

  By: Denisborrero

• Do we need a Full backup if we are not backing up the transaction log?

  Pretty basic question. Do we? =============================================================== "lets…

  jnuqui

  4 replies

  13 years, 10 months ago

  By: jnuqui

• Very Large Datasets

  Currently we have a Table that stores full paths to image files we have stored in the file system. …

  steve.groner

  6 replies

  13 years, 10 months ago

  By: steve.groner