how sql server scheduler works, can it use all assigned cores smartly?
Wednesday, November 1, 2017 10:32 PM 0 Sign in to vote further investigation: select * from sys.dm_os_schedulers where status = 'VISIBLE ONLINE', I can see only first 4 cores runnable …
What are SMK backup and database certficate for?
Feb 15, 2019 · An example of such event is if you run into a situation where changing the SQL Server service account doesn't grant the new account permission over the SMK. Whenever …
CU Update to Sql Server 2014 hangs for 7 hours
Apr 26, 2017 · How to make applying the SP2 CU5 update faster? Applying patches on test Hyper-V VM's prior to production patching. Message for 7 hours is "Please wait while …
Hide Specific Views and all tables to Particular user in SQL Server …
May 23, 2017 · I have a requirement, In our DB , we have 25 tables and 5 views .I have a few users in SQL server 2008 R2 . I have to give only 1 view access to a particular user - XYZ . …
Error connecting to Azure SQL Database: A connection was …
Jan 20, 2018 · I am trying to connect to a SQL Azure database from my local computer (Windows 10, SQL Server Management Studio v. 17.2). When I attempt to connect from the network at …
Need suggestion Cluster shared disk available check failed - SQL …
Jun 8, 2017 · For SQL Server databases also we are using File share SMB. But during installation of SQL Server 2016 Cluster 'Cluster Shared disk available check failed' in Feature Rules of …
how to get data between two dates from sqlserver
Nov 8, 2017 · Use the following format for date range searches: select convert (varchar,ISSUEDATE,103) from tblHeader where ISSUEDATE >= '20001212' AND …
Rebuild Index In a partitioned DB with ReadOnly filegroups
Jan 22, 2017 · USE [DB]; GO ALTER INDEX [IX] ON [dbo]. [TBL] REBUILD PARTITION =? GO Sunday, January 22, 2017 9:59 AM 0 Sign in to vote DECLARE @TableName sysname = …
unable to load com.microsoft.sqlserver.jdbc.SQLServerDriver to …
May 23, 2017 · From the stack trace, it appears that JDBC driver path for Microsoft SQL Server is not specified or not updated while submitting the job. Make sure you add the jar file path to …
select from openquery inside a transaction doesn't rollback when …
May 7, 2018 · I'm connecting my server to another server which runs on Oracle, using openquery. When something goes wrong the transaction won't rollback. I suspect it has something to do …