Vijay
PowerBI supports streaming dataset through an API that can be used to constantly push data to the...
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...
Date: 07/10/2017
The script below validates each of input files in the folder and the python script splits and count...
Date: 07/07/2017
SQL Server scheduler/worker is dsigned such that they are Cooperative and the scheduler expects that...
Date: 05/06/2009
Indexed views can cause deadlock when two or more of the participating tables (in the indexed view)...
Date: 05/01/2009
Refer the link for SQL Server 2005 features supported by each of the edtiion...
Date: 04/29/2009
declare @xactid bigint declare @transactionid nvarchar(28) select @xactid = transaction_id from...
Date: 04/29/2009
select database_id ,object_id ,index_id ,partition_number ,leaf_insert_count ,leaf_delete_count...
Date: 02/11/2009
SELECT t.[text] AS [Adhoc Batch or Object Call], SUBSTRING(t.[text], (qs.[statement_start_offset]/2)...
Date: 01/12/2009
USE master SELECT a.[value] AS [dbid] , ISNULL(DB_NAME(CONVERT(INT,a.[value])),'Resource') AS [DB...
Date: 01/12/2009
SQL Server 2005 SP2 has an issue with modifying Agent Job's through Management Studio if the...
Date: 08/20/2008
SQL Server 2005 and later versions expect the service accounts be changed using Configuration...
Date: 08/20/2008
To be able to view the SQL Server Resource Database A) SQL Server must be started in a Single user...
Date: 08/20/2008
SQL Server accuracy of milliseconds is 1/300th of a second and the possible values are .000, .003...
Date: 09/05/2007
The steps below is the logical flow of how a SQL statement is processed A) Cross Join the tables. If...
Date: 09/05/2007