User Profile


person albydarned   starPREMIUM

Member since 08/6/2019


Karma

5

Public Bits


1
Posted by albydarned 19 days ago
As you may know, COUNT(*) if often very slow on large tables. With this query I have been able to que...
        
SELECT SUM (row_count)
FROM sys.dm_db_partition_stats
WHERE object_id=OBJECT_ID('TableName')   
AND (...        
      
MORE

1
Posted by albydarned 1 month ago
        
<?php echo "Hello there, world!" ?>        
      

0
Posted by albydarned 1 month ago
Useful snippet for converting millisecond timestamp to date in MS SQL Server
        
DECLARE @UTC BIGINT
SET @UTC = 1348203320997 

-- This is a comment

SELECT DATEADD(MILLISECOND, @UTC...        
      
MORE

2
Posted by albydarned 2 months ago
From pythonforbeginners.com
        
# Import the modules
import sys
import random

ans = True

while ans:
    question = raw_input("Ask t...        
      
MORE