2017-05-19
607 reads
2017-05-19
607 reads
Test Case for Mssql server11Test Case for Mssql server11Test Case for Mssql server11Test Case for Mssql server11 Test Case for...
2017-05-19
622 reads
database snapshot could not be created and the database or table could not be locked
2017-05-18
790 reads
DBCC CheckDB failed with error “database snapshot could not be created and the database or table could not be locked”
Error:...
2017-05-18
3,839 reads
The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note...
2017-03-22
1,016 reads
A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).
Always on\Database...
2017-03-21
1,511 reads
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...
2017-03-13
482 reads
Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA...
2017-03-06
2,504 reads
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,806 reads
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can...
2017-02-07
559 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers