Viewing 15 posts - 2,071 through 2,085 (of 6,041 total)
Check the wait_type column of dm_exec_requests to see if it's in an extended CXPACKET wait state. That's practically obligatory and normal for a large index operation running in parallel mode....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 1:42 pm
Phil Factor (11/7/2016)
That announcement startled everyone in fact, it turned out that this announcement was only about the deprecation of Microsoft...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 1:33 pm
Did the BlkBy column indicate if the process was in a blocked state? If so, then the column would contain the SPID of the blocking process.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 1:15 pm
Eirikur Eiriksson (11/7/2016)
Eric M Russell (11/4/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 11:34 am
TheSQLGuru (11/4/2016)
Eric M Russell (11/4/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 11:27 am
Gary Varga (11/7/2016)
NRudak (11/7/2016)
Not to sound dim but what is "to RMT" in "or telling them to RTM"?Otherwise great article:-D.
Read The Manual.
Is that the same as saying RTFM? Which form...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 11:18 am
Lukewarm support for ODBC? But Microsoft keeps stated the following back in 2011 and keep repeating it.
ODBC is the de-facto industry standard for native relational data access, which is supported...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 11:10 am
The smarter managers, the ones who have a track record of delivering and cultivating the best teams, they have a basic mistrust of employees who act like a know-it-all.
In...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 7:02 am
Or you could leave the columns as is and add page compression, which in this case would probably shrink the table down to 10% or less of it's original size.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 4, 2016 at 2:12 pm
It's strange that there would be about 850 columns containing nothing but NULL. Apparently the original DBA has long since left and can't be sought for guidance.
If the columns truly...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 4, 2016 at 2:07 pm
There is a free tool called 'Data Health Monitor' at databasehealth.com. You basically point it to a SQL Server database, and it performs a variety of analysis at difference levels,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 4, 2016 at 10:26 am
psred (11/3/2016)
Eric I have ran the query you have given and dont see any change before and after compression results.Eirikur it is not the archival data.
So, it didn't estimate any...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 4, 2016 at 9:44 am
Pages in SQL Server tables are basically 8 KB. Data pages can be IN-ROW or ROW-OVERFLOW (contained off-row in space reserved for LOB), and Page or Row Compression works on...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 3, 2016 at 4:23 pm
Are you wanting to know what tables have a foreign key dependency on a table's primary key?
You can use the following procedure call, specifying the primary key table.
sp_depends '<object>' ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 3, 2016 at 4:11 pm
How are you containing the "XML files"; as XML datatype, varchar(max), filestream, etc. ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 3, 2016 at 2:33 pm
Viewing 15 posts - 2,071 through 2,085 (of 6,041 total)