SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Automated script run on Availability Group failover?

  Let's say I have a two node AG, Server A and Server B. Server A is normally the primary and Server…

  Mick Opalak

  4 replies

  4 years ago

  By: David Reabow

• ASPNETDB - Lock Out SharePoint Accounts not logged on in a long time

  Hi Guys, I'm not a DBA so looking for assistance with this one. We need to automate locking out acc…

  ckwlnoobie

  1 replies

  4 years ago

  By: Mr. Brian Gale

• Mysterious ability to drop / create stored procedures

  I hope someone here can assist me. I am trying to track down any potential hidden permissions that …

  Brandie Tarvin

  14 replies

  4 years ago

  By: frederico_fonseca

• The EXECUTE permission was denied on the object sp_send_dbmail

  Hi, I have a problem with send mail to SQL Server 2012. This script: DECLARE @TESTOBODY nvarchar(30…

  nichi

  10 replies

  4 years ago

  By: david.boerwinkle

• "... is marked for unload due to memory pressure" - is that a big problem?

  I've got a mixed server on which SSIS is being used and I got notification about memory pressure an…

  jankovic

  1 replies

  4 years ago

  By: jankovic

• encapsulating DECLARATIONS, UNION ALL, and SELECTS into CTE

  I'm having trouble getting this to fit into a usable CTE (the below is returning the expected data …

  DaveBriCam

  15 replies

  4 years ago

  By: DaveBriCam

• Choosing two fields from only the two most rec the first and second records only

  I have a table and the data looks like the results of this query: SELECT TOP 10 [CallCount], [times…

  DaveBriCam

  4 replies

  4 years ago

  By: DaveBriCam

• Function for converting hh:mm:ss time to decimal equivalent

  I have a user defined function that just needs a little tweaking. The first block of code used in a…

  DaveBriCam

  1 replies

  4 years ago

  By: Jeff Moden

• Result set is not coming in order by date

  Hello Everyone, I am selecting a result set from my sql database. Below is the query. DECLARE @toda…

  gaurav

  11 replies

  4 years ago

  By: Jeffrey Williams

• Update table column using other table

  Hello Everyone, I have a requirement. I have two tables with following columns. Table1 (emp_id, emp…

  gaurav

  3 replies

  4 years ago

  By: Mr. Brian Gale

• How to delete from #partattaributes when count of rows per code and codetype is

  I work sql server 2012 I face issue i need make delete statement to delete all rows from #partattri…

  ahmed_elbarbary.2010

  2 replies

  4 years ago

  By: kaj

• Regarding the issues of Index and data storage

  I don't know how the basic knowledges about data storage and index structure?index storage, my ques…

  892717952

  1 replies

  4 years, 1 month ago

  By: 892717952

• How to get parts when i have same part and same code type repeated with differe?

  I work on sql server 2012 i face issue i need to get partid have same code type id but have differe…

  ahmed_elbarbary.2010

  2 replies

  4 years, 1 month ago

  By: kaj

• Database Triggers

  Hi, I need to send out an email every time an alarm level is <> 0. I need this to happen as s…

  mballentine

  5 replies

  4 years, 1 month ago

  By: Jeff Moden

• the reads of SQL profiler is the number of SQL Server logical read?

  I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), b…

  892717952

  21 replies

  4 years, 1 month ago

  By: 892717952