Viewing 15 posts - 3,526 through 3,540 (of 6,041 total)
Here is a little ditty I coded up yesterday to return a quick and dirty difference comparison between two tables having identical column definition and overlapping rowsets. It's new, but...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 21, 2015 at 9:09 am
We already have the SSMS Template Browser to cover commonly used commands and DMV queries.
However, the MERGE statement is complicated enough that it could use a GUI helper, if that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 21, 2015 at 8:44 am
An hour long pre-recorded video covering generic IT security topics, something the employees watch alone from their desk during a lunch break, probably doesn't count for much, if they've seen...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 21, 2015 at 8:17 am
Tim Walker. (8/21/2015)
Eric M Russell (8/20/2015)
GilaMonster (8/20/2015)
Eric M Russell (8/20/2015)
The two combined should sum near the same with two identical plans
The logical reads should be the same with identical plans....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 21, 2015 at 7:55 am
GilaMonster (8/21/2015)
podmate (8/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 21, 2015 at 7:43 am
Eric M Russell (8/20/2015)
ZZartin (8/20/2015)
Eric M Russell (8/20/2015)
Jeff Moden (8/20/2015)
Iwas Bornready (8/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 3:00 pm
Ben Whyall (8/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 2:57 pm
GilaMonster (8/20/2015)
Eric M Russell (8/20/2015)
The two combined should sum near the same with two identical plans
The logical reads should be the same with identical plans. The physical reads may not....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 1:53 pm
ZZartin (8/20/2015)
Eric M Russell (8/20/2015)
Jeff Moden (8/20/2015)
Iwas Bornready (8/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 1:49 pm
Jeff Moden (8/20/2015)
Iwas Bornready (8/20/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 1:12 pm
Are you looking at logical or physical read counts? The two combined should sum near the same with two identical plans, but balance between them may differ depending on how...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 12:54 pm
To optimizes the performance of queries against large tables, SQL Server utilizes a data page cache and read-ahead buffering to reduce physical reads (disk) and maximize logical reads (cache). This...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 12:07 pm
Luis Cazares (8/20/2015)
Eric M Russell (8/20/2015)
Hopefully there hasn't been much action on the server, since the database has been offline.
Well, considering that it has been 6 years now since...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 10:29 am
For users who have a habbit of dropping databases, I've found the following works too.
ALTER SERVER ROLE [sysadmin] DROP MEMBER [username];
And, if they know the password for 'SA' account, then...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 10:18 am
I guess the real questions at this point is not "how to I recover a dropped database?" but rather "how do I recover a deleted file?".
How Volume Shadow...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2015 at 9:04 am
Viewing 15 posts - 3,526 through 3,540 (of 6,041 total)