SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Recreating sane index not improve the performance

  I have five indexes and i dropped the indexes one by one which is not used.When i dropped the one i…

  jkramprakash

  6 replies

  6 years, 5 months ago

  By: jkramprakash

• SQL Server Instance Copy

  I am trying to find the terminology or a point in the right direction about an idea I had. I have a…

  fubar0487

  1 replies

  6 years, 5 months ago

  By: NorthernSoul

• Stored procedure taking less time in local and taking more time in testing serve

  My stored procedure is running fast (2 sec) for particular parameter in local server with 25 millio…

  jkramprakash

  1 replies

  6 years, 5 months ago

  By: Eirikur Eiriksson

• Full Database Backups

  Hi I have a 1.5TB database that takes 6-7 hours to backup.At the end of the successful backup …

  h.iddamalgoda 91897

  4 replies

  6 years, 5 months ago

  By: h.iddamalgoda 91897

• Replication server

  Hello,I know nothing about SQL repication, and it's not my intention to become a DBA , but tI have …

  RobLW

  1 replies

  6 years, 5 months ago

  By: doug.brown

• Transactional replication message

  Hello!I am getting these messages on replication monitor in certain time of the day (usually at nig…

  PJ_SQL

  4 replies

  6 years, 5 months ago

  By: PJ_SQL

• SSIS Memory

  I have a number of memory issues whilst running SSIS Jobs.  I know with SSAS you can specify m…

  Wecks

  1 replies

  6 years, 5 months ago

  By: Sue_H

• Find missing numbers in sequence 1 thru 5

  I have a table with records. Each set of records is numbered 1 thru 5. I need  to iterate thru…

  rpatlan

  7 replies

  6 years, 5 months ago

  By: rpatlan

• Compare value changes by Week Number per unique ID

  Hi, I have a requirement to compare the values (based on current week and previous week) for a colu…

  pwalter83

  3 replies

  6 years, 5 months ago

  By: Thom A

• Help with the T-Sql to alter column size and before that the PK.

  Folks I tried this  ALTER TABLE [DataExtract].[dbo].[ControlSetting] ALTER COLUMN [ControlKey]…

  mw_sql_developer

  3 replies

  6 years, 5 months ago

  By: drew.allen

• Help me with the SQL - ( Issue with excluding nearby visits )

  Good Day Folks!     I need a listing of members who had a hospital visit. …

  mw_sql_developer

  8 replies

  6 years, 6 months ago

  By: Jonathan AC Roberts

• Backup Restorations

  Quick question.  So I know to do a point in time restoration you need to restore the Full, the…

  Wecks

  7 replies

  6 years, 6 months ago

  By: Sue_H

• Varchar(Max) storage

  Dear Experts,Have a confusion regards to the storage capacity of varchar(max). My question is , whe…

  Arsh

  12 replies

  6 years, 6 months ago

  By: Jeff Moden

• The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. The failure ID is 46.

  Receiving below error on SQL 2012 SP2 always on.  The client was unable to reuse a sess…

  SQL ADMIN 79

  2 replies

  6 years, 6 months ago

  By: Sue_H

• Can't connect to the reporting services from SSMS

  Hi, I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Repo…

  ramana3327

  4 replies

  6 years, 6 months ago

  By: cjmorgan