sqlandmore.blogspot.com
SQL Tips
Friday, August 16, 2013. When you try running DEKi report on Infoview, you might end up getting “GetLovField” Error message. This issue can occur when you change prompts from mono to multi or from multi to mono. In order to get rid of this issue you will need to remove the existing prompt and re-do it. This should fix your issue. Wednesday, June 6, 2012. Friday, May 25, 2012. Last day of month =LastDayOfMonth( Month ). First day of month =DayNumberOfWeek( Month ). Thursday, December 15, 2011. How to prom...
sqlando.com
Tools for SQL DBAs
Tools for SQL DBAs. Tools for SQL DBAs. July 15, 2014. Starting, Swissknife DB. The “SwissknifeDB” is a project started 1 year ago, which goal is to give tools for easy SQL Server Administration, This tools are functions and procedures which encapsulate common task and querys in a easy-use format, which helps any DBA in their daily adminitration tasks. The format of “SwissknifeDB” is a database that you have to upload to your server in order to start using the tools. 8230;See you soon! Tools for SQL DBAs.
sqlandplsql.com
sqlandplsql.com | Oracle, PL/SQL, SQL, MySQL, Ubuntu and more
Oracle, PL/SQL, SQL, MySQL, Ubuntu and more. 5 ways to delete duplicate records in Oracle. Install Notepad in Ubuntu. 5 ways to test Oracle RefCursor results. Oracle interview questions and answers. Difference between Trunc and Round function. Notepad Tips and Tricks. Oracle PL/SQL interview questions and answers. Memory test for Browsers in Ubuntu. Latest version of Oracle database – Oracle 12c. Force quit Ubuntu 12.04. Install Gimp 2.8 in Ubuntu. Remote desktop in ubuntu 12.04. Install Skype in Ubuntu.
sqlandscapemaintenance.com
sqlandscapeservices.com
Healthy yards is our business! S&Q Landscape Maintenance specializes in commercial and residential landscape maintenance in Salem, Keizer and surrounding areas. We appreciate you considering us in your search for the perfect landscape Maintenanace provider. We look forward to working with you soon. Experience Quality at an Affordable Price.
sqlandsiva.blogspot.com
SQL Server Learnings
Started Primarily for SQL Learning's later extended to accommodate Domain, Technology, Testing, Work, Life related learning’s. No one is harder on a talented person than the person themselves" - Linda Wilkinson. Trust your guts and don't follow the herd" ; "Validate direction not destination" ;. August 13, 2015. Matrix and Determinants (Basics). Back to School and basics. These posts are for my on-line references. Rectangular Array of Numbers in rows and columns. Example - [5,2,-3]. A B = [9,2,10]. Deter...
sqlandsiva.wordpress.com
sqlandsiva | This WordPress.com site is the cat’s pajamas
This WordPress.com site is the cat’s pajamas. Protected: JBehave Getting Started. November 20, 2013. This content is password protected. To view it please enter your password below:. Latest New Testing Tools in 2012. January 1, 2013. With Cloud Adoption and Cloud based products we have testing products based on Cloud environments. SOASTA – Cloud based performance testing tool for web and mobile apps. Sauce Labs – Cloud based cross browser testing tool. 8211; Native A/B testing service for iOS and Android.
sqlandsql.wordpress.com
SQL Problems and Solutions | Sharing the knowledge & experience of SQL, DBA & BI
SQL Problems and Solutions. Sharing the knowledge and experience of SQL, DBA and BI. Skip to primary content. Skip to secondary content. SQL Server DBA: Database in Recovery Pending state. May 13, 2016. I have recently encountered an issue where one of the databases suddenly moved to Recovery Pending status. I came to know this error when an SSRS report returned the error below:. Database [dbname] cannot be opened due to inaccessible files or insufficient memory or disk space. September 24, 2015. It is n...
sqlandssrs.blogspot.com
Technical: Tips, Tricks & Features
Tips, Tricks and Features. Tips, Tricks and Features. I created this blog so I can have a centralized location for tips, tricks, and features I have researched. The majority of the information on this blog is related to database, reporting, and scripting, but other technical information may be added. I hope the information on this blog will be helpful to others and please feel free to share thoughts, ideas, and code. Thursday, August 13, 2015. Create a New Folder on Windows Desktop. Save the new name.
sqlandthelike.blogspot.com
SQL and the like
SQL and the like. My thoughts and ramblings on SQL Server and related technologies. Monday, 7 September 2009. Use of ranking functions result in an inefficient query plan. In SQL2005 (9.00.4207.00), if you use a ranking function within a view or CTE, then an inefficient query plan can be produced. First off in Adventure works create this index. And then consider these similar queries:. You should now see two vastly different query plans. Notice in “Query 2” that Filter? Thursday, 9 July 2009. Then , as S...
SOCIAL ENGAGEMENT