A Guide for Installing SQL Server 2008 R2 Reporting Services
Check out my article on SQLServerCentral.com in which I discussed SQL Server 2008 R2 installation setup which you can use to install...
2012-02-14
1,103 reads
Blog Posts
ANUG: Masters at Work
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at...
2012-02-14
1,008 reads
Be careful with two digit years
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...
2012-02-14
750 reads
ColoradoSQL–February 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-02-14
632 reads
Two Webcasts, One Day
If you are interested in listening to my sultry Minnesota voice this Thursday, you have the opportunity to do it…...
2012-02-14
631 reads
Battery Life–The Hidden Cost of Keeping a Laptop
I’ve had my Dell E6500 for about 3-1/2 years now. I’ve recently upgraded the original (back when a SSD was...
2012-02-13
847 reads
Blogsy and my iPad
So this is just a short post to test how well I can type and use Blogsy. If it works...
2012-02-13
680 reads
RYO Maintenance Plan – Enhancement Request
In response to my last post, I got a very interesting comment from Philip:
“I would love to see a way...
2012-02-13 (first published: 2012-02-09)
1,546 reads
Sarasota IT Pro Camp
The first Sarasota IT Pro Camp is being held on Saturday, February 18th 2012 from 9:00 am to 5:00 pm...
2012-02-13
623 reads
See You at SQL Saturday!
I've been asked this question a few times, and Columbia, SC isn't hosting a SQL Saturday this year. Bobby Dimmick...
2012-02-13
1,173 reads
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
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