SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• corruption in database : what do next

  hi What steps should be taken once corruption has been identified through dbcc ckecdb command .I me…

  anoop.mig29

  2 replies

  5 years, 11 months ago

  By: anoop.mig29

• Delete from parent table question

  I have a parent table that is referenced by many other child tables . Is there a way to delete from…

  Guras

  4 replies

  5 years, 12 months ago

  By: drew.allen

• Search object (table, stored procedure) in SQL server agent

  There are about 100 jobs in SQL server agent. Is there any way to search a table to view which jobs…

  adonetok

  1 replies

  5 years, 12 months ago

  By: MVDBA (Mike Vessey)

• XML Data singleton value not fixed????

  Hi Hope to explain this correctly I have some XML data that can vary on singleton value So in the e…

  jbalbo

  4 replies

  5 years, 12 months ago

  By: jbalbo

• DB digram, Standard reports to use.

  Hi, Please let me know.. DB Diagram: SSMS is not helping with so many tables and huge DB. Please a…

  sizal0234

  1 replies

  5 years, 12 months ago

  By: MVDBA (Mike Vessey)

• transaction delay when replica unavailable - what effect?

  I'm using AlwaysOn synchronous replica.  User issues an update on primary via SSMS.  In order for t…

  snomadj

  3 replies

  5 years, 12 months ago

  By: Sue_H

• Index Question

  I have a table that has 592,969,976 records.  The primary key is a bigint with identity option turn…

  mike 57299

  22 replies

  5 years, 12 months ago

  By: frederico_fonseca

• Database Backup and corruption Jobs

  Hi, Please advise of the below scenarios 1Q) I am trying to reduce the sql agent back up job runnin…

  sizal0234

  4 replies

  5 years, 12 months ago

  By: Leo.Miller

• Execute Process Task Not Working

  I am using Visual Studio 2010 on SQL Server 2012.  I have an Execute Process Task which runs w/o er…

  dzanke

  2 replies

  6 years ago

  By: as_1234

• How to get Next available Date in MDX

  I would like to get next available date for next month based on working day. I am using flag =1 as …

  kk_tech

  1 replies

  6 years ago

  By: kk_tech

• Divide 2 rows in same column

  Hi, How can i divide 2 rows with condition. Type | Year | Month | Car | Amount A | 2019 | JAN | HON…

  girl_bj

  3 replies

  6 years ago

  By: drew.allen

• Microsoft Technet Virtual Labs for SQL Server 2012, 2014, and 2016

  Hi, About a year ago, there were a ton of virtual labs related to SQL server prior versions.  Those…

  dbgaragedays

  1 replies

  6 years ago

  By: dbgaragedays

• Index and fragmentation

  Hi  folks I know its very stupid questions but i have few doubts about sql server index and fragemn…

  anoop.mig29

  8 replies

  6 years ago

  By: David Burrows

• SQL Query between 2 dates

  Hello I'm working on programm for presence control e.g ID  -       CheckIn                       - …

  dataprotec

  10 replies

  6 years ago

  By: Jeff Moden

• Deny Permissions to Schema Owner (assign read only) and deny to Linked Servers

  We are running SQL Server 2012 SP4 EE on Windows Server 2008 R2 Standard. We had a developer who mo…

  HookSQLDBA7

  2 replies

  6 years ago

  By: HookSQLDBA7