Sql Server -11 “Denali”
New Version Sql Server “11? code name “Denali” CPT1 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/default.aspx Here are experts comment and...
2010-11-10
919 reads
Vinay Thakur
unistall sql server completely (Must Read)
Everyone know how to uninstall sql server very easy : control panel -<Add remove programs ->sql server some times you can...
2010-11-02
549 reads
Communication to Sql server
There are different ways you can communicate to sql server: 1. Shared memory: on the local server 2. Named Pipe:...
2010-10-21
547 reads
Schedule the backup job in Express Edition
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
460 reads
Maintenance Plan "No description found" error
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,764 reads
Lock page memory
When you configure the memory and on your system if other applications are also present, in such cases specially for...
2010-08-16
465 reads
Difference between Mirroring and Log Shipping
It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to...
2010-08-07
856 reads
Important: System Objects/Views/DMV/DMF
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,006 reads
List of indexes and Parallel queries
Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing...
2010-06-03
457 reads
Introduction to Memory configuration
Introduction to Memory configuration Yesterday I was discussion with one of my friend on memory management and internals to expertise in...
2010-05-16
684 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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