No announcements
-
0 VotesImproper Results When Using SQLSERVER PS Provider
$RegisteredServers = Get-ChildItem "SQLSERVER:\SQLRegistration\Database Engine Server Group" foreach( $RegSrv in ...Proposed | 2 Replies | 103 Views | Created by RBalasakuri - Friday, October 13, 2017 8:14 PM | Last reply by Albert Ling - 12 hours 45 minutes ago
-
0 Votes
Measuring impact of resource governor on cpu
We wish to use resource governor and want to see the impact of using a cap and max setting on cpu. We are using the perfmoncounter Resource Pool Stats Object. We believe we should be using ...Unanswered | 4 Replies | 121 Views | Created by morshedk - Thursday, October 05, 2017 10:48 AM | Last reply by Lin Leng - 14 hours 22 minutes ago -
0 Votes
Configuring "Maximum Job History Rows Per Job" in SQL Agent
Good afternoon, I'm currently looking at a way to report on failed jobs vs number of job executions on a SQL Server. We have a particular job which runs every 5 ...Unanswered | 2 Replies | 54 Views | Created by AndyB1978 - Monday, October 16, 2017 2:14 PM | Last reply by Teige Gao - 14 hours 46 minutes ago -
1 Votes
SQL Server Configuration Manager: Cannot connect to WMI provider
I installed the latest version (v17.2) of SQL Server on a new PC, and when trying to access "SQL Server 2017 RC1 Configuration Manager" I'm receiving the following error ...Proposed | 4 Replies | 864 Views | Created by callen1 - Saturday, August 19, 2017 3:11 AM | Last reply by KWillis85 - Monday, October 16, 2017 5:56 PM -
0 Votes
Problem to connect
Dear, I was to connect to SQL server, from Eclipse application. How to resolve highlighted problem below? Many ...Unanswered | 3 Replies | 64 Views | Created by HuaMin Chen - Friday, October 13, 2017 9:49 AM | Last reply by Lin Leng - Monday, October 16, 2017 9:14 AM -
0 Votes
How to achieve Blue Green deployment model in SQL Server databases?
Hi, In our Organization, we are using SQL Server Standard edition 2008 R2. Our database sizes are around 200-500 ...Unanswered | 2 Replies | 97 Views | Created by Muthu V - Thursday, October 12, 2017 5:36 AM | Last reply by Teige Gao - Friday, October 13, 2017 7:57 AM -
0 Votes
SQL 2016 Problem with index strategy
I have SQL 2016 SP1 CU5 Enterprise. On this server I have one production database with: TDE Database Mirror - link to DR is 1GB but it isn't dedicated (many other ...Answered | 4 Replies | 113 Views | Created by Maty M - Monday, October 09, 2017 1:20 PM | Last reply by Lin Leng - Tuesday, October 10, 2017 7:26 AM -
0 Votes
SQL database, shrink transaction log - Is this safe?
Shrink>File. On this new opened widnow (Shrink File), i see my 'available free space' is around 10 GB (minimal less then 10GB). Is this mean that my new ...Proposed | 5 Replies | 109 Views | Created by AleksanderKep - Friday, October 06, 2017 11:08 AM | Last reply by TiborK - Friday, October 06, 2017 3:02 PM -
1 Votes
Virtual Log Files in SQL Server
Hi, How to decide , how many are too many VLF's in my ldf file ? Steps to minimize the VLF's What are the best ways to define ...Proposed | 1 Replies | 118 Views | Created by Hemadribabu - Tuesday, October 03, 2017 11:57 AM | Last reply by philfactor - Tuesday, October 03, 2017 12:17 PM -
0 Votes
Query for Grant Access to new Database in SQL Server
Hi, I have created new database but i'm unable to read the database as it is showing error as "The Database Sample_DB is not accessible." Can any one provide me the query ...Proposed | 1 Replies | 219 Views | Created by LuckyAbd - Monday, October 02, 2017 5:25 PM | Last reply by Alberto Morillo - Monday, October 02, 2017 6:24 PM -
0 Votes
SQL 2016 Management Studio: Why does SQL SSMS 2016 need to be elevated to run?
SQL 2016 Management Studio: Why does SQL SSMS 2016 need to be elevated to run? It never needed this in previous versions.Unanswered | 1 Replies | 139 Views | Created by Courtney J Harding - Wednesday, September 27, 2017 1:26 PM | Last reply by Hannah Yu - Thursday, September 28, 2017 6:30 AM -
0 Votes
How to prove that the Sql instance demands more memory
Hi , I have seen that my sql instance in my public cloud environment demands more memory by checking the same in resource monitor . Can ...Proposed | 2 Replies | 155 Views | Created by Hemadribabu - Wednesday, September 27, 2017 11:21 AM | Last reply by Shanky_621 - Wednesday, September 27, 2017 12:02 PM -
0 Votes
SQL Server performing poor
Hi All, I am receiving the complaints from clients that the server is performing poor, they didn't now and dint know to give a clear explanation to say that this is the area ...Proposed | 1 Replies | 139 Views | Created by Hemadribabu - Wednesday, September 27, 2017 4:27 AM | Last reply by mtuxgu2 - Wednesday, September 27, 2017 5:29 AM -
0 Votes
Extended Events Blocked_Process_Report Object_ID and Index_id Incorrect
I have some blocked process reports trapped thru Extended Events that report an OBJECT_ID and INDEX_ID that don't exist in an the sys.objects of the Databases referred to by the Database_id (in fact I ...Unanswered | 1 Replies | 142 Views | Created by JohnHMET - Tuesday, September 26, 2017 4:04 PM | Last reply by Lin Leng - Wednesday, September 27, 2017 2:59 AM -
0 Votes
How do i purge my extended event target file by days
I am using an extended vent session to capture various things like deadlock, long running queries , etc. Now i want that my .xel file contains data of only a month. it purges the data that is older ...Proposed | 1 Replies | 169 Views | Created by Snehil Raj - Tuesday, September 26, 2017 4:23 AM | Last reply by Hannah Yu - Wednesday, September 27, 2017 1:11 AM -
0 Votes
Unable to create new login or resest login password
Hellow Experts, I physically moved My M.S. SQL Server 2000 from one location to another location (like Delhi to Chandigarh) and also changed IP. Now my application is working fine ...Discussion | 2 Replies | 174 Views | Created by neel007 - Tuesday, September 26, 2017 5:57 AM | Last reply by neel007 - Tuesday, September 26, 2017 9:14 AM -
0 Votes
How to deploy stored procedures code in several version of servers?
Hi, I created a group of functions and stored procedures for manages my server farm. I have several servers with more than one version. Every time that I create a ...Proposed | 1 Replies | 151 Views | Created by Gonzalezh - Monday, September 25, 2017 4:25 PM | Last reply by Tom Phillips - Monday, September 25, 2017 5:41 PM -
1 Votes
SQL Script / automation script to check the quality of written Store procedure / SQL Query
Hi Team, <o:p></o:p> Can someone pass on the info to check the quality of store procedure written or sql query<o:p></o:p> 1. Is there ...Unanswered | 8 Replies | 230 Views | Created by Hemadribabu - Friday, September 22, 2017 5:16 AM | Last reply by philfactor - Sunday, September 24, 2017 2:28 PM -
0 Votes
SQL Server MiniDump File cannot be read by WinDBG
Hello Microsoft Team, First of all apologies if I have raised in wrong forum. I am trying work with mini-dumb created by SQL Server ...Proposed | 7 Replies | 297 Views | Created by SenthilP Nathan - Wednesday, September 13, 2017 9:59 AM | Last reply by Tom Phillips - Tuesday, September 19, 2017 11:54 AM -
0 Votes
Column Values of sys.dm_os_sys_memory in SQL 2005 version
Hi, I am looking for all values of the below script in SQL 2005 version. SELECT CONVERT(VARCHAR(100), @@SERVERNAME) AS ...Proposed | 3 Replies | 246 Views | Created by kccrga - Monday, September 18, 2017 6:39 AM | Last reply by Shanky_621 - Tuesday, September 19, 2017 5:37 AM - Items 1 to 20 of 2020 Next ›
No announcements
