SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• SQL Backup stuck in Restore Mode

  Hi everyone I have a DB, MDF is about 170GB, log 200GB. When I do a restore of it, the backup takes…

  Jako de Wet

  2 replies

  12 years, 3 months ago

  By: Jako de Wet

• sp_executesql: why does plan only use index seek with OPTION(RECOMPILE)

  While trying to find an alternative to usage of coalesce in the where clause I ran into an issue th…

  Bouke Bruinsma

  7 replies

  12 years, 3 months ago

  By: Gail Shaw

• ssms Display in Vertical Tabs

  I liked the default appearance of SSMS in 2005 and 2008. 2012 is lousy by default. My quesion is w…

  hayden_jones

  2 replies

  12 years, 4 months ago

  By: SQLRNNR

• Restoring only one file group

  I have created the file group for my database.First i took backup of individual file group(mdf and …

  mehdin69

  1 replies

  12 years, 4 months ago

  By: SQLRNNR

• CTE where amount is > +- 10%

  I am trying to do a trending query that will take an actual production count and compare that to th…

  caippers

  3 replies

  12 years, 4 months ago

  By: caippers

• Slow running query

  Hi Following on my query about tempdb allocation contention, I thought I'd follow up with more deta…

  peter.cox

  10 replies

  12 years, 4 months ago

  By: TheSQLGuru

• Intellisense not working

  I upgrade SQL 2008 express to SQL 2012 standard but Intellisense did not work. From tools, Text edi…

  adonetok

  6 replies

  12 years, 4 months ago

  By: OCTom

• Fuzzy grouping on huge data

  Hi We are trying to run fuzzy grouping using Business Intelligence tool of SQL Server on address fi…

  mawe37

  1 replies

  12 years, 4 months ago

  By: michal.lisinski

• MCTS 70-466 Implementing Data Models and Reports with Microsoft SQL Server 2012 Training kit.

  I am searching for training kit for Exam 70-466 (Implementing Data Models and Reports with Microsof…

  azhar.iqbal499

  1 replies

  12 years, 4 months ago

  By: Koen Verbeeck

• Replication

  Can we implement Transactional Replication from 2012 Standard edition to 2008 R2 Enterprise edition?

  SQL_Surfer

  1 replies

  12 years, 4 months ago

  By: - Win

• Query Performance - Using Inline/Table Functions

  Hi everyone, I have query that doesn't even register a time when running it. But when I add the lin…

  Jako de Wet

  4 replies

  12 years, 4 months ago

  By: Jeff Moden

• SQL Audit - Can you tie an audit entry back to it's "Audit Action type"

  I'm running some tests to see what is returned by the various "Audit Action Types" on a SQL 2012 Se…

  AbrahamLeftJoin

  1 replies

  12 years, 4 months ago

  By: Jack Corbett

• HIPAA and Security: Upgrade to Microsoft SQL Server 2012?

  Wondering if there are some general security or HIPAA related reasons why I would want to upgrade t…

  seandakid

  6 replies

  12 years, 4 months ago

  By: Steve Jones - SSC Editor

• Database Role permissions

  I am curious about his one. I have a database that with a role (db_Execute) that has execute permis…

  SQL_Padre

  2 replies

  12 years, 4 months ago

  By: SQL_Padre

• Unsure of 70-461 prep "Flash Card" answer

  I have been working with SQL Server (2005, 2008R2 & 2012) for about six years now and have rec…

  rustprooflabs

  2 replies

  12 years, 4 months ago

  By: rustprooflabs