SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• SQL .NET Framework 4.0 upgraded to 4.5 on SQL 2012 Ent server

  HI - SQL: SQL 2012 Ent. We have a Severity A case open with Microsoft regarding SQL assemblies and …

  cheshirefox

  1 replies

  12 years ago

  By: paul.knibbs

• BACKUP LOG failed with "Cannot insert duplicate key in object 'dbo.backupmediaset'" message

  One of my database transaction log backup jobs failed this morning, although the log backup was sti…

  tripleAxe

  6 replies

  12 years ago

  By: tripleAxe

• Need to get object type for synonym base object (2012)

  Hi all, I need to get the object type (view, table ...etc) for a synonym base object inside a …

  jmartincano

  6 replies

  12 years ago

  By: jmartincano

• TempDB Log file usage constantly rising and file keeps growing.

  Having a strange problem this morning. The TEMPDB transaction log file keeps growing. The database …

  Maddave

  10 replies

  12 years ago

  By: Maddave

• Current resource hogs

  Hi all, I am looking for scripts to find "currently running" resource hogs. I have scripts for ov…

  shahgols

  1 replies

  12 years ago

  By: Gail Shaw

• Migrating sql 2005 to 2012 SSIS, SSAS, SSRS

  Hello, I know this is a broad question, but my company is upgrading sql 2005 environment to sql 201…

  Lord Slaagh

  4 replies

  12 years ago

  By: Lord Slaagh

• Really hope SSC can remove these annoying posts for the World Cup!

  Hopefully you guys are working on removing this world cup crap from our beloved SSC site. The are n…

  Lord Slaagh

  2 replies

  12 years ago

  By: Lord Slaagh

• select the record with the most recent order date

  Hello I am working on a query that needs to return the record order number with the most recent req…

  itortu

  15 replies

  12 years ago

  By: ChrisM@Work

• Split csv records to seperate columns

  Hi, I've a table as below custid,companyname,phone,address 2,AAAAA,(222) 222-2222,address 2 3,cust …

  ykonline

  15 replies

  12 years ago

  By: Koen Verbeeck

• Tricky SUM(C1) OVER.. with extra selection? is it possible.

  Hi, I have this task to carry Sum* fields into RDL and I need to make calculation as in below query…

  mario17

  6 replies

  12 years ago

  By: mario17

• Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS

  I am writing some reporting queries to show execution start and end times of my SQL jobs. I need to…

  SQLCurious

  10 replies

  12 years ago

  By: Jeff Moden

• Strange backups in sql server logs

  I have an sql 2012 express server. Just checked the server logs and found that every day ~1PM ever…

  stmarti

  11 replies

  12 years ago

  By: Ed Wagner

• SQL Backups versus TSM TDP SQL (Tivoly Storage Manager)

  Hi Everyone, I have a big dilemma I have to decide between a Traditional SQL Backups and Restores a…

  APA0876

  2 replies

  12 years ago

  By: APA0876

• Help needed on Sybase to Sql 2012 migration

  Hi All, I have recently joined to Sybase to sql server 2012 migration team. Sybase source has close…

  Suresh Arumugam

  9 replies

  12 years ago

  By: Suresh Arumugam

• Specify SQL Server Installation location when Adding second node to Cluster

  When adding a node to a SQL Server 2012 Standard edition cluster, how I do I identify the location …

  David Bird

  3 replies

  12 years ago

  By: EdVassie