thedailydba.wordpress.com
The Daily DBA | The Ramblings of a Working SQL Server BI Architect and DBAThe Ramblings of a Working SQL Server BI Architect and DBA
http://thedailydba.wordpress.com/
The Ramblings of a Working SQL Server BI Architect and DBA
http://thedailydba.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
1.6 seconds
16x16
32x32
64x64
PAGES IN
THIS WEBSITE
12
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.13
LOAD TIME
1.641 sec
SCORE
6.2
The Daily DBA | The Ramblings of a Working SQL Server BI Architect and DBA | thedailydba.wordpress.com Reviews
https://thedailydba.wordpress.com
The Ramblings of a Working SQL Server BI Architect and DBA
thedailydba.wordpress.com
Batch Large Deletes | The Daily DBA
https://thedailydba.wordpress.com/2014/11/17/batch-large-deletes
The Ramblings of a Working SQL Server BI Architect and DBA. About Logan D. Galler. November 17, 2014. A common issue with large DML operations, like deletes, is the impact on system resources especially tempdb. Even in simple mode large delete operations can have a significant impact on your database and tempdb resources. I often use the following code to batch my delete operations utilizing the t-sql windowing function capabilities (. You could always use GROUP BY and HAVING cnt 1. SET NOCOUNT ON;.
SQL SERVER – Page Life Expectancy (PLE) | The Daily DBA
https://thedailydba.wordpress.com/2015/02/04/sql-server-page-life-expectancy-ple
The Ramblings of a Working SQL Server BI Architect and DBA. About Logan D. Galler. SQL SERVER – Page Life Expectancy (PLE). February 4, 2015. SQL Server Performance Counters. What is Page Life Expectancy (PLE). On of the key performance measures for SQL Server that you will hear constantly is Page Life Expectancy or PLE for short. So What is PLE you ask? SELECT [object name],. FROM sys.dm os performance counters. WHERE [object name] LIKE '%Manager%'. AND [counter name] = 'Page life expectancy'. Again thi...
Date Key Conversions | The Daily DBA
https://thedailydba.wordpress.com/2015/06/08/date-key-conversions
The Ramblings of a Working SQL Server BI Architect and DBA. About Logan D. Galler. June 8, 2015. I am sure like most of us, if you deal with a data warehouse, your dates are stored in as integers in the form yyyymmdd. As such there is often the need to compare these keys to real date or datetime data types. I find myself constantly looking up how to convert date to int and int to date. I thought I ‘d do a quick post to save you the time. Convert Date Key (int) to Date:. Convert Date to DateKey (int):.
SSAS – Error 0xE0040200 | The Daily DBA
https://thedailydba.wordpress.com/2015/03/11/ssas-error-0xe0040200
The Ramblings of a Working SQL Server BI Architect and DBA. About Logan D. Galler. SSAS – Error 0xE0040200. March 11, 2015. I have received this error many times, just infrequently, and every time I get it I spend 30 minutes researching it. While working on an SSAS project today, I was scripting out some dynamic MDX date calculations in the cube. I was able to browse but as soon as I drilled down to a particular date, I received this very non-descript error:. After doing some research AGAIN! You are comm...
Query Execution Plan Red Flags | The Daily DBA
https://thedailydba.wordpress.com/2015/01/23/query-execution-plan-red-flags
The Ramblings of a Working SQL Server BI Architect and DBA. About Logan D. Galler. Query Execution Plan Red Flags. January 23, 2015. This post will outline a few of the major areas of an execution plan to pay attention to when analyzing an query execution plan. Red Flag #1: High Percentage Operations. In a single statement query, begin by searching for the operator with the highest percentage cost. Searching for the highest cost operator allows you to prioritize which problems must be addressed first.
TOTAL PAGES IN THIS WEBSITE
12
The Daily Dawn | Fairy Tales Don't Live Here
I’m Sorry, I’m Out of Fucks to Give Today, Try Again Tomorrow. Continue reading →. The Importance of Closure. All break-ups are hard. We get divorced, we break up with our significant others or life partners, but often people forget that it’s just as hard to break-up with a friend. It happens, sometimes we see ourselves growing apart, sometimes it hits us like a bus and we’re standing there going what the fuck just happened? Continue reading →. Wuv Twue Wuv. (The Princess Bride). Continue reading →.
The Daily Daydream
Thursday, May 20, 2010. I'm too preoccupied with my upcoming vacation to write a proper blog post - I do apologize to my regular readers. My wife and I are going to NYC for the first time! First time - she's been before). If you have any advice on where to go/what to do while We're there, please leave it in the comments. I'll tell you all how it went when I get back on Tuesday. Until then, have a fantastic weekend! Links to this post. Wednesday, May 19, 2010. Rules of the Road. NOBODY WANTS TO RACE YOU.
The Daily Dayne
Week-ap Wednesday - August 12, 2015. Wednesday, August 12, 2015. So, no New Tracks Tuesday yesterday, but have no fear! A couple of great music reviews of some fantastic bands are coming up! In the meantime, let’s Week-ap! First, as we enter the middle of August, we are at the halfway point for the #EverythingAugust Instagram Challenge. I am SO impressed with everyone’s participation in this challenge, and your pics are fantastic! You can check out each day's prompt here. And my time has been precious!
thedailydaysofanasperger.blogspot.com
The daily days of an Asperger
The daily days of an Asperger. Thursday, 29 January 2015. Moving into my new place. It has been a while again since I last made a blogpost. This is because I'm busy with moving into my new place, where I'll be learning how to live on my own. It's all so much! And that's just all the practical stuff. I have problems with change, remember? This is a really big change! This is how I felt about moving in last too. It's hard to write about every aspect of moving into a new place. There is just so much! It has...
The Daily DBA | The Ramblings of a Working SQL Server BI Architect and DBA
The Ramblings of a Working SQL Server BI Architect and DBA. About Logan D. Galler. T-SQL Stored Procedure Tips. July 16, 2015. 10 Things you should know when writing stored procedures. 1) Same case for T-SQL. Upper case is the generally accepted practice, just be consistent. 2) Inspect input parameters. For valid values (numbers, strings etc). 3) Use dynamic sql only when justified and absolutely necessary i.e. SP EXECUTESQL, EXEC(‘SELECT col1.’). 9) Investigate input parameters for SQL injection attacks.
M&A, private equity, hedge funds, Dealmakers: The Deal Pipeline
Out of court Restructuring. The Deal Economy Event. Username (your e-mail address). Need a new ID/Password? Does your firm have a license? Contact Michael Crosby,. Why Nestlé or General Mills could go after Mondelez. Difficulties with government payments play big role in healthcare companies' financial distress. SunGard PE backers eke out a 1.65 return on sale. Auction for PE-backed Ascensus nears final stage. Pearson sells its stake in the Economist Group. Oil and Gas Outlook. The Deal Pipeline's new APP.
M&A, private equity, hedge funds, Dealmakers: The Deal Pipeline
Out of court Restructuring. The Deal Economy Event. Username (your e-mail address). Need a new ID/Password? Does your firm have a license? Contact Michael Crosby,. Why Nestlé or General Mills could go after Mondelez. Difficulties with government payments play big role in healthcare companies' financial distress. SunGard PE backers eke out a 1.65 return on sale. Auction for PE-backed Ascensus nears final stage. Pearson sells its stake in the Economist Group. Oil and Gas Outlook. The Deal Pipeline's new APP.
www.thedailydealadvertisers.com
thedailydealalert.com
The Daily Dealer
Thursday, December 1, 2011. The Art of The McDeal. Are you kidding me? There is an interesting question question raised by this. Wasn't the point of daily deals to introduce new concepts, services and products? I have always found the coolest element to these offers the fact that I can find something brand new, something my friends aren't aware of, a great deal to a great spa, salon, etc. What do you want to see? Tell me what you are buying? Friday, November 4, 2011. What A Stupid Thing To Say. Here is w...
