3 November 2015

SQL SERVER – Find Currently Running Query – T-SQL

This is the script which I always had in my archive. Following script find out 
which are the queries running currently on your server.
SELECT 
sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,req.total_elapsed_time
FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
While running above query if you find any query which is running for long time 
it can be killed using following command.
KILL [session_id]

3 June 2015

6 March 2015

Find Column Names From Table in SQL Server

Select Column_Name
From INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME='CustomerOrderDetails'


Id
ExportLicenseNumber
CustomerOrderId
RepairSerialNumber
IsInitialQuote
Revision
CODate
COReceiptDate
PriorityCodeOfCustomer
CustomerRefNumber
CustomerRefDefinition
OrderFromCustomerId
DeliverToCustomerId
ResponsibleLocationId
DeliveryPoint
DeliveryTerms
PaymentTerms
ShipmentViaSupplierId
OtherCommentsAndSpecialInstructions
CurrencyId
LeadTime
LeadTimeUOM
QuoteTypeId
QuotePriceType
ExpectedDeliveryDate
EstimatedDeliveryDate
PartialShipmentAllowed
ShippingAndHandlingPrice
ShippingAndHandlingPriceUSD
OtherChargesType
OtherCharges
OtherChargesUSD
OtherCharges1
OtherCharges1USD
OtherCharges1Type
IncountryTransportation
IncountryTransportationUSD
Insurance
TaxPercentage
DiscountUSD
Discount
ItemReferenceNumber
ReferenceNumber
PartId
PartConditionId
SupplierPartNumber
Quantity
Price
PriceUSD
IsItemClosed
CustomerOrderNotes
OrderFromCustomerAddressId
OrderFromcustomerPOCId
CustomerAddressId
CustomerPOCId
DeliverToAddressId
DeliverToPOCId
SalesExportLicenceRequired
RepairExportLicenceRequired
ExportLicenseTypeId
ItemDecremented
DSP
ExportLicenseCategoriesId
ExportToCountryId
EndUserCountryId
EndUserCustomerId
CFR1234a
CFR1234b
DSP61
WarrantyRequirement
CustomerRefOrderNumber
IsArchived
COCreationDate
CustomerOrderItemNote
DeclaredCustomsValueoftheGoodbyCustomer

5 March 2015