For Hire: Data Analytics/Business Intelligence Expert
Data Analytics/Business Intelligence Expert Strengths: Passion, great with people, loves to learn and teach Weaknesses: Chocolate, fast cars, death Inquire...
2017-08-07
481 reads
Data Analytics/Business Intelligence Expert Strengths: Passion, great with people, loves to learn and teach Weaknesses: Chocolate, fast cars, death Inquire...
2017-08-07
481 reads
It has been over a year since I have blogged, I know… that’s a long time! I have not retired,...
2017-04-26
336 reads
With SQL 2016 around the corner, and my blog without a post this year, I thought I would write about...
2016-04-28 (first published: 2016-04-19)
4,325 reads
Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called...
2016-04-27
1,015 reads
I had this problem where I needed to gather Transaction Log information on multiple databases and check for valuable statistics on...
2015-11-09 (first published: 2015-11-02)
2,019 reads
SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables....
2015-10-01
1,274 reads
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
482 reads
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
647 reads
Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing...
2015-06-24
669 reads
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014...
2015-03-29
989 reads
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Comments posted to this topic are about the item PASS Summit Time
I have a backup of full, differential and transaction log setup for our database....
Hello everyone, I hope you can help me. I have a table with measurement...
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers