End-User Microsoft BI Tools – Clearing up the confusion
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there...
2012-02-27
5,908 reads
Blog Posts
High Availability 9's
This is very important to understand what is high availability 9's, This is a measurement of high availability where you can tell...
2012-02-27
707 reads
How to setup a task to delete the old backup files or log files from the server ?
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...
2012-02-27
1,392 reads
I’m Going to SQL RALLY!
Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...
2012-02-27
756 reads
I’m speaking at SQL Rally 2012
I’ve learned that my session entitled “Introduction to Data Quality Services” has been selected as one of the community choice...
2012-02-27
669 reads
Learn Mirroring with me at SQLRally
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an...
2012-02-27
659 reads
New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,729 reads
Passing BIGINT data to SSRS Sub Report
Few days back one of my team mate complained to me that one particular sub report is failing randomly with
Error:...
2012-02-27
1,405 reads
Presenting Two Sessions at SQLRally
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
972 reads
RYO Maintenance Plan – Update Statistics
Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose...
2012-02-27 (first published: 2012-02-21)
2,535 reads
Blogs
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
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...
Forums
PASS Summit Time
Comments posted to this topic are about the item PASS Summit Time
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...
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