A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.
SQL SERVER – DATE and TIME in SQL Server 2008
What happens when you convert DATE and TIME in SQL Server 2008 to DATETIME? A quick demo shows the midnight and 1900 surprise.
Azure SQL Database and SQL Server: What Changes
Compare Azure SQL Database with SQL Server, including jobs, cross-database access, monitoring, backup control, and operational responsibilities.
Getting SQL Server Data Into Power BI
Power BI can read SQL Server through Import or DirectQuery; stable views, folding, and workload checks keep the database responsive.
ISNULL Versus COALESCE: Return Length Can Change
ISNULL versus COALESCE can preserve different string widths. Make the intended replacement type explicit before characters are truncated.
SQLAuthority News – Professional Development and Community
Hyderabad Techies asked me to open their 16-day online event, TECH THUNDERS, with a keynote. My first talk on Professional Development, in just 15 minutes.
Indexing Foreign Keys
Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.