Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Which of these indexes should be deleted?

  Hi I run a query on indxes . and this is 3 records of result : TBL_1 --------- IX_1 user_seeks = …

  sm_iransoftware

  21 replies

  9 years, 2 months ago

  By: Gail Shaw

• Does log shrink would affect any process happenning

  I use the following script to shrink the logs, just wondering if it cause any problems doing it whi…

  alirezaradman

  2 replies

  9 years, 2 months ago

  By: umarrizwan

• Exit from "Not Synchronising" Primary Database in availibility Group

  Hi I Create an availibility Group with a primary and a secondary. (For test) Then run Planed Failov…

  sm_iransoftware

  5 replies

  9 years, 2 months ago

  By: muthukkumaran Kaliyamoorthy

• Always on

  how to remove always on in sql 2012 ?

  ramyours2003

  3 replies

  9 years, 2 months ago

  By: Perry Whittle

• Can I use check constraint with unique constarint with other

  Can I Use this : ALTER TABLE dbo.T1 ADD CONSTRAINT C1 UNIQUE (f1,f2) , CHECK (f2 is not null )

  sm_iransoftware

  1 replies

  9 years, 2 months ago

  By: Gail Shaw

• What's the best practices for storing Very Large Tables?

  Hi, We are in the middle of re-designing few tables (namely transaction tables) that would store ve…

  Rahuul

  8 replies

  9 years, 2 months ago

  By: Jeff Moden

• unable to open designer

  Hi, I'm using SQL accounting software now and i have a problem with my designer report. When i usin…

  thammunhui

  1 replies

  9 years, 2 months ago

  By: AndrewDBA

• Reporting Services Configuration Manager -- "E-mail Setttings" cell is locked

  Within SQL 2014 Enterprise edition, Reporting Services Configuration Manager -- "E-mail Setttings" …

  Express12

  1 replies

  9 years, 2 months ago

  By: Express12

• Can I merge 2 or 3 Indexes that Missing_Index query suggested (in this way) ?

  I Run Missing index , And it suggested (for example for one table) these indexes : CREATE INDEX IDX…

  sm_iransoftware

  1 replies

  9 years, 2 months ago

  By: Gail Shaw

• Upgrade/Migrate SQL Server 2008 std to SQL Server 2014

  Hi Gents, Can any one help/suggest me the best practice/approach on how to upgrade/migrate SQL Serv…

  rajkumar_micheal

  6 replies

  9 years, 2 months ago

  By: Grant Fritchey

• How to identify an empty data file?

  I was running an operation to shrink file/emptyfile a data file, and then remove it. It blocked and…

  Cody Konior

  3 replies

  9 years, 2 months ago

  By: greg-1116770

• Detach/Attach of an In Memory OLTP Database to another server

  So I have a use case where we need to backup/restore and detach/attach an InMemory OLTP Database to…

  Paresh Motiwala

  8 replies

  9 years, 2 months ago

  By: Steve Jones - SSC Editor

• How to check connection to an sql server without ssms tools (Example : from web server)

  Hi How to check connection to an sql server without ssms tools (Example : from web server).

  sm_iransoftware

  6 replies

  9 years, 2 months ago

  By: DeWayne_McCallie

• Cumulative Update 3 does not apply

  I have been trying to apply CU3 but I'm still at RTM. I went to a Microsoft download site and downl…

  Welsh Corgi

  5 replies

  9 years, 2 months ago

  By: DeWayne_McCallie

• Seperate Max fileds from the others to Another FileGroup

  Hi we have many max fields in our database . A role in performance says : It's better to seperate t…

  sm_iransoftware

  10 replies

  9 years, 2 months ago

  By: timwell