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,157 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
967 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
667 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
597 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
596 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,480 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,403 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,040 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
990 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
915 reads
Blogs
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
How to Install SQL Server 2025 RC0 on an Azure VM
I wanted to try out the new JSON index which is for the moment...
Prepping for Certification, Part 1 of ?
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Forums
Learning a New Language
Comments posted to this topic are about the item Learning a New Language
is there a way to "detect" schema like changes on a server?
Hi, we have a few people who like to experiment on our prod sql...
Guidelines and Requirements
Comments posted to this topic are about the item Guidelines and Requirements
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers