SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Order By in an SQL query with aggregate function and CASE.. WHEN...END

  I have this query which works OK. SELECT D.MStockCode AS StockCode, CASE WHEN [W_SE-MFG].dbo.[YearW…

  saintor1

  5 replies

  6 years, 3 months ago

  By: saintor1

• Timestamp from String

  Hi I have a table with Timestamp column named TS I want to filter the table based from TS I try wit…

  makis_best

  1 replies

  6 years, 3 months ago

  By: Thom A

• 32 bit import export wizard inquiry

  My co-worker is still running 32 bit visual fox pro.  Can he use the 32 bit sql server 2012 import …

  fizzleme

  1 replies

  6 years, 3 months ago

  By: fizzleme

• Invalid column name error

  declare @DTBEGIN date = '02/01/2018' declare @DTEND date = '05/22/2019' SELECT * FROM ( SELECT c.co…

  Guras

  2 replies

  6 years, 3 months ago

  By: Sue_H

• How do I reassign which application gets invoked?

  I've been using SSMS for bajillions of years. Last week I needed to install MySQL. I didn't realize…

  Rod at work

  3 replies

  6 years, 3 months ago

  By: Lowell

• Database stuck in restoring mode setting up AlwaysOn

  I'm trying to do some proof of concept work with AlwaysOn in SQL Server 2012. I've got 2 Windows 20…

  joepacelli

  4 replies

  6 years, 3 months ago

  By: Meindert

• LINKEDSERVER is not accepting a domain-user in Windows authentication Mode

  LS, The situation: 2 node cluster (SQL 2012), 4 instances , 2 instances prefered active on node1 - …

  gkramer 23701

  2 replies

  6 years, 3 months ago

  By: gkramer 23701

• Best practices for comparing todo tasks to completed tasks when the todo tasks c

  I have a situation where I am required to compare a list of todo items to a list of done items and …

  ckuroda

  1 replies

  6 years, 3 months ago

  By: ckuroda

• Making a Copy of an Existing DB in SQL using SQL script

  We need a script by which a source DB, the name will be supplied, to be copied into another DB with…

  vimalmv

  6 replies

  6 years, 3 months ago

  By: Sue_H

• How to Trace ASYNC_NETWORK_IO

  We have just converted a SQL Server box from a physical server to a vm. I noticed a significant slo…

  Lijun Zhang

  2 replies

  6 years, 3 months ago

  By: Sue_H

• Is there any problem for using multiple columns in clustered index

  Hi everyone, We have a table(Table1)in sql server 2012, this table has below columns. TransactionID…

  Aspet Golestanian Namagerdi

  1 replies

  6 years, 3 months ago

  By: MVDBA (Mike Vessey)

• Changing Owner NOT dbo_Owner

  An administrator restored some SharePoint databases for me and did not use the service account I as…

  MothInTheMachine

  4 replies

  6 years, 3 months ago

  By: Lowell

• Data Type Error In Stored Procedure -Updating a Table

  I have the below stored procedure, and I am getting this error message: Error converting data type …

  cajun_sql

  3 replies

  6 years, 3 months ago

  By: Michael L John

• non primary key column auto increment

  hello friends, i have a stored procedure in SQL server database for my page the problem is i have a…

  ahsal

  5 replies

  6 years, 3 months ago

  By: ahsal

• Resource Governor and Alerts

  I have an alert which reports on high cpu when the Workload Group Stats reaches a certain threshold…

  HappyGeek

  1 replies

  6 years, 3 months ago

  By: HappyGeek