Dropping Indexes
While working on some demos recently, I needed to drop an index for a test. I executed this generic statement...
2013-03-06
1,256 reads
Blog Posts
Getting Started with Microsoft Data Explorer
What is Data Explorer
Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. ...
2013-03-06
1,083 reads
PowerShell Usage In DBA Work — Case Study 1 / 7
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
974 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-06
1,024 reads
SQL Server : Index Part 2 : Structure of Heap Tables
In the earlier post we tried to understand the difference between a table having clustered index and does not have a clustered...
2013-03-06
2,209 reads
SQL Server Community World Tour with GeoFlow
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This...
2013-03-06
705 reads
SSRS: Report Server Usage Report
While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand...
2013-03-06
2,560 reads
Steps to Preload Data into Tables with SSDT
I am working as the data architect and developer on a modern app build with a the team from Modern...
2013-03-06
1,005 reads
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,441 reads
The End of SQLRally in the US
I saw it in the Connector, but just had time to read the minutes to see what was behind the...
2013-03-06
862 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers