|
|
|
|
-
Hardik Doshi Commented 10 Months ago through Blogs
**Nice question Nakul.**
My answer is: **TempDB** (Does not follow: **Durability**)
**Reason:** SQL Server build/create 'TempDB' whenever we restart the server/service. If you are doing some calculation using TempDB (you are in middle of somethin...
|
-
Hardik Doshi Liked 10 Months ago through Blogs
Any database should follow a certain set of properties, collectively called ACID properties - Atomicity, Consistency, Isolation and Durability. Answer this simple question regarding ACID properties and SQL Server databases to win up to two (2) Pluralsig...
|
-
What is MSX / TSX in SQL Agent ?...
|
-
Hardik Doshi Liked 10 Months ago through Blogs
The ROWVERSION column is an auto-incrementing number. The MIN_ACTIVE_ROWVERSION() non-deterministic function can be used to fetch the lowest active ROWVERSION value in the current database....
|
|
|
-
Hardik Doshi Liked 10 Months ago through Tutorials
In this chapter, we will study how to correlate the profiler trace with Windows Profiler Log Data. This is important when you suspect that SQL Server is either being held up by or is the cause of an I/O, memory or processor contention....
|
-
Hardik Doshi Liked 11 Months ago through Blogs
It is a myth that the ROWVERSION column holds a unique value across a database. In this post, I demonstrate that a possibility exists for having duplicate values in a ROWVERSION column when using Bulk-Insert operations (SELECT…INTO)...
|
-
Hardik Doshi refreshed 11 Months ago through Blogs
It is a myth that the ROWVERSION column holds a unique value across a database. In this post, I demonstrate that a possibility exists for having duplicate values in a ROWVERSION column when using Bulk-Insert operations (SELECT…INTO)...
|
|
|