Viewing 15 posts - 316 through 330 (of 1,243 total)
The data element named “date_key” is absurd; a date is a unit of temporal measurement in a key is how a data element is used in a particular...
----------------------------------------------------
June 28, 2017 at 1:06 am
col1 int NULL
,col2 int NOT NULL IDENTITY (1,1)
,col3 AS COALESCE (col1, col2) PERSISTED NOT NULL
Take a good look at your...
----------------------------------------------------
June 26, 2017 at 2:46 pm
Looks to be a double post >
https://www.sqlservercentral.com/Forums/1882132/Expression-needed-for-Midnight-of-previous-day?PageIndex=1
----------------------------------------------------
June 26, 2017 at 2:37 pm
What is the actual max length of the values in that column? For instance varchar(20) give me up to 20 but I may only get at most 5 characters in...
----------------------------------------------------
June 26, 2017 at 2:28 pm
At a very high level, keep in mind that:
facts are numbers,
dimensions are words (to describe the numbers).
As for loading , that can depend on your business...
----------------------------------------------------
March 31, 2017 at 2:27 pm
Just a quick reminded that you do have the ability to redirect those error rows to a predetermined location , like an errors table and not hold up the rest...
----------------------------------------------------
February 27, 2017 at 2:44 pm
It is always good to have some sample data for better clarity.
Maybe this will help wrap your head around problem. It is a simple illustration that you can...
----------------------------------------------------
February 27, 2017 at 2:16 pm
Agreed. Not sure how it turned out for the OP but this is one where I would push back or at least wipe my hands clean of the bug being...
----------------------------------------------------
January 17, 2017 at 2:04 pm
What is the exact data type of that one field that stores the email message body? Does your new private database support the XML type?
----------------------------------------------------
January 13, 2017 at 5:47 pm
I would think that you already have a copy of these tables from the most recent backup. What is the "private" database that you want to migrate only some tables...
----------------------------------------------------
January 13, 2017 at 5:20 pm
Maybe coordinate with your team to determine who can have access to the file and when. That is what file and folders permission are also built for 🙂 . As...
----------------------------------------------------
January 13, 2017 at 1:38 pm
Are you using quotes around the values in the export? How lengthy is the field(s) that is causing the issue? How are you creating the files?
If migrating a database...
----------------------------------------------------
January 13, 2017 at 1:25 pm
So is this a SQL Server log or a RedGate log? I guess that is what you are wondering. I dont use RedGate personally but you mention source control, the...
----------------------------------------------------
January 13, 2017 at 1:19 pm
If your RRN schema was instead DBO, then the schema "dbo" would be the owner of all the objects involved. As it stands the DBO owner cannot access those what are...
----------------------------------------------------
January 13, 2017 at 1:12 pm
And of course let me not forget... In SSMS you can simply type CTLR+SHIFT+F and that will put the results of the query to a file you define at run...
----------------------------------------------------
January 13, 2017 at 1:00 pm
Viewing 15 posts - 316 through 330 (of 1,243 total)