Viewing 15 posts - 46 through 60 (of 89 total)
In SQL you have several options to associate a set with a row for a multi-valued attribute of an entity. The most obvious solution is a separate table that stores...
July 3, 2013 at 10:01 am
Aside from 'real' temporary procedures (those with a single or double # prefix), I did found a few occasions where procedures on other databases were stored in [tempdb]. In those...
June 26, 2013 at 4:15 am
One other reason to setup back-ups immediately and (performance) monitoring as soon as possible has to do with another phenomena: When a new version is released under time pressure, things...
June 18, 2013 at 1:24 am
There are developers building solutions from a combination of application code (in C# for example) and stored procedures. Actualy, I am one of them. But this combination of skills is...
May 13, 2013 at 10:15 am
Being both a VB.NET developer (yes, VB.NET; coming from a C and C++ background I'd prefer C# but other team members don't) and a SQL Server DBA, spending also one...
May 13, 2013 at 5:07 am
Usualy the contingency mission-critical databases and applications running on company hardware is done at an alternate location, or part of the infrastructure is duplicated to avoid outages. There is no...
April 5, 2013 at 2:00 am
We tried both the CTE approach and the AND clause on the WHEN NOT MATCHED BY SOURCE part to merge rows spanning only a certain period. The performance of the...
April 3, 2013 at 8:19 am
Microsoft Windows provides support for database encryption by leveraging the Data Protection API (DPAPI) which protects the Service Master Key (SMK) which, in turn, protects the Database Master Key (DMK)...
March 7, 2013 at 2:45 am
Mark Dawson (2/22/2013)
Hi Steve,The link you posted in the article appears to be broken.
Hi Steve, at least you fixed that little thing.
February 22, 2013 at 2:05 am
(CAST(@Card AS BIGINT) & 4294967295) should do the job for any card value
January 3, 2013 at 2:34 am
Please notice that the other whitespace characters (TAB, CR, LF, with ASCII codes 9, 13, 10) do not show up in the output of most query tools. These whitespace characters...
January 3, 2013 at 2:26 am
Usualy a SAN is very good in persisting and retrieving large amounts of data like files. However SQL Server needs to persist many small amounts of data under very hard...
December 21, 2012 at 2:24 am
An interesting thought: When will SQL Server offer automated index maintenance? Creating indexes on the fly, dropping them on a 'not used recently' or 'not used frequently' base, would that...
November 29, 2012 at 3:55 am
They asked me to develop a BI solution for a mid sized health care organization. To be more specific: they (the management of the organization) asked me to implement a...
October 29, 2012 at 3:46 am
You should bear in mind that moving business code to the application does introduce a possible loss of integrity. Does the application assure that every set of interdependent modifications are...
October 3, 2012 at 2:41 am
Viewing 15 posts - 46 through 60 (of 89 total)