SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Internal connection fatal error. (System.Data)

  Hi, I am trying to expand my DB(DB size is 160 GB) after connecting to SQL Server 2008 named instan…

  Minaz Amin

  1 replies

  11 years, 3 months ago

  By: Berto Batumbakal

• return this one column into three columns

  Hi friends... I have table with one column 1 2 3 4 5 6 7 8 9 And i should return this one column in…

  karunakar2351

  1 replies

  11 years, 3 months ago

  By: Luis Cazares

• Restoring Logs - Empty Logs

  I have a job that retrieves log files from an FTP site, then restores them into a local database. T…

  Carol Adams

  2 replies

  11 years, 3 months ago

  By: Carol Adams

• cursor

  Hi, can someone share a simple stored procedure example to pass table name as output and output as …

  skrknarayana

  2 replies

  11 years, 3 months ago

  By: Luis Cazares

• Select Unique Customers per month for last 2 years..

  Hey, so I have the following SQL Query: SELECT COUNT(DISTINCT CustomerID) AS ActiveCustomers, DATEN…

  michaeleaton 36224

  7 replies

  11 years, 3 months ago

  By: cphite

• Need Help for my Query

  Hi All, This is Naveen Maroju,I unable to get output and please help me on this query. Mainly i wan…

  maroju1

  1 replies

  11 years, 3 months ago

  By: Jeff Moden

• Need help in SSRS Report

  Hi, I am getting the email of SSRS report everyday twice. I need to find why it is coming twice. Un…

  ramana3327

  9 replies

  11 years, 3 months ago

  By: ramana3327

• Why DML operations are not supported in functions?

  can anybody explain me this?

  sgsarbere

  7 replies

  11 years, 3 months ago

  By: er.mayankshukla

• Remove redundant data in select statement

  Hello, Having these two tables Table1: ContactDetail --------------- ID Name -- -------…

  RKaram

  3 replies

  11 years, 3 months ago

  By: Ed Wagner

• Does replication replicate index rebuild ?

  Hi all. We have transactional replication. We have a index rebuilding job on publisher, but subscri…

  SQL Guy 1

  1 replies

  11 years, 3 months ago

  By: Alan Burstein

• Performance cost for shrinking a log file

  How much of a performance hit (a little, moderate, A LOT, don't do it, etc.) is there from shrinkin…

  Sean Perkins

  4 replies

  11 years, 3 months ago

  By: Sean Perkins

• Need to upgrade to 2008 r2 from 2005

  Hello everybody, I need to upgrade a SQL 2005 instance to at least 2008 R2 to satisfy requirements …

  vecerda

  2 replies

  11 years, 3 months ago

  By: vecerda

• Need to find gaps in a sequence which increments by 2

  Hi Friends, I'm trying to write a query to validate the data. Here is the scenario: 1. The table ha…

  ezapa001

  1 replies

  11 years, 3 months ago

  By: Sean Lange

• convert date 103 dd/mm/yyyy

  Hi I have date field stored as 2014-08-03 on the Table, and I'm trying to select convert(varchar(10…

  hoseam

  2 replies

  11 years, 3 months ago

  By: Sean Lange

• Count Delta

  I have attached an excel spreadsheet with sample data and results I am looking for. I'm trying to …

  scotsditch

  1 replies

  11 years, 3 months ago

  By: sushila