Viewing 15 posts - 151 through 165 (of 557 total)
The columns in the table are text - can you please advise how should...
March 2, 2018 at 6:13 am
February 27, 2018 at 1:43 am
Sorry for the confusion, I should have paid more attention to the situation. (English is not my first language, so although I do check the things that I have written....
February 26, 2018 at 9:36 am
February 26, 2018 at 7:45 am
February 26, 2018 at 6:52 am
First of all, everybody thanks for participating.
I came up with the next 2 sets of code:
The first set is more compact and can handle longer views.
The...
January 26, 2018 at 8:39 am
Hallo Jonathan and Subramaniam,
I am monitoring what the effect of a table insert/update/delete has on a View.
From the view definition it is possible to determine which fields...
January 25, 2018 at 11:18 am
Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
It's the row version pointer. 14...
August 11, 2017 at 7:18 am
Ok, so it's not the row version pointers. Very curious.
What did DBCC Page dump...
August 11, 2017 at 6:05 am
What's...
August 11, 2017 at 5:47 am
August 10, 2017 at 8:44 am
August 10, 2017 at 6:35 am
On the site:
https://docs.microsoft.com/en-us/sql/relational-databases/statistics/statistics
"
Consider updating statistics for the following conditions:
June 9, 2017 at 6:46 am
Using the solution provided by Jason A. Long.
May 12, 2017 at 3:01 am
Viewing 15 posts - 151 through 165 (of 557 total)