Viewing 15 posts - 1 through 15 (of 819 total)
The multi platform environment for SQL Server is exciting. If the drivers client side are designed correctly then the applications themselves should be agnostic to which platform (Linux or...
December 30, 2016 at 10:57 am
Should work OK. Try it on a test instance (you have one of course).
The compatibility level of the restored database will be at the 2005 level if I remember...
December 19, 2016 at 8:12 am
December 14, 2016 at 1:30 am
One possible downside of the fast release pace is the expense of upgrading. Paying new license fee each year or two is going to be very unattractive for some...
December 11, 2016 at 2:48 pm
jonas.gunnarsson 52434 (11/22/2016)Nice feature using dbo.sp_HelpText.Note, that all CREATE is changed to ALTER!
jonas.gunnarsson 52434 (11/22/2016)
Note, that all CREATE is changed to ALTER!
My proc used to contain CREATE TABLE and now says ALTER TABLE. Is this script why?...
November 22, 2016 at 9:39 pm
I'm all in favor of using identity column surrogate keys. They're narrow, non-volatile, ever-increasing and unique.
IDENTITY, by itself, is not guaranteed to be unique. Takes a unique constraint...
November 22, 2016 at 9:00 pm
Phil Factor (11/22/2016)
There's nothing that says a table can't have more than one unique index on it.
it certainly can. It is no crime but it is a sign...
November 22, 2016 at 5:02 pm
Stephanie I have a structure for shipped orders. When shipped we instant archive the order there and remove it from the active orders structure. For me this does...
November 22, 2016 at 1:30 pm
I have been accused of over normalization. "Why all of these tables?" I was asked what was the cost of adding tables. I took two days and...
November 20, 2016 at 1:25 pm
Ed Wagner (10/10/2016)The first step to getting out of the RBAR mindset is to recognize that you have it.
Ed Wagner (10/10/2016)
Kind of like any other addiction. First step is...
October 10, 2016 at 10:45 am
Given things like your [Customers] and [Orders] tables you would have to have a unique index on [Customers].[CustomerID] in order to set up the FK from the [Orders] table. ...
September 23, 2016 at 11:15 pm
Most developers begin with a row-by-row education then...
September 9, 2016 at 11:03 pm
Gary Varga (4/21/2016)
April 21, 2016 at 1:17 pm
On one WinForms project that I remember there was a very long process that made the app appear dead. We got complaints. The developer added a progress bar...
April 9, 2016 at 1:21 pm
Eric M Russell (1/27/2016)I assume the goal of inferring foreign key relationships is for documentation purposes...
Eric M Russell (1/27/2016)
Actually FKs for the purpose of documentation only seems like a bad idea.
The FK should...
January 27, 2016 at 9:30 am