SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how to write a select query by passing @catid as parameter for this tables and using coalesce ?

  here i am having three table in this i want to coalesce fname depend on artid these ar…

  Sivaganesh Tamilvendhan

  2 replies

  13 years, 10 months ago

  By: Sivaganesh Tamilvendhan

• where to setup SQL Server alias

  Hi, We have SQL Server 2008 R2 named instance and we need to configure Sharepoint to use that sql i…

  gary1

  6 replies

  13 years, 10 months ago

  By: Jared

• Joining two queries

  I am attempting to join the two queries together. The two queries function properly separately. I'v…

  neb2886

  21 replies

  13 years, 10 months ago

  By: Jared

• can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side?

  can any one try solve my problem here i am facing a problem Failed to retrieve data when i en…

  Sivaganesh Tamilvendhan

  1 replies

  13 years, 10 months ago

  By: Sivaganesh Tamilvendhan

• What is the best way to encrypt SSNs and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?

  What is the best way to encrypt SSN's and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?…

  Welsh Corgi

  14 replies

  13 years, 10 months ago

  By: Welsh Corgi

• forcing parallelism when excecuted via asp.net

  When executing a proc in SQL Management Studio (SMS), the query plan shows parallelism is used. How…

  smv929

  2 replies

  13 years, 10 months ago

  By: smv929

• Update statistics

  Dear All, I run a stored procedure and it executes “infinite”. Stopped it and then I decided to upd…

  Igor Micev

  6 replies

  13 years, 10 months ago

  By: Igor Micev

• There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_dbmail'?

  There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_…

  barrantesrob

  3 replies

  13 years, 10 months ago

  By: Lowell

• Partition Schema Revamp

  I like to automate as much as I can when possible. And then I cam across this in a database I inhe…

  MegaDBA

  3 replies

  13 years, 10 months ago

  By: Jared

• Login User mapping related issue

  I need to find out accress and permission of Two users Mark and Mike on a database. Both users shou…

  mishrakanchan86

  5 replies

  13 years, 10 months ago

  By: Jared

• SSIS or Service broker?

  Hi All, We are intending to harvest data on a daily basis from 500 remote sites. Its likely to be u…

  Terry_Pino

  1 replies

  13 years, 10 months ago

  By: Jack Corbett

• Query Plan

  Hi How can i know what is the first query that creates the plan in cache,right after update statis…

  mah_j

  1 replies

  13 years, 10 months ago

  By: Jack Corbett

• SQL Server Installation

  Does SQL Server 2008 R2 Enterprise edition CD comes with SSAS,SSIS and SSRS or do we have to buy th…

  sql_novice_2007

  2 replies

  13 years, 10 months ago

  By: sql_novice_2007

• Alter schema of the table which is part of replication

  I am getting below error when I try to alter the schema of one of the table. Table is replicated to…

  raj_shekar2005

  2 replies

  13 years, 10 months ago

  By: raj_shekar2005

• Check My Logic - Telemetry From Multiple Sources

  I have many tables in my database, each one representing telemetry data from a sensor, with each ro…

  Jasmine D. Adamson

  3 replies

  13 years, 10 months ago

  By: GSquared