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,161 reads
The 3rd cumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative...
2012-10-09
1,161 reads
Issue :
Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different...
2012-10-06
1,085 reads
A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide...
2012-10-05
670 reads
Q) Why is it named ReFS?
ReFS stands for Resilient File System. Although it is designed to be better in many...
2012-10-03
601 reads
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
599 reads
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,485 reads
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,418 reads
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,051 reads
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
We have copied...
2012-09-21
994 reads
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
The full database...
2012-09-19
922 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers