SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Restricting Tables from SysAdmin

  I have a database which, among other items, has sensitive, Executive payroll tables. As the Develo…

  EddieN1

  2 replies

  12 years ago

  By: Maddave

• SQL 2012 Memory Clerks

  Hi All Prior to SQL 2012, when using the sys.dm_os_memory_clerks, the MEMORYCLERK_SQLBUFFERPOOL cl…

  SQLSACT

  1 replies

  12 years ago

  By: Bhuvnesh

• Add additional SQL 2012 instance to Windows Failover Cluster

  Hi All, I have a Windows Failover Cluster setup across 3 nodes with only 1 service/application runn…

  dgraf

  1 replies

  12 years ago

  By: Perry Whittle

• I need an exclusion query again. My totals are wrong.

  Hi Can someone put the following perhaps in a query that makes sense. My totals are wrong so I'm t…

  frdrckmitchell7

  12 replies

  12 years ago

  By: crmitchell

• Build datawarehouse from scratch

  Hi friends, I have couple of questions. I have experience working in datawarehouse projects but …

  a2zwd

  7 replies

  12 years ago

  By: shoestringdba

• Performance issues SQL 2012

  Hi, Everyday I truncate a table of roughly 40 millions rows, populate it and re-create the indexes.…

  Rem70Rem

  8 replies

  12 years ago

  By: Bhuvnesh

• Low memory usage and low PLE on 23GB virtual server

  I am trying to help a customer with a performance problem on a SQL server that runs several differe…

  Stefan_G

  6 replies

  12 years ago

  By: TheSQLGuru

• temp table vs permanent table performance

  Hi There , Im handling cores of data which will refreshed in every run. for this which one I can go…

  vignesh.ms

  8 replies

  12 years ago

  By: TheSQLGuru

• sql server 2012 licensing question

  Hello all We have a fairly simple SQL server environment today (licensing wise) All of our SQL Se…

  Jpotucek

  7 replies

  12 years ago

  By: jasonmorris

• Using cdc LSN for SSIS multiple table export without database snapshot

  Hi, I have a range of tables enabled with CDC. At a set point I want to export all the net changes …

  Tulla_123

  1 replies

  12 years ago

  By: MarkusB

• multiple conditions

  hi, idk if I'll give to explain very well. but I need to make a query with the following conditions…

  julioph77

  2 replies

  12 years ago

  By: TomThomson

• Adhoc queries and DB id

  Dear All I want to get last executed queries on a DB. Using dm_exec_query_plan , dm_exec_query_stat…

  Krishna1

  9 replies

  12 years ago

  By: Gail Shaw

• SSRS Number - Custom Format Issue

  Hi Please find the attached snapshot for SSRS Custom Number format issue. I am using as Number form…

  SQL_By_Chance

  1 replies

  12 years ago

  By: Koen Verbeeck

• Query Issue

  DECLARE @County NVARCHAR(100) DECLARE @Longitude decimal(19,15) = -87.979529 DECLARE @Latitude dec…

  SQLEnthus

  3 replies

  12 years ago

  By: mickyT

• Replication Migration problem

  I have a 2008R2 environment that I want to migrate to 2012 for replication. The production servers …

  DavidKBennett

  3 replies

  12 years ago

  By: DavidKBennett