SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• How to handle date on temp table when is null or not ?

  How to handle date on temp table when is null or not ? I work on SQL server 2012 I using format dd/…

  ahmed_elbarbary.2010

  5 replies

  5 years, 7 months ago

  By: Jeff Moden

• How to create dynamic sql based on optional values from temp ?

  I have #TempMaster temp table have 3 fields with optional values on 3 fields SourceGeneralTypeID AN…

  ahmed_elbarbary.2010

  3 replies

  5 years, 7 months ago

  By: Grant Fritchey

• What is spinlock ALLOC_CACHES_HASH?

  Hi, Queries are slow, cpu usage at 80%. ALLOC_CACHES_HASH backoffs start at same time as problems a…

  My_Sky

  1 replies

  5 years, 7 months ago

  By: Grant Fritchey

• Facing connectivity issues

  Hi All, I am seeing below connectivity error while executing queries on a database. how can we fix …

  vsamantha35

  8 replies

  5 years, 7 months ago

  By: Grant Fritchey

• how to create query based on optional field on temp table ?

  problem how to create query based on optional field on temp table ? I work on sql server 2012 I hav…

  ahmed_elbarbary.2010

  1 replies

  5 years, 7 months ago

  By: as_1234

• how to find gaps between range

    I use sql 2012 but, one can answer up to 2019   create table t ( b decimal(13,4) not nu…

  rajemessage 14195

  8 replies

  5 years, 7 months ago

  By: rajemessage 14195

• how to create query based on optional field on temp table ?

  problem how to create query based on optional field on temp table ? I work on sql server 2012 I hav…

  ahmed_elbarbary.2010

  1 replies

  5 years, 7 months ago

  By: pietlinden

• database failover history in an AlwaysOn group

  Does anyone know if there is a history kept somewhere of failover events of a database in an AO gro…

  scogeb

  1 replies

  5 years, 7 months ago

  By: vamshichiranjeevi.g

• User access

  Hi, I would like to be crystal clear about how to confirm if any user has access and will need your…

  sizal0234

  1 replies

  5 years, 7 months ago

  By: sizal0234

• Relatively easy query assistance - datediff

  Hi all, I have a question since I'm new to SQL: I have a table which contains 3 columns: a customer…

  morkal

  1 replies

  5 years, 7 months ago

  By: Steve Collins

• How to make group by Revision_ID and when repeated display last check date separ

  problem How to make group by Revision_ID and when repeated display last check date separated by sti…

  ahmed_elbarbary.2010

  5 replies

  5 years, 7 months ago

  By: Steve Collins

• I need to take two fields and make a Date field

  my table is as follows YearID  2019 PeriodIDValue  P12 PeriodID  December I need to create a single…

  randyetheridge

  9 replies

  5 years, 8 months ago

  By: randyetheridge

• question about Always on

  I know there is good feather "Always ON" since SQL Server 2012, but I didn't used it, I have some q…

  892717952

  5 replies

  5 years, 8 months ago

  By: garminexpress8

• insert default values dynamically in sql server

  I have one question about SQL Server: how to dynamically load default values for all tables if 9999…

  asrinu13

  1 replies

  5 years, 8 months ago

  By: pietlinden

• Importing a CSV files in SSMS

  Hi, My manger uses the SSMS import to import his CSV files. he has one file he just got that has, l…

  itmasterw 60042

  11 replies

  5 years, 8 months ago

  By: itmasterw 60042