2024-09-11
364 reads
Administration
Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes.
2024-08-16
2024-08-14
361 reads
2024-08-05
331 reads
What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-08-01 (first published: 2024-04-26)
4,123 reads
2024-07-31
336 reads
2024-07-22
390 reads
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
2024-07-22
2024-07-10
353 reads
How much Space can I expect to recover from a rebuild after dropping a column?
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,198 reads
Blogs
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Forums
Error when running SSIS package as a job
Hello, I've created an SSIS package that collects data from SQL Servers and databases...
Need help with Cut off time in SQL
Hi, Need this DAX covert SQL T-SQL. Ticket Cutoff Status = VAR TimeOnly =...
Need help with Cut off time in SQL
Hi - Currently, I have this DAX coded in Power BI Ticket Cutoff Status...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers