SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• SpinLocks

  Hello, Does anyone know what the following Spinlocks stand for? name co…

  kkanaya

  10 replies

  8 years ago

  By: kkanaya

• Retrieving revenue total for last day of previous month

  Hi Im trying to retrive total revenue last day of previous month, i can get all the months tot…

  Stix83

  4 replies

  8 years ago

  By: kaj

• Intellisense broken?

  Up until about a week ago, Intellisense on my SSMS worked fine. Now it's still working but for some…

  Brandie Tarvin

  11 replies

  8 years ago

  By: Luis Cazares

• Retrieving sales from last month

  I created a report in ssrs with start and end date parameters that pull summary pipeline for certai…

  Stix83

  3 replies

  8 years ago

  By: Stix83

• Linked Server Error

  Hi,I am trying to export the SQL (Server 2012)  data to Excel file.  I tried the below qu…

  Balz

  1 replies

  8 years ago

  By: Jeff Moden

• Unable to index materialized view

  Tying to create an index on this view: and receive the following error:Column cannot be used in an …

  TryingToLearn

  5 replies

  8 years ago

  By: TryingToLearn

• SQl server 2012 dev edition to enterprise edition

  We have finishing testing a complex application in SQL 2012 dev.  Our team has decided the bes…

  fizzleme

  4 replies

  8 years ago

  By: Ant-Green

• Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error

  Hi Team, Throwing bellow error while creating connection string in SSIS Package to connect SQL…

  PRAMANA.DBA

  3 replies

  8 years ago

  By: Sue_H

• Tempdb Error

  Hi All, I have 3 ndf  files for Tempdb and each one is now grown to 110+ GB. i.e total 330 GB+…

  Jatin Soni

  5 replies

  8 years ago

  By: Jatin Soni

• MDS Database with 9GB

  Dear All, I have MDS configurated in our work environment. We have just some tables (50 tables) eac…

  river1

  1 replies

  8 years ago

  By: Super Cat

• SQL Server 2012 : Error Could not allocate space , PRIMARY Filegroup is full

  Hi,We are having a production database containing 4 datafiles of 50 GB each, One is in PRIMARY File…

  santosh.mane

  6 replies

  8 years ago

  By: santosh.mane

• How to calculate the exact age ? Help

  Select Datediff(yy, '20161201', '20171130')  as   age1 , FLOOR(DATEDIFF(DAY, '201612…

  mw_sql_developer

  2 replies

  8 years ago

  By: mw_sql_developer

• XML question.

  How to output <?xml version="1.0"?>  from a stored procedure select ( ---all my XML que…

  Guras

  4 replies

  8 years ago

  By: Eirikur Eiriksson

• undo ssms table designer changes

  Using SQL Server 2012, Microsoft SQL Server Management Studio    11.0.3156…

  ztoddw

  3 replies

  8 years ago

  By: ztoddw

• Build versions

  Our sql server 2012 build number is 11.0.6251.   A vendor suggested we apply 2 hot fixes.…

  fizzleme

  1 replies

  8 years ago

  By: Sue_H