Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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...
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
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...
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...
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)...
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...
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...
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...
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)...
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...
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...
Date: 08/20/2008
SQL Server Group accounts
SQL Server 2005 and later versions expect the service accounts be changed using Configuration...
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...
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...
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...
Date: 09/05/2007