SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Same query returns different number of rows when run by a different login

  Hello experts, Does anyone know how the same view query could return a different number of rows dep…

  webrunner

  2 replies

  2 years, 12 months ago

  By: webrunner

• Batch Requests/sec ; FROM sys.dm_os_performance_counters -how to get SUM /hour?

  Is it possible to query the SUM(cntr_value) for the previous hour ? (for example, to compare it wit…

  VoldemarG

  2 replies

  3 years ago

  By: VoldemarG

• Using XE to track user table activity

  Hey guys, I am trying to figure out the best and most lightweight way to capture the activity that …

  DVSQL

  1 replies

  3 years ago

  By: Grant Fritchey

• Non Clustered Index

  Quick question If I create Non Clustered index on a table will that help if there is no Clustered I…

  Nita Reddy

  6 replies

  3 years ago

  By: RonKyle

• AG Secondary Replica Database Log file full

  Hello, In my availability group, secondary replica database log file became full. Please let me kno…

  coolchaitu

  3 replies

  3 years ago

  By: andreas.kreuzberg

• Update Statistics

  In AG, mirroring, Log Shipping and Transactional replication if I Update statistics on primary will…

  coolchaitu

  3 replies

  3 years ago

  By: Ant-Green

• Visual Studio Shell update and SSMS

  My Infrastructure department wants to patch VS Shell on my SQL servers. I know it's used for SSMS, …

  JackFromMaine

  1 replies

  3 years ago

  By: JackFromMaine

• Creating data warehouse for multiple systems

  I am trying to setup a data warehouse in our organization. We need to bring data from Finance, Payr…

  don075

  1 replies

  3 years ago

  By: don075

• ADSI linked server domain account issue

  Hi Guys, I have used ADSI linked server objects before to query AD but I have a problem using a ded…

  acrutchley

  1 replies

  3 years ago

  By: acrutchley

• SQL 2016 alwayOn AG failover failure when primary site went down

  Hi, I have an issue that happened during a disaster testing.The setup is the following.2 sites geo…

  ricfors

  16 replies

  3 years ago

  By: Ib

• Query Store vs Extended Events

  Ahoi, i am currently reading "SQL Server 2017 Query Performance Tuning" 5th edition by Grant Fritch…

  ktflash

  5 replies

  3 years ago

  By: Grant Fritchey

• Transaction Logs and Service Stop

  Hi! If the SQL Server service is manually stopped (not task killed) does that commit transactions? …

  cantoris

  2 replies

  3 years ago

  By: Lowell

• WinRm run Invoke-ProcessPartition : A connection cannot be made

  I have a script which is used to connect to a remote SQL Server. It works well when in local Window…

  Peter_Rui

  2 replies

  3 years ago

  By: EdVassie

• Last login for user on spesific table

  Hi Is it possible to get a report for each table in a databse of who last viewed, updated, delteted…

  Dan-ketil

  2 replies

  3 years ago

  By: Ken McKelvey

• Patching AlwaysOn AG

  Hello Everyone, I have Availability Group, one primary replica and one secondary replica. SQL Serve…

  coolchaitu

  6 replies

  3 years ago

  By: EdVassie