SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Changing network packet size

  Hi our network has an MTU of 1500 so I've changed the network packet size to 1472 to stop the packe…

  alex.palmer

  10 replies

  8 years ago

  By: Sue_H

• Find out owners of objects

  Dear All, I'm trying to find out if there is a way of finding out if a particular login is an owne…

  tt-615680

  3 replies

  8 years ago

  By: SGT_squeequal

• Why would changing the compatibility mode affect parallelism in a query?

  Hi, We changed the compatibility mode from 100 (2008) to 110 (2012) on a 2012 Enterprise SQL server…

  lindsayscott23

  5 replies

  8 years ago

  By: sgmunson

• SQL Query - Hourly Count

  HiI am not a DBA so please excuse me if this question is very basic I want a report to know hourly…

  uknites

  10 replies

  8 years ago

  By: uknites

• SQL Over network slow

  Why would SSMS only use about 500kbps when going through a linked server connection vs almost full …

  Jackie Lowery

  2 replies

  8 years ago

  By: sgmunson

• Updating changes to TFS

  Can some one please help me with any possibility to update the changes from DEV to TFS .I have a da…

  KGNH

  2 replies

  8 years ago

  By: Jo Pattyn

• Best option to insert data from Staging table to main table

  Hello every one, I have a requirement when I have to load the data from staging table to main table…

  KGNH

  5 replies

  8 years ago

  By: Lempster

• Getting UserDetails from Application

  I have to write a procedure where I need to capture some data from application and insert into some…

  KGNH

  7 replies

  8 years ago

  By: KGNH

• Migrating data from one server to another

  Hi Is there any way other than export and import where we can migrate data from one server to anoth…

  KGNH

  9 replies

  8 years ago

  By: KGNH

• Rollup/Aggregate tables and maintenance

  Hello, We have numerous customers, each with their own database and in those databases we have a ta…

  paul 69259

  9 replies

  8 years ago

  By: Sue_H

• Varbinary to varchar in sys.certificates

  i have an issue , i am trying to do a join on thumbprint field in certificate to a table with thumb…

  zaheer.timol

  2 replies

  8 years ago

  By: Thom A

• Explicit value must be specified for identity column ether when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column

  Hi I inherited old system and trying to copy replication bewteen sql2012 servers standard editio…

  ebooklub

  2 replies

  8 years ago

  By: ebooklub

• Unable to start SQL Server service-error 3414

  After the emergency shutdown of the computer the SQL Server (SQLEXPRESS) service does not start and…

  franksalgado88

  3 replies

  8 years ago

  By: kentsteve207

• Migration from Dev to QA

  I am having my database created in dev environment and want to move it to QA. is there any way othe…

  KGNH

  3 replies

  8 years ago

  By: KGNH

• HELP ME WITH THE WHERE CLAUSE ( Select records based on a variable value )

  My Issue:I want all the records or ( The ones where  INCLUDE_ME = 'Y' ) to show up based on th…

  mw_sql_developer

  5 replies

  8 years ago

  By: Luis Cazares