SQL SSMS CTRL+R Not working

No comments

2014-07-30

Tools-> Environment -> Keyboard ->Reset
Suspending and restarting VMware itself.
Restart the service VMware Workstation Server on host
or
taskkill /F /IM vmtoolsd.exe
"C:\Program Files\VMware\VMware Tools\vmtoolsd.exe" -n vmusr
 
Trust, reinstall VMTools is not working.




If you already installed Oracle Client software and have an Oracle Login ready to be used as a Replication user. Below is the solution

Replication has 3 roles: Publication, Distribution and Subscription.
The source is from Oracle, and I want the data from Oracle push to SQL Server and not updatable.
Publication: Oracle
Distribution: SQL Server A
Subscriptions: SQL Server A ( I installedont the same Server/Instance), you can add/change it if you want.

[SQL]Index Usage Practice

No comments

2014-07-09

Today’s practice is “Index usage”.  
Database: Adventurework2012.   Table: Sales.Customer.     T-SQL Scripts: 8 segments
Why i chose the table? Because the table is simple and has 4 Indexes. No including filter, XML index. So it’s simple to test.
image
http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/03/10/certification-update-sql-server-2014.aspx

To help students stay current with upcoming release of SQL Server 2014, all MCSE-level SQL exams (464 through 467) will be updated on April 24, 2014 to cover solutions based on both SQL Server 2012 and 2014 products.


Recently, I’ve found one of my server has lots lock: timeout happened. I am curious what caused this? So I opened SQL Server Profiler to watch the server

Important!!

The online index rebuild can cause index corruption or data loss when it is used together with concurrent queries that modify many rows in Microsoft SQL Server 2012 Service Pack 1 or Microsoft SQL Server 2014. 

This issue occurs when the following conditions are true:
  • The online index build query runs in parallel mode.
  • Deadlock error and a fatal error such as "lock timeout" occur in a specific order

FIX: KB2969896

Purposes: Collection of Connections, Sessions, T-SQLs..etc
  • These DMV could do a collection of I/O-related database management objects(DMOs), also will help you investigate the related I/O info 
  • I/O investigation derived from 
DMVs Used:

    --sys.dm_exec_connections, http://msdn.microsoft.com/en-us/library/ms181509.aspx
    --sys.dm_exec_sessions, http://msdn.microsoft.com/en-us/library/ms176013.aspx
    --sys.dm_exec_requests, http://msdn.microsoft.com/en-us/library/ms177648.aspx
  
    --sys.dm_exec_query_stats, http://msdn.microsoft.com/en-us/library/ms189741.aspx
    --sys.dm_exec_sql_text, http://msdn.microsoft.com/en-us/library/ms181929.aspx