SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Compare two databases

  Hi ,   What are the parameters to compare two databases if migrated from source to destination…

  Jai-SQL DBA

  1 replies

  5 years, 10 months ago

  By: Andrey

• How to enhance this query for good performance ?

  I work on sql server 2012 and i need to enhance or make this query have good performance this store…

  ahmed_elbarbary.2010

  3 replies

  5 years, 10 months ago

  By: x

• SPwho2 Blocking Scenarios

  Hi All, I have a basic question. I run SP_Who2 to check blocking and know that when we see SID in t…

  sizal0234

  6 replies

  5 years, 10 months ago

  By: sizal0234

• Get latest address column with Flag = Y in all rows

  Hello All I have an issue regarding getting column value with flag=Y in all rows- as latest address…

  sql_learner29

  5 replies

  5 years, 10 months ago

  By: sql_learner29

• Script out publication does not copy the replication SP to the subscriber

  Hi , I have configure few transactional replication  using the initialize from backup method for DB…

  stanley_1982

  1 replies

  5 years, 10 months ago

  By: stanley_1982

• SSMS - Results Tab - Keyboard Shortcut

  Greetings, In the results tab, is there a keyboard shortcut to copy a whole column of data starting…

  robtyketto

  3 replies

  5 years, 10 months ago

  By: robtyketto

• SP Estimated Execution Plan

  Please let me know your thoughts. FYI.. I removed the tb and Dbname. First question.. Attached is t…

  sizal0234

  3 replies

  5 years, 10 months ago

  By: Chris Harshman

• CPU Usage high

  No much activity on the server and CPU usage is not dropping to normal CPU Usage.  Would restarting…

  Admingod

  13 replies

  5 years, 10 months ago

  By: Chris Harshman

• Update field in records w/ MIN timestamp

  I have a query that selects the record with the MIN timestamp based on a several GROUP BY fields.  …

  ncraigg

  2 replies

  5 years, 10 months ago

  By: Jonathan AC Roberts

• Remove the middle of a string between wildcards

  I have a field called 'jsonpayload' in a table called 'auditlog' that is populated with activity fr…

  ncraigg

  3 replies

  5 years, 11 months ago

  By: ncraigg

• ? List all tables used in stored procedures and views ?

  Hi,   Maybe I'm googling this wrong, but I'm looking to find out how I can list all the tables…

  jbalbo

  2 replies

  5 years, 11 months ago

  By: drew.allen

• Understanding the use of a CTE with MERGE

  I'm familiar with CTE's which I have used a lot and I am somewhat familiar with the MERGE statement…

  YSLGuru

  14 replies

  5 years, 11 months ago

  By: below86

• service pack Question

  Hi, I updated our SQL ser5ver from Sp2 to SP 4 today, and it says it was a success. However when I…

  itmasterw 60042

  15 replies

  5 years, 11 months ago

  By: Steve Jones - SSC Editor

• sql server connectivity

  Hi All, Today, Users are complaining about intermittent database connectivity issues from tomcat ap…

  vsamantha35

  9 replies

  5 years, 11 months ago

  By: vsamantha35

• Sending email notification using SQL agent step/p

    I am trying to send email to specific people when the jobs completes. the idea is to add the…

  sizal0234

  1 replies

  5 years, 11 months ago

  By: Jeffrey Williams