SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Object to Syntax Scan on bulk scale

  I have about 250 tables that I need to do a full scan on objects (stored procedures, views) to see …

  spitfire15

  4 replies

  9 years, 1 months ago

  By: spitfire15

• New fact table not listed during create New Partition

  Hi, I have no experience in SSAS and have a problem. I want to create new partition for my existing…

  tonzonline

  1 replies

  9 years, 1 months ago

  By: tonzonline

• ReportServer - Can we know when a report was last accessed ?

  Select top 100 * FROM Catalog /* This table does not have the info I am looking for */

  mw_sql_developer

  4 replies

  9 years, 1 months ago

  By: Chris Harshman

• SSIS --Taking ID from destination table to copying the same in the another destination table

  Hi, Need a help on one SSIS package. Wanted to move master and child two tables data from source to…

  farooq.hbs

  2 replies

  9 years, 1 months ago

  By: John Rowan

• T-SQL-Counting Occurrences over a rolling 12 month period

  Have a problem that has me stumped. MSSQL 2014. The problem is this. Have a table storing id, date,…

  mightycaptain

  3 replies

  9 years, 1 months ago

  By: sgmunson

• When roles do I should add?

  Hello everybody. I am new on that server so after weeks od reading, from the begining of new year i…

  dariusz.piechota.dan

  1 replies

  9 years, 1 months ago

  By: Steve Jones - SSC Editor

• Master Data Services, Error 2601 when pressing "Add Member"

  I am getting the following error in MDS when clicking the "Add Member" button: 2601: Cannot insert…

  acapone

  2 replies

  9 years, 1 months ago

  By: hiren.patel 911

• Is there a matured solution to ETL excel data?

  Merry Christmas and happy new year! From time to time my work needs to deal with lots of excel shee…

  halifaxdal

  13 replies

  9 years, 1 months ago

  By: Eric M Russell

• sa password is lost - need to add Sys Admin Privileges to another account

  Hello all I have a very frustrating problem. About 20 SQL servers (instances) I administer do not h…

  h.iddamalgoda 91897

  7 replies

  9 years, 1 months ago

  By: Jeff Moden

• early weigh-in results: Rousey hits 135, Hendricks pablinaerer

  Tennessee vs. Nebraska Live Stream Georgia vs. TCU Live Stream Sun Bowl 2016 Live Stream Liberty Bo…

  angelopoche

  1 replies

  9 years, 1 months ago

  By: John Rowan

• SQL Query to fetch

  I am having table as below which is having 3 columns. first column name is 'uid' which is primary k…

  SQLserver_learner

  23 replies

  9 years, 1 months ago

  By: SQLserver_learner

• Numeric characters that are varchar type going into Excel column as string

  I am exporting data from sql2012 into excel sheet, some of the fields (for example productnumber) a…

  Zososql

  4 replies

  9 years, 1 months ago

  By: Jeff Moden

• SQLDump(Crash Dump Files)

  One of the PRD server got hung due to SQLDump(Crash Dump Files) were generating every seconds and p…

  SQLisAwe5oMe

  2 replies

  9 years, 1 months ago

  By: SQLisAwe5oMe

• SQL syntax HELP

  Folks: Good Day! Can someone help me with DYNAMIC SQL. You may insert your code inside the WHILE LO…

  mw_sql_developer

  6 replies

  9 years, 1 months ago

  By: mw_sql_developer

• Filtered Index, Getting 'Created failed for Index"

  HI, I am trying to added a filtered index. Here are my steps 1. right click to Indexes and selected…

  comic_rage

  4 replies

  9 years, 1 months ago

  By: Alan Burstein