Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
4 reads
Nagaraj Venkatesan
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
112 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
5 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...
2017-11-12
544 reads
SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo 🙂
Previous posts on this series was about using "Geo Replication" to...
2017-10-27
387 reads
SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo :)Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few...
2017-10-27
21 reads
SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo :)Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few...
2017-10-27
3 reads
Dynamic Threshold for Statistic Update - SQL Server 2016
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...
2017-09-19 (first published: 2017-09-06)
2,069 reads
Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI
Dear All,
Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses...
2017-09-11 (first published: 2017-08-28)
1,633 reads
Dynamic Threshold for Statistic Update - SQL Server 2016
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
1,559 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers