SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Analytics/Reporting Software

  Hello, Just wondering what Reporting/Analytics software everyone uses? I am looking to switche…

  GaffneyJ

  4 replies

  6 years, 12 months ago

  By: xsevensinzx

• View Server State Permission question regarding sp_who2 and security issues/holes

  We are running SQL Server 2012 SP3 on Windows 2008 Server. Are there any security issues/holes with…

  HookSQLDBA7

  2 replies

  6 years, 12 months ago

  By: Sue_H

• Fastest Way to Update Rows in a Large Table in SQL Server

  HI ,I have one doubt in sql server Basically I need to run this on a table with 60 million rows, up…

  srinudw88

  2 replies

  7 years ago

  By: drew.allen

• Big X Importing XLSX with Abort Error

  I have an xlsx file with 104 columns and 700,000 rows. When I try to import it into the DB, using t…

  tinausa

  3 replies

  7 years ago

  By: sgmunson

• Cannot drop user who is a Schema owner

  Dear All, I'm currently trying to remove a user who is no longer required to be on the server but …

  tt-615680

  5 replies

  7 years ago

  By: Steve Jones - SSC Editor

• Unused Indexes

  Dear Experts,I generated a list of unused indexes from my database by equating User_scans, user_see…

  Arsh

  6 replies

  7 years ago

  By: Jeff Moden

• restoring msdb from backup file

  Hi there,One client has a SQL Server 2012 Instance  working on a production machine.They had a…

  cidmi

  3 replies

  7 years ago

  By: cidmi

• Last Security Patch

  Dear Experts,Can anybody help me know how to check what the last security patch was applied to our …

  Arsh

  5 replies

  7 years ago

  By: Sue_H

• Slow running query - only off peak

  Hi All, I have an an issue with a query in a scheduled job running  every ten minutes around t…

  sharky

  6 replies

  7 years ago

  By: Arsh

• Select Max dates which lower than current date

  HelloI have the below table which has the records of the payments, I want to select the kids whom l…

  Mando_eg

  5 replies

  7 years ago

  By: jonathan.crawford

• "MSDASQL" for linked server "xxx" reported an error. The provider reported an unexpected catastrophic failure. over linked server - Solution

  Hi Guys and girls I've just spent the last few weeks banging my head against a brick wal over this …

  niquem1974

  1 replies

  7 years ago

  By: mpaul0961

• Windows 2012 to Windows 2016 Cluster Update

  I apologize for possibly placing this question in the wrong forum; I don't see a relevant forum for…

  David Lafayette

  1 replies

  7 years ago

  By: David Lafayette

• Rounding two decimal place works for some

  Why some of my records are rounded to two decimal places and others not when I do this: select empl…

  kd11

  2 replies

  7 years ago

  By: kd11

• Open MDMP Dump File

  I’m not a regular user of VS 2012, but the I have a MDMP (SQL DUMP FILE). That I need to open and d…

  Super Cat

  3 replies

  7 years ago

  By: Super Cat

• Delete statement hangs

  Hi all, Vendor gave me a statement to run to delete records from tables. The last output of the sta…

  wzline

  16 replies

  7 years ago

  By: wzline