February #Meme15 Assignment
It’s been a couple months now since a number of us got together to share how we use social networks...
2012-02-09
569 reads
Blog Posts
SQL Server 2012 (“Denali”): Data Quality Services
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...
2012-02-09 (first published: 2012-02-06)
2,696 reads
SQL Server Product Life Cycle
Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range.
The...
2012-02-09
1,121 reads
SSAS: Currency Conversion in MDX Script
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
982 reads
Stages of the Game?
Saw this post by Seth Godin on Stages of the Game. Interesting, I identified with it – I’m competitive, and competing...
2012-02-09
825 reads
[Shameless Plug] Can We Have Your Vote?
[Shameless Plug] Can We Have Your Vote?
SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...
2012-02-08
1,053 reads
A Script A Day - Day 8 - Non Clustered Index Information
Today's script comes to you from London where I am at my head office for my appraisal! Lets hope it...
2012-02-08
443 reads
AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-08
1,074 reads
An Unclassy Error
I saw this on a TV while walking through a store. More than a but amusing, but not too helpful...
2012-02-08
622 reads
Goals 2012
As I have wanted to do each year, here is my goals post for 2012. Last year I set out to do this very same thing but was very...
2012-02-08
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Forums
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
Question of the Day
Incremental Statistics
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