Subscribe
-
-
-
-
-
-
-
-
-
Categories
Archives
- October 2022
- July 2020
- May 2020
- September 2019
- April 2019
- December 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- January 2017
- December 2016
- November 2016
- October 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- December 2014
- November 2014
- October 2014
- September 2014
- February 2014
- January 2014
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- October 2012
- September 2012
- August 2012
- May 2012
- March 2012
- November 2011
- September 2011
- August 2011
- June 2011
- May 2011
- March 2011
- February 2011
- January 2011
- December 2010
- July 2010
- May 2010
- February 2010
- January 2010
- December 2009
Meta
-
Tag Archives: T-SQL Scripts
SP_SPACEUSED is giving wrong counts
SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED give wrong counts. Below are some … Continue reading
Posted in SQL Development
Tagged DBCC, Errors, Production Issues, sp_spaceused, SQL Scripts, sql server, SQL Server errors, T-SQL, T-SQL Scripts
1 Comment
How to Encrypt and Decrypt String in Sql Server
How to Encrypt and Decrypt String in Sql Server I recently got a request to obfuscate data at Dev environment. Most of the times these kind of requests come in environments where dealing with sensitive data. We usually do dev … Continue reading
Posted in SQL Development, SQL Server DBA
Tagged Development, Encryption, Scripts, SQL Tips, T-SQL, T-SQL Scripts
Leave a comment
SQL Server database mirroring with screenshots
SQL Server Database Mirroring With Screenshots Introduction: This post takes you through SQL Server Database Mirroring with screenshots in both the ways using T-SQL script and management studio. Also you will learn components involved in SQL Server database … Continue reading