SQL Server 2012 CU3 Is Now Available !
The 3rd cumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative...
2012-10-09
1,162 reads
MSSQLFUN
How to avoid windows REBOOT after any operation required restart ?
Issue :
Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different...
2012-10-06
1,222 reads
Is Instance name SQLEXPRESS is fixed for Express edition only ?
A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide...
2012-10-05
673 reads
ReFS || next generation file system for Windows
Q) Why is it named ReFS?
ReFS stands for Resilient File System. Although it is designed to be better in many...
2012-10-03
614 reads
SQL Server 2000 || DBCC CHECKDB logs entried in T-log file
Issue : When running DBCC CHECKDB on SQL server 2000, We are facing t-log growth & blocking.
Cause : DBCC CHECKDB does block in...
2012-10-01
612 reads
Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...
2012-09-28
1,487 reads
SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,424 reads
SQL Server || Change Batch separator
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is...
2012-09-25
2,062 reads
Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Detach & Attach…….Part 2 of 2
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
We have copied...
2012-09-21
1,000 reads
Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Backup & Restore…….Part 1 of 2
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
The full database...
2012-09-19
924 reads
Blogs
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Project Management – Part 1
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Install SQL Server 2025 Container on macOS Using OrbStack
My old Dell XPS that I used for personal stuff started to degrade; well,...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers