[MSSQLFUN & Decote ITeS becomes a family of 1400 individuals across the globe. Please join us onFacebook & YouTube.] Today, I will take you to the steps of downloading...
2020-05-21
266 reads
[MSSQLFUN & Decote ITeS becomes a family of 1400 individuals across the globe. Please join us on Facebook & YouTube.] Today, We will go through “How to create a...
2020-05-19
92 reads
Thank you, everyone, to stay along with me on this journey. I started this blog for the self repository of SQL Server knowledge articles, Later I made it public...
2020-05-18
26 reads
Hyper-V is a Microsoft feature to create a virtualized environment. Hyper-V is available in your windows OS and you need to enable it from “Turn On or Off Windows...
2020-05-14
132 reads
SQL Server Architecture SQL Server is Microsoft RDMS that works on a client-server architecture. Here, End-user sends a request and SQL Server accepts, process, and share the result with...
2020-05-06
566 reads
SQL Server editions:- · Enterprise – Enterprise edition is the topmost edition with all available features. This is best suited for mission-critical Tier 1 applications. Enterprise edition is the...
2020-04-29
324 reads
RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format...
2020-04-27
74 reads
Dear Friends We are launching the YouTube Channel “Decode ITES”. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public...
2020-04-24
81 reads
Dear Friends Apologies for less knowledge sharing articles for a long time and Big thanks for stay connected with me. I will be coming up with the “SQL Server...
2020-04-24
25 reads
DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period...
2019-01-18
1,334 reads
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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