Viewing 15 posts - 3,421 through 3,435 (of 6,041 total)
Jeff Moden (8/19/2015)
Jacob Wilkins (8/19/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 2:09 pm
EricHansen,
What you're proposing is edgy, and perhaps you're earnestly advocating this use of MS Jet database, because that's the database and set of API you're most familiar with. However, it...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 2:03 pm
There are 3rd party applications that can read SQL Server backups, so the file format must be published in public domain. It may not contain all the data necessary to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 12:30 pm
Luis Cazares (9/24/2015)
I'd go up to four. 😎
Careful, when the servers finally do come back online, hopefully the database team won't be slumped face down on their desks snoozing. Or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 12:16 pm
If you're looking for distinct members in one that don't exist in the other, or possibly members that exist between the two, then consider the EXCEPT and INTERSECT operations.
https://msdn.microsoft.com/en-us/library/ms188055.aspx
-- selects...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 11:49 am
Are you using distributed queries, that is a select statement that joins between the local and remote server using four part naming convention?
Or are you using pass-through queries, that is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 11:12 am
SQL Server "Dynamic Data Masking" is a perfect example of an IT vendor re-inventing the wheel and branding it, sort of like "Meta Data Services", "Always On Clustering", or "In-Memory...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 9:09 am
Your English compiles, but it's schizophrenic nonsense. Are you trying to sell of something here?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 7:49 am
As a side note, it appears that SQL Server does take at least some measures to respect the intent of stored procedure compiled using the "with encryption" option, by blocking...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 7:21 am
Regarding the Why of all this; if you are an ISV, and you don't want the business logic of the stored procedures to be in clear text, and the method...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2015 at 7:10 am
Matt Miller (#4) (9/23/2015)
Maxer (9/23/2015)
Eric M Russell (9/23/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 23, 2015 at 1:57 pm
AER (9/22/2015)
I'm a DBA who administer all the Company databases. By 'intellectual property' I meant the scripts that are written in the databases. The problem is that our Client...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 23, 2015 at 1:33 pm
Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is a single transaction, and splitting up a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 23, 2015 at 9:13 am
For Heap tables, wasted page space (ie: ghost records) resulting from deletes and updates is not reclaimed, so that's one consideration. Also for Heap tables the file number, page number,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 23, 2015 at 9:00 am
xsevensinzx (9/23/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 23, 2015 at 7:44 am
Viewing 15 posts - 3,421 through 3,435 (of 6,041 total)