Let me know if you have any comment or question. Thanks for reading!
Thursday 8 January 2015
Script all Primary Keys, Unique Constraints and Foreign Keys in a SQL Server database using T-SQL
Yesterday my latest tip about “Script all Primary Keys, Unique Constraints and Foreign Keys in a SQL Server database using T-SQL” has been published, you can read it at http://www.mssqltips.com/sqlservertip/3443/script-all-primary-keys-unique-constraints-and-foreign-keys-in-a-sql-server-database-using-tsql/
Let me know if you have any comment or question. Thanks for reading!
Let me know if you have any comment or question. Thanks for reading!
Friday 19 December 2014
Script out all SQL Server Indexes in a Database using T-SQL
Today my latest tip has been published about “Script out all SQL Server Indexes in a Database using T-SQL” and you can read it at http://www.mssqltips.com/sqlservertip/3441/script-out-all-sql-server-indexes-in-a-database-using-tsql/
Please let me know if you have any comments or questions. Thanks for reading!
Please let me know if you have any comments or questions. Thanks for reading!
Friday 12 December 2014
Script to Drop All Orphaned SQL Server Database Users
Today my latest tip has been published about “Script to Drop All Orphaned SQL Server Database Users” and you can read it at http://www.mssqltips.com/sqlservertip/3439/script-to-drop-all-orphaned-sql-server-database-users/
Please let me know if you have any comments or questions. Thanks for reading!
Please let me know if you have any comments or questions. Thanks for reading!
Thursday 6 November 2014
Microsoft SQL Server 2014 In-Memory OLTP: How fast is it?
My latest tip was published today at MSSQLTips.com, you can read it at http://www.mssqltips.com/sqlservertip/3392/microsoft-sql-server-2014-inmemory-oltp-how-fast-is-it/ . Thanks for reading again!
Categories:
DBA,
In-Memory OLTP,
Performance Tuning
HELLO, I'M PERCY REYES! — a book lover, healthy lifestyle lover... I've been working as a senior SQL Server Database Administrator (DBA) for over 20 years; I'm a three-time awarded Microsoft Data Platform MVP. I'm currently doing a PhD in Computer Science (cryptography) at Loughborough University, England — working on cryptographic Boolean functions, algorithmic cryptanalysis, number theory, and other algebraic aspects of cryptography. READ MORE