Viewing 15 posts - 3,346 through 3,360 (of 6,041 total)
mister.magoo (10/6/2015)
select MBT.refID,
hashbytes('MD5',(select MBT.* from (values(null))foo(bar) for xml auto))...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 6:57 am
Of course the RedGate books. If these guys are new to SQL Server and primarily in a support position, then I'd suggest they focus their learning track on backup /...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 3:39 pm
Kim Crosser (10/6/2015)
So - I am using parallel tables that contain the primary keys of the source tables and a computed checksum, used to detect changes to the source tables...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 3:13 pm
Rather than building up a static or dynamic list of OR conditions in WHERE clause, instead load your search keywords into a temp table or table variable, and then join.
select...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 1:39 pm
Kim Crosser (10/6/2015)
...However, I am looking for a solution that doesn't need to be re-coded if a new column is added to the table (for one example).
If you make the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 1:34 pm
The HASHBYTES() function doesn't support a multiple column list like CHECKSUM(), however, a while back I found a solution to this by appending multiple columns after re-casting to VarBinary datatype.
For...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 12:56 pm
Ed Wagner (10/6/2015)
Eric M Russell (10/6/2015)
Welsh Corgi (10/6/2015)
ok, it was September 29th.I have been working around the clock for two weeks 7 days week.
Sorry about that.
It sounds like you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 12:41 pm
Welsh Corgi (10/6/2015)
ok, it was September 29th.I have been working around the clock for two weeks 7 days week.
Sorry about that.
It sounds like you need to take yourself offline...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 12:22 pm
Yes, I believe it's a good idea to explicitly name primary and foreign keys. Not only does it provide clarity in error messages, it also makes writing deployment scripts more...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 12:18 pm
When attempting to click on the url for MinionWare, does anyone else get it blocked by their firewall or anti-virus?
Symantec Endpoint Protection
Web Attack: Malicious Website Script
Redirect 16 detected
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 11:36 am
Given a case-use where the requirement is auditing, we can use triggers to capture only specific DML operations (ex: only updates and deletes but not initial inserts), and we can...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 11:09 am
Can you add an index to a view?
Yes. Indexed views are useful for materializing aggregate queries and / or joins. But it can negatively impact table insert and update performance....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 10:55 am
Markus (10/6/2015)
That would explain why I see her as a blocking thread to another...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 8:57 am
Does DBCC OPENTRAN show any open transactions belonging to that user?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 7:27 am
This sounds similar in concept to Oracle's Flashback related features, which leverages the transaction log and are primarily intended for point-in-time recovery, but it allows for Flashback queries as well...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 7:07 am
Viewing 15 posts - 3,346 through 3,360 (of 6,041 total)