One of the two SQL Server Speakers of Professional Association for SQL Server in SQLPASS Lahore General Conference. (http://lahore.sqlpass.org/Home.aspx?EventID=5615) 9+ Years of Database Development & Administration experience with Medical Billing, Start up & Financial Companies Microsoft® Certified Solutions Expert: Data Management and Analytics (SQL Server 2012/2014) Microsoft® Certified Solutions Expert: Data Platform (SQL Server 2012/2014)
Monday, December 28, 2009
winupdate86.exe is2010.exe Internet Security 2010 its a fake antivirus and how to remove it
Thursday, November 26, 2009
Export Microsoft SQL Server data to SQLITE
You need to have a login for the mentioned below site, signup and download the utility.
This tool was made by Liron Levi.
Thursday, September 10, 2009
Import MYSQL Data to Microsoft SQL Server 2005
Tuesday, July 28, 2009
Claim Unused space from table after Deletion of rows of after droppping columns
Wednesday, May 27, 2009
Search Suffix using Full Text Search in SQL Server 2005
Its not recommended and not efficient as it requires another column but its a solution which can help you out in some cases.
1. Add a column in your table which stores the reverse of the string
SET NewColumnName = REVERSE(ColumnName)
Tuesday, May 05, 2009
Identify missing indexes in sql server 2005
FROM sys.dm_db_missing_index_details mid
WHERE Database_ID = DB_ID()
ORDER BY 2
Monday, April 06, 2009
Computed Columns in SQL Server 2005
A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, variable, and any combination of these connected by one or more operators. The expression cannot be a subquery.
For example, in the AdventureWorks sample database, the TotalDue column of the Sales.SalesOrderHeader table has the definition: TotalDue AS Subtotal + TaxAmt + Freight.
Friday, March 27, 2009
Users get blocked when access same table while getting Unique IDs
--Procedure which Inserts unique IDs in table and returns the New ID
Wednesday, March 18, 2009
Simple cursor Example in Microsoft SQL Server
DECLARE @getInputBuffer CURSOR
SET @getInputBuffer = CURSOR FOR
SELECT Text FROM Table
FROM @getInputBuffer INTO @String
WHILE @@FETCH_STATUS = 0
Get foreign keys of a table in SQL Server
Find /Remove New Line or Carriage Return Character in String or Text in SQL Server
Delete Duplicate Records Using Common Tabel Expression
Tuesday, January 13, 2009
Solution for Large volume of backup storage on tape with high performance and security