Today we have a guest editorial where Andy Warren asks you if you know how to ask for things at work. Many IT works struggle to ask for resources, but read on to understand how Andy might help you get more done at your job.
2024-01-29
93 reads
How do you determine if you're at the top of your profession? Andy Warren has a few thoughts today.
2024-01-19
84 reads
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
4,140 reads
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
5,187 reads
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy looks at the ways we can cope when we have been working too much.
2023-09-13 (first published: 2012-02-16)
341 reads
Most of us want more autonomy at work, but it isn't given out without effort. Today Andy Warren has a few thoughts on how to get more freedom from your boss.
2023-07-24
114 reads
Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.
2023-07-21 (first published: 2023-07-06)
145 reads
The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just...
2023-07-07
30 reads
Year 15 for Jacksonville! SQLSaturday Jax was held on May 6 this year, back at the usual location on the campus of the University of North Florida. At the...
2023-06-23 (first published: 2023-06-13)
152 reads
2023-05-12 (first published: 2017-06-09)
313 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