Vijay
Build PowerBI Real Time Dashboards through Streaming Set with Python
PowerBI supports streaming dataset through an API that can be used to constantly push data to the...
Author: VijayKorapadi Date: 08/15/2017
Generate Unique Identifiers (UID) in U-SQL on Azure Data Lake Analytics with Python extension scripts
U-SQL doesn't support constructs to generate Unique Identifier in Text Files. The script below...
Author: VijayKorapadi Date: 07/10/2017
U-SQL Script with Python extension to detect Invalid input files
The script below validates each of input files in the folder and the python script splits and count...
Author: VijayKorapadi Date: 07/07/2017
SQL Server Workers never yield
SQL Server scheduler/worker is dsigned such that they are Cooperative and the scheduler expects that...
Author: vijaybk Date: 05/06/2009
Deadlock because of Indexed Views
Indexed views can cause deadlock when two or more of the participating tables (in the indexed view)...
Author: vijaybk Date: 05/01/2009
Features supported by Editions of SQL Server 2005/2008
Refer the link for SQL Server 2005 features supported by each of the edtiion...
Author: vijaybk Date: 04/29/2009
Query fn_dblog() for the list of Operation in active transaction of the current session
declare @xactid bigint declare @transactionid nvarchar(28) select @xactid = transaction_id from...
Author: vijaybk Date: 04/29/2009
DMV to observe wait count and wait time on Indexes
select database_id ,object_id ,index_id ,partition_number ,leaf_insert_count ,leaf_delete_count...
Author: vijaybk Date: 02/11/2009
List all the statements in the Plan Cache along with the counts and CPU usage
SELECT t.[text] AS [Adhoc Batch or Object Call], SUBSTRING(t.[text], (qs.[statement_start_offset]/2)...
Author: vijaybk Date: 01/12/2009
Query to list all the databases in the order of CPU usage
USE master SELECT a.[value] AS [dbid] , ISNULL(DB_NAME(CONVERT(INT,a.[value])),'Resource') AS [DB...
Author: vijaybk Date: 01/12/2009
Issue with @@SERVERNAME exceeding 30characters
SQL Server 2005 SP2 has an issue with modifying Agent Job's through Management Studio if the...
Author: vijaybk Date: 08/20/2008
SQL Server Group accounts
SQL Server 2005 and later versions expect the service accounts be changed using Configuration...
Author: vijaybk Date: 08/20/2008
How to view the contents of SQL Server Resource Database
To be able to view the SQL Server Resource Database A) SQL Server must be started in a Single user...
Author: vijaybk Date: 08/20/2008
Datetime Imported from external system
SQL Server accuracy of milliseconds is 1/300th of a second and the possible values are .000, .003...
Author: vijaybk Date: 09/05/2007
Logical flow of a query
The steps below is the logical flow of how a SQL statement is processed A) Cross Join the tables. If...
Author: vijaybk Date: 09/05/2007