Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Cleaning up SKU's in my master POS DB, need to move SKU's with check digit to temp table

  So when I run this simple query:select * from Inventorywhere Dept_ID = '1123' Department ID 1123 is…

  chef423

  6 replies

  8 years, 10 months ago

  By: TheSQLGuru

• Shared LocalDB .mdf database in Local Network

  I would like to share the .mdf database (one database) of my c# application located on Computer 1 o…

  NadineBen

  8 replies

  8 years, 10 months ago

  By: Lowell

• AlwaysOn feature

  Hi All, Can we setup AlwaysOn  feature on a cluster which don't have quorum drive configured. …

  Raghavender Chavva

  1 replies

  8 years, 10 months ago

  By: Perry Whittle

• AlwaysOn AG - Resolving issue

  hi, I have 2 nodes running AlwaysOn availability groups. When node 1 is primary and I brute force s…

  oskargunn

  2 replies

  8 years, 10 months ago

  By: Perry Whittle

• SQL Cluster on VMs in cross DCs

  Hi All, Will there be any issues if we build SQL 2014 cluster on VMs which hosted on cross DCs.OS w…

  Raghavender Chavva

  3 replies

  8 years, 10 months ago

  By: Raghavender Chavva

• checkdb "Multiple IAM pages for object"

  Hi all, my last checkdb return this error for 6 tables: this is an example:Table error: Multiple IA…

  sgt500

  10 replies

  8 years, 10 months ago

  By: TheSQLGuru

• How to import fixed width flat file using SSIS 2012

  Hi Champs, Please suggest how to import fixed  width flat file to DB  using ssis 2012 ? R…

  ravi@sql

  1 replies

  8 years, 10 months ago

  By: Phil Parkin

• How to use the REPLACE statement efficiently?

  I have a POS database and I need to update the table: Inventory_TagAlongs The column TagAlong_ItemN…

  chef423

  2 replies

  8 years, 10 months ago

  By: chef423

• Query System Tables for Blocking and Replica States

  Hi Guys, I need a query that returns the number blocked processes/waiting processes, however I want…

  alex.sqldba

  1 replies

  8 years, 10 months ago

  By: alex.sqldba

• SSMS 2014 running slow

  Hi I recently uninstalled SSMS 2008R2 and installed 2014 Microsoft SQL Server Management Studio - 1…

  alex.palmer

  2 replies

  8 years, 10 months ago

  By: TheSQLGuru

• Script the table structure ( create table or alter table) for all the tables in the database

  Hi All, I am looking for a way to script out all the tables. views and SP's in a database but accom…

  BoobyB

  4 replies

  8 years, 10 months ago

  By: BoobyB

• Audit Connections to a database

  Hello, I would like to audit all user connections(Login name, Hostname, IP,Program,data and time) t…

  Sreejith!

  5 replies

  8 years, 10 months ago

  By: Steve Jones - SSC Editor

• Very large Indexes (~3TB) and need to rebuild fast

  Hi, Hi,We have a 40 TB DB, and have some big tables and few indexes which are too big now to handle…

  ALIF-662928

  18 replies

  8 years, 10 months ago

  By: harjindersodi

• PLE and BufferPool Contents

  Hello. I have been looking at Memory utilisation for some time now, and am looking for a defin…

  SteveOC

  5 replies

  8 years, 10 months ago

  By: lmarkum

• All Columns as Included

  Hi Experts, Have a select query which is selecting 40 columns .Created index with key columns in wh…

  VastSQL

  9 replies

  8 years, 10 months ago

  By: Matt Miller (4)