sqlpete.wordpress.com
sqlpete | SQL Pete
https://sqlpete.wordpress.com/author/sqlpete
Be good to your data, and it'll be good to you. This user hasn't shared any biographical information. Homepage: https:/ sqlpete.wordpress.com. On February 21, 2017. Because I’m a huge music fan, I own quite a few CDs; rather more than I’d readily admit to! A few years ago, I started ripping my collection to FLAC. Setseed(1234); containerSize - 4500; # roughly DVD size in MB. ItemSize - c(1641,1498,1747,751,1090,164,1602,1020,1126,553); # album sizes in MB. Totals = ( 4499,4499,2194. Partition = (1126,160...
simplesqlserver.com
Tuning | Simple SQL Server
https://simplesqlserver.com/category/sql-server/tuning
A basic approach to SQL Server administration. Recompile Monitoring using XEvents. March 7, 2016. Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it happened to me. Unfortunately for me, that was before I was a proponent of tracing or using XEvents to watch for recompiles. Fortunately for you, the experience changed me, and I enjoy sharing my experiences. Traces of the proc confused me. The statements were running in 0.010 seconds, and there was...This ...
simplesqlserver.com
Indexes | Simple SQL Server
https://simplesqlserver.com/category/sql-server/indexes
A basic approach to SQL Server administration. January 5, 2016. I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a workaround that has a profound affect on server performance, adding to my belief that this is a legitimate bug and leading me to open a Connect Item. Querying the Buffer Pool. The results are surprising in many ways. The bad surprise was a bug which has been harassing me f...
msbiskills.com
SQL Server Resources | Improving my SQL BI Skills
https://msbiskills.com/sql-server-resources
Top Expert of the Week. Improving my SQL BI Skills. Free Tool – DAX Parameter Replacer and Beautifier. SQL Server Interview questions and Answers – Free Download. SQL Performance Tuning Articles. Excellent Collection of T- SQL Puzzles with Multiple Solutions. SQL Server Interview Questions and Answers. SSRS Interview Questions and Answers. DeskBright SQL Interview Questions. Microsoft URL to download Free/Paid E-Books. Books Set – 1. Books Set – 2. Books Set – 3. Free Videos from Microsoft. 200 SQL Serve...
simplesqlserver.com
Key Posts | Simple SQL Server
https://simplesqlserver.com/category/key-posts
A basic approach to SQL Server administration. Category Archives: Key Posts. A list of posts too important to fade into oblivion. December 16, 2015. What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced by as many pertinent, well-tuned, consistently written queries as is reasonable. It’s explaining that last sentence that’s the hard part. In 99999% of environments (ruling out in-memory hash indexes. Does this advice apply to you? Read an...
stevekass.com
Steve Kass » Teaching
http://www.stevekass.com/category/teaching
This is my glass container. Archived Posts from this Category. 22 Sep 2012 0:23. Mitt’s Arithmetic Problem. Posted by Steve under Estimation. I’m a mathematics teacher, and I have some arithmetic problems for you to solve. 1 Mitt drives to the beach and back. Mitt Romney drives 50 miles from. It was 16-2/3 mph , but Mitt’s campaign insists he’s no slowpoke and that he averaged 30 mph. (They also say the trip explains his tan.). 2 Going Dutch with Mitt. 3 Mitt Sees Red. The average of the annual effective...
stevekass.com
Steve Kass » Misc & Plus
http://www.stevekass.com/category/miscellanea
This is my glass container. Archived Posts from this Category. 15 Aug 2013 20:16. How Do You Arrange Your Cheez-Its? Posted by Steve under Food. Comment on this post. As you know from my. How Do You Arrange Your Cheez-Its? Sunshine Cheez-Its are the perfect food. Better yet, some varieties have serving sizes such as 14. Crackers that subdivide into great combinations of perfect cubes and perfect squares. Today’s Cheez-It variety is Scrabble Junior Cheez-It. One serving, can you believe it, is 26. 3 Spide...
sqltecture.net
SQLtecture | Startseite
http://www.sqltecture.net/UserHome.aspx
Das Geheimnis des Erfolges ist die Beständigkeit des Ziels.". 1804-1881]; brit. Politiker. SQL Server Consulting and Training. Der SQL Server wird oft mit den Standardeinstellungen installiert und die Datenbanken sich selbst überlassen. Er macht ja alles automatisch. Nun, ganz so ist es nicht. Durch eine abgestimmte Grundkonfiguration gewinnt man einiges an Leistung und ohne Index- und Statistikwartung kommt schon bald das Thema Performance auf den Tisch. 2013 - Kontakt and Impressum.
sqltecture.net
SQLtecture | Startseite
http://www.sqltecture.net/UserHome.aspx?PageID=1
Das Geheimnis des Erfolges ist die Beständigkeit des Ziels.". 1804-1881]; brit. Politiker. SQL Server Consulting and Training. Der SQL Server wird oft mit den Standardeinstellungen installiert und die Datenbanken sich selbst überlassen. Er macht ja alles automatisch. Nun, ganz so ist es nicht. Durch eine abgestimmte Grundkonfiguration gewinnt man einiges an Leistung und ohne Index- und Statistikwartung kommt schon bald das Thema Performance auf den Tisch. 2013 - Kontakt and Impressum.
sqltecture.com
SQLtecture | Startseite
http://www.sqltecture.com/UserHome.aspx
Das Geheimnis des Erfolges ist die Beständigkeit des Ziels.". 1804-1881]; brit. Politiker. SQL Server Consulting and Training. Der SQL Server wird oft mit den Standardeinstellungen installiert und die Datenbanken sich selbst überlassen. Er macht ja alles automatisch. Nun, ganz so ist es nicht. Durch eine abgestimmte Grundkonfiguration gewinnt man einiges an Leistung und ohne Index- und Statistikwartung kommt schon bald das Thema Performance auf den Tisch. 2013 - Kontakt and Impressum.
SOCIAL ENGAGEMENT