sqlandsql.wordpress.com
SQL Problems and Solutions | Sharing the knowledge & experience of SQL, DBA & BISharing the knowledge & experience of SQL, DBA & BI
http://sqlandsql.wordpress.com/
Sharing the knowledge & experience of SQL, DBA & BI
http://sqlandsql.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.6 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
5
SSL
EXTERNAL LINKS
28
SITE IP
192.0.78.13
LOAD TIME
0.565 sec
SCORE
6.2
SQL Problems and Solutions | Sharing the knowledge & experience of SQL, DBA & BI | sqlandsql.wordpress.com Reviews
https://sqlandsql.wordpress.com
Sharing the knowledge & experience of SQL, DBA & BI
sqlandsql.wordpress.com
Powershell : Script to delete files older than N days | SQL Problems and Solutions
https://sqlandsql.wordpress.com/2015/09/22/powershell-script-to-delete-files-older-than-n-days
SQL Problems and Solutions. Sharing the knowledge and experience of SQL, DBA and BI. Skip to primary content. Powershell : Script to delete files older than N days. September 22, 2015. I recently setup a job to backup transaction logs for live databases every 15 mins. To prevent these files filling up the drive, I needed to to write a script to delete old log files so that it can be automated. Here is the text from Powershell script for anyone to copy and paste. This deletes files older than 7 days.
SQL Server DBA : Optimize Index | SQL Problems and Solutions
https://sqlandsql.wordpress.com/2015/09/24/sql-server-dba-optimize-index
SQL Problems and Solutions. Sharing the knowledge and experience of SQL, DBA and BI. Skip to primary content. SQL Server DBA : Optimize Index. September 24, 2015. SQL Server Database can be very slow if the database is not maintained and monitored properly. One of the maintenance plan is to optimize the indexes in the system periodically. I have recently created a stored procedure to optimize the indexes in the database and scheduled it to run every week. There are two ways the indexes can be optimized.
mayuranp | SQL Problems and Solutions
https://sqlandsql.wordpress.com/author/mayuranp
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...
SQL Server DBA: Database in Recovery Pending state | SQL Problems and Solutions
https://sqlandsql.wordpress.com/2016/05/13/sql-server-dba-database-in-recovery-pending-state
SQL Problems and Solutions. Sharing the knowledge and experience of SQL, DBA and BI. Skip to primary 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. I checked the database and it is in Recovery Pending.
SQL Problems and Solutions | Sharing the knowledge & experience of SQL, DBA & BI | Page 2
https://sqlandsql.wordpress.com/page/2
SQL Problems and Solutions. Sharing the knowledge and experience of SQL, DBA and BI. Skip to primary content. Skip to secondary content. Newer posts →. SQl Server : Backups. November 5, 2014. There are three types of backups:. A full backup contains all the data in a specific database or set of file groups or files, and also enough log to allow for recovering that data. It is the base of both differential backup and transaction log backup. NOT since the last differential backup). Http:/ www.mssqltips...
TOTAL PAGES IN THIS WEBSITE
5
Qlikview : Generate a running total column in load script | Qlikview Tips
https://qlikviewandsql.wordpress.com/2015/04/14/qlikview-generate-a-running-total-column-in-load-script
Qlikview : Generate a running total column in load script. Create a simple view with Sales for each year. Here is the qlikview script to load data from the above view and create a new column for running total. Create a chart to show the Sales and Cumulative Sales against Year. Here is the chart without any filters:. Here is the chart after selecting years from 2013-2016. Here is the qlikview script if you want to copy the code:. RangeSum(Sales, Peek('CumSales') AS CumSales;. This entry was posted in Load.
TOTAL LINKS TO THIS WEBSITE
28
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.
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 | 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.
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...
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.
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...
SQL and Web - a blog about programming SQL databases and web technologies
SQLAndy
Only as Good as Your Auditor. I wrote Only as Good as Your Auditor for SQLServerCentral because its something I’ve explained to people over and over again. For most of us in IT audits are something we tolerate and try to get done as quickly as we can, a test to pass, and because of that we don’t get to see […]. Read more "Only as Good as Your Auditor". How to Become a SQL Server Database Administrator. Read more "How to Become a SQL Server Database Administrator". Read more "April Fools 2017". From time ...
sqlangel.com - This website is for sale! - sqlangel Resources and Information.
The owner of sqlangel.com. Is offering it for sale for an asking price of 449 USD! This page provided to the domain owner free. By Sedo's Domain Parking. Disclaimer: Domain owner and Sedo maintain no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo or domain owner and does not constitute or imply its association, endorsement or recommendation.
