Viewing 15 posts - 10,516 through 10,530 (of 59,065 total)
November 21, 2018 at 8:00 am
From the article:
I also know that consumers can be emotional and look to leave a service, like a mobile phone provider, after a breach, to move to...
November 20, 2018 at 9:37 pm
November 20, 2018 at 9:19 pm
In order to keep the searches for the other columns nasty fast, you should set the table option (using sp_tableoption) to store the LOBs (description column) out of row.
As...
November 20, 2018 at 9:00 pm
With the ExifTool by Phil Harvey I make a number of .CSV files from...
November 20, 2018 at 8:10 am
November 20, 2018 at 7:31 am
Have a look at the functions that was a team effort at the following link.
http://www.sqlservercentral.com/scripts/String+Function/141686/
The "DigitsOnlyEE" function was actually developed on a different thread. Big...
November 19, 2018 at 8:44 pm
November 19, 2018 at 8:20 pm
November 19, 2018 at 7:43 pm
If there is no Clustered Index on the table, then this will work...
ALTER TABLE dbo.SomeTable
ADD CONSTRAINT PK_SomeTable PRIMARY KEY CLUSTERED (ID)
November 19, 2018 at 7:39 pm
Or... you could do it in T-SQL and not have to worry about SSIS or C#. 😉 Maybe even a persisted computed column on the table might work, eh?
November 19, 2018 at 7:18 pm
leehbi - Monday, November 19, 2018 2:04 AMThanks for comments - partitioning is the way to go with snapshots.
Careful now... While partitioning...
November 19, 2018 at 7:21 am
Viewing 15 posts - 10,516 through 10,530 (of 59,065 total)