The process could not read file due to OS error 3

When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:
The process...

Tuesday Hardware Tidbits, Nov 29, 2011

Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core...

Using OFFSET and FETCH

 
Introduction
Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list...

WAN Optimization Evaluation Review–Part 1

We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s...

What's in a name? SQL Server Magazine becomes SQL Server Pro.

SQL Server Magazine Reveals New Name for the Brand
Did you hear the news?  SQL Server Magazine has a new...

CONCAT() – SQL Server 2012

With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of...

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Error 823: IO error OS cannot read the data
Error: 823,...

DBA in Space: Behind the Scenes—Question 7

This is a continuation of my DBA in Space journal.
Episode seven is filmed at the “Animals in Space” exhibit at...

Execution plan warnings–The final chapter

In my previous posts (here and here), I showed examples of some of the execution plan warnings that have been...